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-4 section-1

31
When you type into SQL*Plus and press enter, the statement will be finished and executed.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
32
Oracle allows the ORDER BY clause in view definitions.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
33
Oracle does NOT support a CASCADE UPDATE constraint.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
34
Sequences guarantee valid surrogate key values.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
35
Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
36
Oracle commands, column names, table names, view names and all other database elements are case sensitive.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
37
If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
38
The only time that case matters is inside quotation marks of strings.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
39
You can use the DROP statement to remove structures from the database.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
40
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board