Examine this command:SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;Which two statements are true? (Choose two.)
A database is open READ WRITE and the instance has multiple sessions some of which have active transactions.You execute this command:SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;Which three are true about the active transactions? (Choose three.)
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.Which two statements are true? (Choose two.)
Which action takes place when a file checkpoint occurs?
An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted.Which two types of lock are held by the transaction? (Choose two.)
Examine this command executed on a client that is remote from the database server.SQL> CONNECT hr/hr@orcl -Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
