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

Home / Database / Managing Databases With Oracle

31.
When you type into SQL*Plus and press enter, the statement will be finished and executed.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

32.
Oracle allows the ORDER BY clause in view definitions.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

33.
Oracle does NOT support a CASCADE UPDATE constraint.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

34.
Sequences guarantee valid surrogate key values.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

35.
Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

36.
Oracle commands, column names, table names, view names and all other database elements are case sensitive.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

37.
If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

38.
The only time that case matters is inside quotation marks of strings.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

39.
You can use the DROP statement to remove structures from the database.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

40.
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4