Question 1 of 25
Hints left: 3
Q1
An Oracle System Change Number (SCN):
Q2
The default extension for an Oracle SQL*Plus file is:
Q3
What Oracle backup and recover file contains user and system data?
Q4
SQL*Plus will finish the statement and execute it when the user types in this:
Q5
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Q6
Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Q7
What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Q8
Which of the following is NOT an Oracle-supported trigger?
Q9
After a table has been created, its structure can be modified using the SQL command:
Q10
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?
Q11
The default extension for SQL*Plus is .sql.
Q12
Which SQL phrase is not supported by Oracle?
Q13
To see the contents of the SQL*Plus buffer, type:
Q14
Which of the following is not true of SQL views?
Q15
When you type Start FILENAME, the statement in your file will be executed automatically.
Q16
Oracle directly supports the definition of surrogate keys.
Q17
Money is defined in Oracle with the Currency data type.
Q18
The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
Q19
Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
Q20
Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
Q21
SQL*Plus is a text editor.
Q22
The semicolon terminates a SQL statement (and executes it).
Q23
To obtain the structure of an Oracle table, the command to use is:
Q24
Which of the following is not true about modifying table columns?
Q25
You can check on the status of tables with the DESCRIBE or DESC command.