Oracle Oracle Partner Network 1Z0-497 Questions & Answers

• Question 1:

  Which process is responsible for writing the contents of database buffers to data files?

  A. Process Monitor process (PMON)

  B. Listener Registration process (LREG)

  C. System Monitor process (SMON)

  D. Database Writer process (DBW)

  E. Log Writer process (LGWR)

  F. Checkpoint process (CKPT)

  Correct Answer: D

  Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254 (see database writer process (DBW))

• Question 2:

  You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

  A. You can drop the PDB only if it is closed.

  B. You can drop the seed PDB, but you cannot create any other PDB within the CDB.

  C. You can drop the PDB and keep the data files to be reused by another PDB.

  D. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

  Correct Answer: AD

• Question 3:

  Which two statements are true about a buffer cache?

  A. When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

  B. A buffer cache stores copies of data blocks from all files of the database.

  C. Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

  D. A buffer cache always resides completely in System Global Area (SGA).

  E. A buffer cache contains exactly three pools: default, keep, and recycle pool.

  Correct Answer: AE

• Question 4:

  YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

  A. S sqlplus / as sysdba SQL> restart;

  B. S sqlplus / as sysdba SQL> startup immediate;

  C. S rman target / RMAN> Startup

  D. S sqlplus / as sysdba SQL> startup open recover;

  E. S srvctl start database -db SORACLE_SID

  Correct Answer: ADE

  C: The following command starts an instance, reads the initialization parameters from the default location, and then mounts and opens the database. (You can optionally specify a PFILE clause.)

  STARTUP

  D: If you know that media recovery is required, you can start an instance, mount a database to the instance, and have the recovery process automatically start by using the STARTUP command with the RECOVER clause:

  STARTUP OPEN RECOVER

  E: To start or stop your entire cluster database, that is, all of the instances and its enabled services, enter the following SRVCTL commands:

  $ srvctl start database -db db_unique_name [-startoption start_options]

• Question 5:

  Which three are initialization parameters for backup and recovery?

  A. CLONEDB

  B. FILESYSTEMIO_OPTIONS

  C. DB_CREATE_FILE_DEST

  D. RECYCLEBIN

  E. TAPE_ASYNCH_IO

  Correct Answer: ADE

• Question 6:

  In which situation would you use static database registration for a listener?

  A. when multiple databases are to be registered with the listener

  B. when DBAs need to connect remotely to start up the database instance

  C. when users need to connect the database instance by using the host naming method

  D. when the database instance to be registered with the listener is configured in shared server mode

  Correct Answer: C

• Question 7:

  What happens when you execute these SQL statements?

  ALTER SYSTEM SET SGA_TARGET = 992M; ALTER SYSTEM SET SHARED_POOL_SIZE = 0; ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0; ALTER SYSTEM SET DB_CACHE_SIZE = 0; ALTER SYSTEM SET STREAMS POOL SIZE = 0;

  A. The database stops (shutdown abort).

  B. B) The database Stops (shutdown immediate).

  C. You activate Automatic Shared Memory Management.

  D. You get an error message.

  Correct Answer: C

  Reference: http://www.orafaq.com/forum/t/67825/0/ (see the second post)

• Question 8:

  Which two statements about Global Data Services (GDS) are correct?

  A. GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).

  B. GDS helps in performing data replication.

  C. GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

  D. GDS helps to perform database failovers, and does not require Data Guard Broker.

  E. The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.

  Correct Answer: AC

  Reference: http://www.oracle.com/technetwork/database/availability/global-data-services-12c- wp1964780.pdf (page 8)

• Question 9:

  Examine the command below:

  BEGIN DBMS_REDACT.ADD_POLICY(

  object_schema => 'mavis',

  object_name => 'cust_info',

  column_name => 'emp_id',

  policy_name => 'redact_cust_ids',

  function_type => DBMS_REDACT.REGEXP,

  expression => '1=1',

  regexp_pattern => '(\d\d\d)(\d\d)(\d\d\d\d)',

  regexp_replace_string => 'XXXXX\3',

  regexp_position => 1,

  regexp_occurrence => 0,

  regexp_match_parameter => 'i',

  policy_description => 'Redacts customer IDs',

  column_description => 'emp_id contains employee ID numbers'); END;

  /

  What do the regexp_pattern and regexp_replace_string parameters accomplish?

  A. They find a pattern of nine digits; break the digits into three groups that contain the first three, the next two and then the last four digits; and replace all digits with XXXXX concatenated with the last four digits.

  B. They find a pattern of six digits; break the digits into two groups that contain the first five, and then the last digit; and replace all digits with XXXXX concatenated with the last digit.

  C. They find a pattern of nine digits and display the digits as XXXXX XX XXXX.

  D. They find a pattern of nine digits and display the first five digits as XXXXX and the last four digits as 3333.

  Correct Answer: A

• Question 10:

  Which normalization level is adopted in real-world database systems?

  A. 1NF

  B. 2NF

  C. 3NF

  D. BCNF

  Correct Answer: A