Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?
Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc. What will happen and why?
You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?
You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?
You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full. During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=IMMEDIATE. Are you sure you wish to stop the job ([yes]/no): yes. Which two statements are true about the job?
What memory structure caches the data dictionary providing access to all database user processes?
