A One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
B One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D None of the tables are recovered from the Recycle Bin, and the statement returns an error.
You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace. How would you perform this?()
单选题查看答案
You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session: ALTER SESSION ENABLE RESUMABLE; Which command could you issue to enable the resumable space allocation feature at the session level?()
单选题查看答案
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas?()
单选题查看答案
You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2. What is the correct sequence RMAN commands to restore and recover the data file?()
单选题查看答案
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query, you find that the first two updates are not listed. What could be the reason?()
单选题查看答案
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this? ()
单选题查看答案
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
多选题查看答案
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task()
单选题查看答案
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information?()
多选题查看答案