Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 391:

  Which statement is true regarding the startup of a database instance?

  A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.

  B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.

  C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the immediate option or the abort option.

  D. Media recovery is required when the database is shut down by using either the immediate option or the abort option.

  E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

  Correct Answer: E

  References: http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm

• Question 392:

  Examine the memory-related parameters set in the SPFILE of an Oracle database:

  

  Which statement is true?

  A. Only SGA components are sized automatically.

  B. Memory is dynamically re-allocated between the SGA and PGA as needed.

  C. The size of the PGA cannot grow automatically beyond 500 MB.

  D. The value of the MEMORY_TARGET parameter cannot be changed dynamically.

  Correct Answer: B

• Question 393:

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

  A. Blocks belonging to an extent can be spread across multiple data files.

  B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.

  C. The blocks of a newly allocated extent, although free, may have been used before.

  D. 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.

  Correct Answer: BC

• Question 394:

  You execute the commands:

  

  Which two statements are true? (Choose two.)

  A. The create user command fails if any role with the name SIDNEY exists in the database.

  B. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.

  C. The user Sidney is created but cannot connect to the database instance because no profile is assigned to the user.

  D. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.

  E. The user Sidney is created and authenticated by the operating system.

  Correct Answer: AD

• Question 395:

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

  

  A. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.

  B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.

  C. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.

  D. The database instance was restarted before the execution of the second query.

  Correct Answer: D

• Question 396:

  Which two statements are true? (Choose two.)

  A. A role cannot be assigned external authentication.

  B. A role can be granted to other roles.

  C. A role can contain both system and object privileges.

  D. The predefined RESOURCE role includes the UNLIMITED TABLESPACE privilege.

  E. All roles are owned by the SYS user.

  F. The predefined CONNECT role is always automatically granted to all new users at the time of their creation.

  Correct Answer: BC

• Question 397:

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

  A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.

  B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.

  C. Use the DBMS_PDB package to clone an existing PDB.

  D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

  E. 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.

  Correct Answer: ACD

  Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB).

  This statement enables you to perform the following tasks:

  *

  (A) Create a PDB by using the seed as a template

  Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.

  *

  (C) Create a PDB by cloning an existing PDB

  Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB.

  The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files.

  * Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB

  Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.

• Question 398:

  As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.

  Which command would you execute to create the database link?

  A. CREATE DATABASE LINK HQ USING 'HQ';

  B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING `HQ';

  C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

  D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

  Correct Answer: C

• Question 399:

  What happens if a maintenance window closes before a job that collects optimizer statistics completes?

  A. The job is terminated and the gathered statistics are not saved.

  B. The job is terminated but the gathered statistics are not published.

  C. The job continues to run until all statistics are gathered.

  D. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

  Correct Answer: D

  The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window.

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431

• Question 400:

  You plan to create a database by using the Database Configuration Assistant (DBCA), with the following

  specifications:

  Applications will connect to the database via a middle tier.

  The number of concurrent user connections will be high.

  The database will have mixed workload, with the execution of complex BI queries scheduled at night.

  Which DBCA option must you choose to create the database?

  A. a General Purpose database template with default memory allocation

  B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled

  C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

  D. a default database configuration

  Correct Answer: C

  References: