Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
our database is in the MOUNT state and you execute the following command to open it: ALTER DATABASE OPEN What two actions are performed as a result of this command?()
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
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/x7f01031: insufficient privileges 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 in MOUNT mode: ALTER DATABASE ARCHIVELOG; Where is the information that the database is now in ARCHIVELOG mode stored?()
You execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (SIMPLE_PLAN =>’prod_plan’, CONSUMER_GROUP1 => ’fin_group1’, GROUP1_CPU => 80, CONSUMER_GROUP2 => ’pay_group1’, GROUP2_CPU => 20); END; Which three statements are true? ()
You execute the following command toauditdatabase activities: SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command()
You execute the following command to audit the database activities: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?()
Which two code fragments will execute the method doStuff() in a separate thread?()
In order to change the system runlevel and execute /etc/inittab entries based on the new runlevel, which of the following commands should be performed?()