1z0-062

1z0-062 practice questions, page 5 of 16, with answer review and explanations.

Question 21

Which two statements are true about extents? (Choose two.)

  1. Blocks belonging to an extent can be spread across multiple data files.
  2. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
  3. The blocks of a newly allocated extent, although free, may have been used before.
  4. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Question 22

You execute the commands: Which two statements are true? (Choose two.)

  1. The create user command fails if any role with the name Sidney exists in the database.
  2. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.
  3. The user Sidney is created but cannot connect to the database instance because no profile is default.
  4. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.
  5. The user Sidney is created and authenticated by the operating system.

Question 23

Examine the query and its output: What might have caused three of the alerts to disappear?

  1. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
  2. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
  3. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.
  4. The database instance was restarted before the execution of the second query.

Question 24

Which two statements are true? (Choose two.)

  1. A role cannot be assigned external authentication.
  2. A role can be granted to other roles.
  3. A role can contain both system and object privileges.
  4. The predefined resource role includes the unlimited_tablespace privilege.
  5. All roles are owned by the sys user.
  6. The predefined connect role is always automatically granted to all new users at the time of their creation.

Question 25

Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

  1. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
  2. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
  3. Use the DBMS_PDB package to clone an existing PDB.
  4. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
  5. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.