ExamVeda
Login
Home

Managing Databases with Oracle - Database MCQ Questions and answers- Technical Aptitude

Managing Databases with Oracle(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-3 section-1

21
Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
22
Money is defined in Oracle with the Currency data type.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
23
The default extension for SQL*Plus is .sql.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
24
The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
26
The semicolon terminates a SQL statement (and executes it).
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
27
SQL*Plus is a text editor.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
28
When you type Start FILENAME, the statement in your file will be executed automatically.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
You can check on the status of tables with the DESCRIBE or DESC command.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
30
Oracle directly supports the definition of surrogate keys.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board