1z0-182

1z0-182 practice questions, page 4 of 6, with answer review and explanations.

Question 16

Which two actions can you perform using DBCA for an existing database? (Choose two.)

  1. Create a template that can be used to clone the database.
  2. Change the character set.
  3. Change the server mode from dedicated to shared, and vice versa.
  4. Create an additional listener.
  5. Create nonstandard block size tablespaces.

Question 17

A script abc.sql must be executed to perform a certain task. User HR 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?

  1. The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.
  2. The command fails because the script must refer to the full path name.
  3. The command succeeds and HR will be connected to the orcl database instance, and the abcscript will be executed.
  4. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
  5. The command fails and reports an error because @ is used twice.

Question 18

When using DBCA to clone a remote PDB, which of the following best describes the outcome if the cloning operation fails citing insufficient privileges for the user in the remote PDB?

  1. The database links is dropped, and the cloned PDB is opened.
  2. The cloned PDB is mounted, and the database link in retained.
  3. The cloned PDB is opened, and the database link is retained.
  4. The database link is dropped, and the cloned PDB is mounted.

Question 19

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?

  1. PDB1 must be in read-only mode.
  2. TESTPDB must be in read-only mode after the cloning process is complete.
  3. Both CDBs need to be in local undo mode.
  4. PDB1 must be taken offline before the cloning process begins.

Question 20

Which two statements are true concerning logical and physical database structures? (Choose two.)

  1. A segment can span multiple data files in some tablespaces.
  2. A segment’s blocks can be of different sizes.
  3. A segment might have only one extent.
  4. All tablespaces may have one or more data files.
  5. Segments can span multiple tablespaces.