A The database does not record flashback logs for MY_TABLESPACE
B The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?()
单选题查看答案
Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you?()
单选题查看答案
You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()
单选题查看答案
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
单选题查看答案
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16?()
单选题查看答案
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid?()
单选题查看答案
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
单选题查看答案
You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()
单选题查看答案
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database()
单选题查看答案
Your alert log file has the following information: Tue May 25 17:43: 38 2004 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly?()
单选题查看答案