You execute the following PL/SQL:Which two statements are true?()
You execute the following Recovery Manager (RMAN) commands in he following order: BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST; Which two tasks are performed by these commands?()
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()
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?()
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
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?()
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()
Which two steps are the result of associating a blade server?()
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?()
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started?()
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
Which two are correct steps in taking a binary backup of MyISAM tables?()
Which two of the following steps are necessary to configure inter-VLAN routing between multilayer switches?()
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()
Which two of these steps are minimum requirements to configure OSPFv3 under IPv6?()
You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?()
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?()
Which two statements are true regarding the execution of the correlated subqueries?()
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?()