database-managing-databases-with-oracle Related Question Answers
1. Which of the following is not true of SQL views?
2. SQLPlus will finish the statement and execute it when the user types in this:
4. After a table has been created, its structure can be modified using the SQL command:
5. Which of the following is not true about modifying table columns?
6. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
7. What Oracle backup and recover file contains user and system data?
8. When using SQLPlus, Oracle commands, column names, table names and all other database elements:
9. Which SQL phrase is not supported by Oracle?
10. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
11. You have linked SQLPlus to an external text editor. To invoke the text editor for use within SQLPlus, which command do you use?
13. An Oracle System Change Number (SCN):
14. To obtain the structure of an Oracle table, the command to use is:
16. Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
19. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
20. Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
23. When you type Start FILENAME, the statement in your file will be executed automatically.
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions
Question ANSWER With Solution