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