View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: What is the multiplexing level in the preceding backup process()
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()
Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
In a page there is a div (I guess it was a div) and you need to execute a javascript function when if first moves the mouse over the element.()
You want to create a consumer group, GROUP1, and you execute the following command in the command/x7fline interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’); This command errors out displaying the following message: ERROR at line 1: ORA/x7f29371: pending area is not active ORA/x7f06512: at "SYS.DBMS_RMIN", line 115 ORA/x7f06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA/x7f06512: at line 1 What action would you take to overcome this error?()
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command()
What RMAN command is used to execute a tablespace point-in-time recovery?()
The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? ()
You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. IAsyncResult ar = cmd.BeginExecuteReader( ); You need to execute a method named DoWork( ) that takes one second to run while the SQL query is executing.DoWork( ) must run as many times as possible while the SQL query is executing. Which code segment should you use?()
You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’); This command errorsout displaying the following message: ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_RMIN", line 115 ORA-06512: at SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1 What action would you take to overcome this error?()