Question 1 . Question : TCO 3 - The ____ tablespace contains Oracle optional software metadata and data. Student Answer: UNDO USERS SYSTEM SYSAUX Instructor Explanation: Page 138 Points Received: 2 of 2 Comments: Question 2.Question : TCO 3 - ____ a redo log group ensures that you can perform a complete, up-to-the-minute recovery of your database in the event of catastrophic failure, such as the loss of a disk drive that held your SYSTEM tablespace. Student Answer: Replicating Multiplexing Duplexing Archiving Instructor Explanation: Page 169 Points Received: 2 of 2 Comments: Question 3 Question : TCO 3 - ____ are the logical layer of an Oracle database.
. Student Answer: Datafiles Tablespaces Redo log files Control files Instructor Explanation: Page 138 Points Received: 2 of 2 Comments: Question 4 . Question : TCO 3 - When you type the ____ command, the redo log buffer’s redo records are moved to the redo log files. Student Answer: COMMIT UPDATE INSERT CREATE TABLE Instructor Explanation: Page 159 Points Received: 2 of 2 Comments: Question 5.Question : TCO 6 - All of the data dictionary views except those starting with the ____ prefix have public synonyms and public permission to query.
You've reached the end of your free preview.
Want to read all 6 pages?
- Fall '14
- Oracle Database, Student Answer, Command pattern