Oracle Oracle Partner Network 1Z0-497 Questions & Answers

• Question 41:

  When executing shutdown abort in a pluggable database (PDB), you ____________.

  A. shut down abort the CDB

  B. shut down abort the PDB

  C. shut down immediate the PDB

  D. shut down immediate the CDB

  Correct Answer: B

• Question 42:

  Which is the default isolation level in Oracle Database 12c?

  A. serializable

  B. read-only

  C. read committed

  D. read uncommitted

  Correct Answer: C

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm#CNCPT1312 (see the sentence that comes right after table 13-1)

• Question 43:

  Which four statements about users in Oracle Database 12c are correct?

  A. A common user cannot have the same name as any local user across all PDBs.

  B. A common user can be created only in the root container.

  C. A local user with the proper privileges can also create a common user.

  D. If a PDB is closed, the common and local users of the PDB are not visible.

  E. A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause.

  F. A common user is one that has the same username and authentication credentials across multiple PDBs.

  Correct Answer: ABEF

• Question 44:

  Which three DBA operations can be performed by using Oracle SQL Developer?

  A. database backup and recovery using RMAN

  B. performance tuning operations such as generation of AWR, ADDM, and ASH reports

  C. storage configuration for archive logs and control files

  D. storage configuration for data files and redo log groups

  E. database status view and Data Pump export and import jobs

  Correct Answer: ABE

  A: 1.11.5 RMAN Backup/Recovery

  Includes options related to database backup and recovery.

  B: 1.17.4 ASH and AWR reports

  The ASH and AWR reports list information provided by the Active Session History (ASH) and Automated

  Workload Repository (AWR) features

  E:

  1.11.3 Database Status

  Includes options for displaying status information about the database.

  1.11.4 Data Pump

  Includes options for using the Oracle Data Pump Export and Import utilities

  Reference: Using DBA Features in SQL Developer URL: http://docs.oracle.com/cd/E35137_01/appdev.32/e35117/intro.htm#CEGDIAEC

• Question 45:

  John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases-John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-intime recovery of their PDBs. Which statement is true?

  A. Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.

  B. Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.

  C. Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

  D. Recovery of individual PDBs is not possible at all.

  Correct Answer: A

• Question 46:

  In this SQL statement, what is the partitioning criteria?

  CREATE TABLE books_part

  PARTITION BY RANGE (cell_id) (

  PARTITION p0l VALUES LESS THAN (2),

  PARTITION p02 VALUES LESS THAN (3) ,

  . . .

  PARTITION pl4 VALUES LESS THAN (15),

  PARTITION pl5 VALUES LESS THAN (16),

  PARTITION pl6 VALUES LESS THAN (MAXVALUE)

  )

  AS SELECT * FROM books;

  A. books

  B. pxx

  C. MAXVALUE

  D. cell_id

  E. There is no partitioning criteria.

  Correct Answer: D

• Question 47:

  Examine the command: sqlplus /nolog

  In which scenario would this command execute successfully?

  A. only from the server, if the database instance is not up

  B. from either a client or server, even if the database instance is not up

  C. from either a client or server, only if the database instance is up, and the command connects the session to the instance

  D. from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

  Correct Answer: B

• Question 48:

  What must you do to an application for it to take advantage of partitioning?

  A. recompile it

  B. rewrite its SQL queries

  C. relink

  D. rework the applications schema

  E. nothing; it is transparent

  Correct Answer: E

  Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14220/partconc.htm

• Question 49:

  Which three statements about common and local roles are true?

  A. When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

  B. Local roles can be granted only to local users.

  C. Common roles can be granted to both local and common users.

  D. A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

  E. Common roles can be created in the root and PDBs.

  Correct Answer: ACD

• Question 50:

  Which statement regarding Oracle Active Data Guard 12c is false?

  A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

  B. It provides new support for DML to global temporary tables and the use of sequences in the standby database.

  C. It repairs block corruptions detected in the primary or standby database.

  D. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

  E. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

  Correct Answer: A