Oracle Oracle Partner Network 1Z0-497 Questions & Answers

• Question 11:

  Which database feature can be used for organizing data when there is a very large amount of data?

  A. Index

  B. Partitioning

  C. Triggers

  D. Row-level security

  E. Database vault

  Correct Answer: B

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT999 (see very large databases)

• Question 12:

  Which four items exist in the root of a CDB, but not in the PDBs?

  A. shared UNDO and default database temporary tablespace

  B. Oracle-supplied metadata

  C. shared Oracle-supplied data

  D. CDB views providing information across PDBs

  E. application tablespaces

  F. local temporary tablespaces

  G. local users and local roles H. non-shared local metadata

  Correct Answer: ABCD

• Question 13:

  Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

  A. Asynchronous redo transport with Data Guard

  B. Synchronous redo transport with Data Guard

  C. Active Data Guard Far Sync

  D. Data Guard SQL Apply

  Correct Answer: BC

  B: The synchronous redo transport mode transmits redo data synchronously with respect to transaction commitment. A transaction cannot commit until all redo generated by that transaction has been successfully sent to every enabled redo transport destination that uses the synchronous redo transport mode. Note that although there is no limit on the distance between a primary database and a SYNC redo transport destination, transaction commit latency increases as network latency increases between a primary database and a SYNC redo transport destination.

  C: An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.

  Far sync instances are part of the Oracle Active Data Guard Far Sync feature, which requires an Oracle Active Data Guard license.

  Reference:

• Question 14:

  Which three statements about replication options are true?

  A. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

  B. Oracle Streams is deprecated in Oracle Database 12c Release 1.

  C. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

  D. Oracle Database Advanced Queuing is independent of Oracle Streams.

  E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

  Correct Answer: BCE

• Question 15:

  Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

  A. less instance overhead

  B. increased storage cost

  C. minor application changes

  D. fast and easy provisioning

  E. same time needed for patching and upgrade as in the previous release

  F. isolation

  Correct Answer: ADE

• Question 16:

  Which statement is true regarding this connect string?

  (DESCRIPTION (FAILOVER=on) (ADDRESS_LIST=

  (LOAD_BALANCE=ON)

  (ADDRESS=(host=sales-east1) (port=1522) )

  (ADDRESS=(host=sales-east2)(port=1522))

  (ADDRESS=(host=sales-east3) (port=1522) ))

  (ADDRESS_LIST=

  (LOAD_BALANCE=ON)

  (ADDRESS=(host=sales-west1) (port=1522) )

  (ADDRESS=(host=sales-west2) (port=JS22))

  (ADDRESS=(host=sales-west3) (port=lS22) ) )

  (CONNECT_DATA=

  (SERVICE_NAME=sales)

  (REGION=east)))

  A. It contains three global service managers in the client's local region (east).

  B. Client-side load balancing has been enabled only for the global service managers within the client's buddy (west).

  C. Connect-time failover between regions has not been enabled.

  D. The REGION parameter is optional.

  Correct Answer: D

• Question 17:

  You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What must take place before the block can be written to disk?

  A. The buffer must be written to flash cache.

  B. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

  C. The modified data block must be moved from the LRU list to the write queue.

  D. The database must advance the checkpoint.

  Correct Answer: B

• Question 18:

  In Oracle Database 12c, when does a transaction begin?

  A. when a transaction ID is allocated for it.

  B. when a user explicitly issues a "begin" statement

  C. when a transaction is assigned to an available undo data segment to record undo entries for the new transaction

  D. when the first executable SQL statement is encountered

  Correct Answer: D

  A transaction begins when the first executable SQL statement is encountered. An executable SQL statement is a SQL statement that generates calls to a database instance, including DML and DDL statements and the SET TRANSACTION statement.

• Question 19:

  All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:

  SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029'; 123 rows updated.

  SQL> DELETE FROM persons WHERE exp='Y'; 3 rows deleted.

  The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

  A. all sessions of the HR user

  B. all sessions of the HR user and the SYS user

  C. the session of the HR user that executed the commands

  D. all sessions for which database users have access privileges to the PERSONS table

  Correct Answer: A

  Without issue of commit by the HR user, the other users are unable to see the changes even though they have access.

• Question 20:

  Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

  A. These administrative privileges enable you to connect to the database only if the database is open.

  B. After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

  C. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

  D. Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

  Correct Answer: AB