What would be the impact of this setting?

You are using an Automatic Storage Management (ASM) instance to manage the files ofyour production database. You have two disk groups, DG1and DG2with one device each.In the parameter file of the production database, the following parameters have beenspecified:DB_CREATE_ONLINE_LOG_DEST_1 = ‘+dg1’DB_CREATE_ONLINE_LOG_DEST_2 = ‘+dg2’What would be the impact of this setting? A.When a new log group is […]

Read More

which action should you take?

Your database operates inARCHIVELO Gmode. User-managed consistent backups are performed every Sunday night.On Tuesday, client A drops a table at 8:00A.m. as follows:SQL> DROP TABLE cust_ord PURGE;Table dropped.Client B executes a query at 9:00 A.m. on the same table as follows:SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord*ERROR at line 1:ORA-00942: table or view does […]

Read More

which situation would the above recovery be required?

You performed an incomplete recovery on your Oracle Database 10g database using thefollowing command:SQL> RECOVER DATABASE2 UNTIL TIME ‘2004-08-05:12:10:03’3 USING BACKUP CONTROLFILE;In which situation would the above recovery be required? A.A user table was lost at the specified time. B.A redo log file was lost at the specified time. C.The backup control file is on […]

Read More

What would be the impact of this setting?

While creating a job class using the DBMS_SCHEDULER package, you set the logging levelto LOGGING_RUNS. What would be the impact of this setting? A.Oracle Scheduler would write detailed information to the job log for each run of each job in the job class. B.Oracle Scheduler would write detailed information to the job log for the […]

Read More

which scenarios would you rebuild an index?

In which scenarios would you rebuild an index? (Choose all that apply.) A.when you need to disable the index usage B.when you need to change storage options C.when you need to enable index monitoring D.when you need to move the index to another tablespace Show Answer

Read More

which scenarios would you rebuild an index?

In which scenarios would you rebuild an index? (Choose all that apply.) A.when you need to disable the index usage B.when you need to change storage options C.when you need to enable index monitoring D.when you need to move the index to another tablespace Show Answer

Read More