Managing Databases with Oracle Questions

• After a table has been created, its structure can be modified using the SQL command:
• What Oracle backup and recover file contains user and system data?
• Which statement about sequences is not true?
• Of the three ways to create an Oracle database, which one is the easiest and most recommended?
• Which of the following is not true about indexes?
• When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
• 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?
• To see the contents of the SQL*Plus buffer, type:
• What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
• Which of the following is not true about modifying table columns?
• The default extension for an Oracle SQL*Plus file is:
• Which prefixes are available to Oracle triggers?
• In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
• Which of the following is NOT an Oracle-supported trigger?
• An Oracle System Change Number (SCN):
• Which of the following is not true of SQL views?
• To obtain the structure of an Oracle table, the command to use is:
• SQL*Plus will finish the statement and execute it when the user types in this:
• Which SQL phrase is not supported by Oracle?
• What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?