READ Free Dumps For Oracle- 1z0-001
| Question ID 8136 | Which data type should you use for interest rates with varying and unpredictable decimal places such as 1.234, 3.4, 5 and 1.23?
|
| Option A | LONG.
|
| Option B | NUMBER
|
| Option C | NUMBER(p, s)
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because NUMBER data type gives the best choice to store interest rates with varying and unpredictable decimal places. Incorrect Answers: A: Data type LONG can be used to store interest rates but it will allocate to much data blocks to keep data. Also processing of LONG data type is more difficult as NUMBER, tables with LONG data types have some restrictions. C: Question says about rates with varying and unpredictable decimal places, which eliminates answer with data type NUMBER(p, s), where p and s are fixed values. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 390 Chapter 8: Managing Database Objects I
| Question ID 8137 | Which statement is true if a drop table command is executed on a table?
|
| Option A | Only a DBA can execute the drop table command.
|
| Option B | Any appending transactions on the table are rolled back.
|
| Option C | The structure of the table remains in the database and the indexes are deleted.
|
| Option D | The drop table command can be executed on a table on which there are pending transactions.
|
| Option E | The table structure and its deleted data can't be rolled back and restored once the drop table command is executed.
|
| Correct Answer | E |
Explanation Explanation/Reference: Explanation: Answer E is correct because after the DROP TABLE command you can not roll back deleted data. It's possible only using recovery procedures. Incorrect Answers: A: Not only DBA can execute the DROP TABLE command, users with DROP ANY TABLE system privilege can do this command for all tables and also users can drop tables inside their own schemas without restrictions. B: After executing the DROP TABLE command no transactions related with this table can be rolled back. C: After usage of the DROP TABLE command the structure of the table and all related indexes are deleted also. D: The DROP TABLE command cannot be executed on a table with pending transactions. Transactions need to be finished or rolled back before usage the DROP TABLE command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 398-399 Chapter 8: Managing Database Objects I