Free Oracle 1Z0-182 Exam Dumps Questions & Answers

You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of the following is a necessary prerequisite for the hot remote clone?

• A.PDB1 must be in read-only mode.
• B.Both CDBs need to be in local undo mode.
• C.TESTPDB must be in read-only mode after the cloning process is complete.
• D.PDB1 must be taken offline before the cloning process begins.

Which two statements are true about database instances and Real Application Clusters (RAC)?

• A.A RAC database must have two or more instances.
• B.Two RAC databases can share their instances.
• C.A RAC database must have three or more instances.
• D.A RAC database can have instances on separate servers.
• E.A RAC database can have one instance.

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

• A.In the SPFILE, PFILE, and memory
• B.Only in memory
• C.In the SPFILE and PFILE
• D.Only in the SPFILE
• E.In the SPFILE and memory

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?

• A.The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.
• B.The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
• C.The command fails because the script must refer to the full path name.
• D.The command fails and reports an error because @ is used twice.
• E.The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?

• A.It allows a role to have unlimited space in any tablespace in the database.
• B.By default, users have no quota on their default permanent tablespace.
• C.It allows a user to have unlimited space only in their default permanent tablespace.
• D.It allows a user to have unlimited space in any tablespace in the database.
• E.It is overridden by a space quota specified for the user.