Managing Databases With Oracle MCQs with Explanations

Instance Failure is the correct answer to “What type of failure occurs when Oracle fails due to an operating system or computer hardware failure”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Sequences guarantee valid surrogate key values. is the correct answer to “Which statement about sequences is not true”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Both :new and :old is the correct answer to “Which prefixes are available to Oracle triggers”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

To see the errors, enter SHOW ERRORS in SQL*Plus. is the correct answer to “In creating a procedure, you may get a message if you have compile errors. Which of the following is true”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Indexes are created with the ALTER TABLE command. is the correct answer to “Which of the following is not true about indexes”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Oracle views cannot use the ORDER BY clause in view definitions. is the correct answer to “Which of the following is not true of SQL views”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

A semicolon ( ; ) followed by [Enter]. is the correct answer to “SQL*Plus will finish the statement and execute it when the user types in this:”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

DURING is the correct answer to “Which of the following is NOT an Oracle-supported trigger”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

ALTER TABLE [TableName]. is the correct answer to “After a table has been created, its structure can be modified using the SQL command:”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

You cannot increase or decrease the number of decimal places. is the correct answer to “Which of the following is not true about modifying table columns”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Using the Oracle Database Configuration Assistant. is the correct answer to “Of the three ways to create an Oracle database, which one is the easiest and most recommended”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Datafile is the correct answer to “What Oracle backup and recover file contains user and system data”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

are case insensitive. is the correct answer to “When using SQL*Plus, Oracle commands, column names, table names and all other database elements:”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

ON UPDATE CASCADE is the correct answer to “Which SQL phrase is not supported by Oracle”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Consistent backup is the correct answer to “What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

Edit [FileName] is the correct answer to “You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

.sql is the correct answer to “The default extension for an Oracle SQL*Plus file is:”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

is a value that is incremented whenever database changes are made. is the correct answer to “An Oracle System Change Number (SCN):”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

DESCRIBE [TableName]. is the correct answer to “To obtain the structure of an Oracle table, the command to use is:”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

LIST is the correct answer to “To see the contents of the SQL*Plus buffer, type:”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “Money is defined in Oracle with the Currency data type.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “The default extension for SQL*Plus is .sql.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “The left-leaning slash tells Oracle to execute whatever statement is in the buffer.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “The semicolon terminates a SQL statement (and executes it).”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “SQL*Plus is a text editor.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “When you type Start FILENAME, the statement in your file will be executed automatically.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “You can check on the status of tables with the DESCRIBE or DESC command.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “Oracle directly supports the definition of surrogate keys.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “When you type into SQL*Plus and press enter, the statement will be finished and executed.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “Oracle allows the ORDER BY clause in view definitions.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “Oracle does NOT support a CASCADE UPDATE constraint.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “Sequences guarantee valid surrogate key values.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

False is the correct answer to “Oracle commands, column names, table names, view names and all other database elements are case sensitive.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “The only time that case matters is inside quotation marks of strings.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “You can use the DROP statement to remove structures from the database.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.

True is the correct answer to “Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.”. This question is standard in competitive examination syllabi for Managing Databases With Oracle.