Oracle Oracle Certifications 1Z0-497 Questions & Answers

• Question 51:

  Which two statements are true about the B-tree Index?

  A. The leaf blocks in the index are doubly linked.

  B. The leaf node stores a bitmap for each key value.

  C. Rows with a NULL value in key columns also have entries in the Index.

  D. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

  Correct Answer: BD

  Reference: http://www.siue.edu/~dbock/cmis565/module12-indexes.htm

• Question 52:

  Which two statements are true about listeners?

  A. Listeners use only the TCP/IP protocol.

  B. Multiple listener processes can run simultaneously on a host.

  C. Multiple database instances can be registered with a single listener,

  D. Listener-related errors can be traced only at the administrative level.

  E. Only one database instance can be registered with a single listener at any time.

  Correct Answer: BE

  B: A network may contain multiple local and remote listeners.

  E: Oracle Net Listener is a separate process that runs on the database server. It receives incoming client connection requests and manages the traffic of these requests to the database server.

  Incorrect:

  Not A: Because the configuration parameters have default values, it is possible to start and use a listener

  with no configuration. This default listener has a name of LISTENER, supports no services on startup, and

  listens on the following TCP/IP protocol address:

  (ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

• Question 53:

  You want to start a global service on your database. Which three conditions must be met?

  A. The database is open and registered with a global service manager.

  B. The service has been disabled on that database.

  C. The database role is different from the role attribute of the service.

  D. The replication lag on the database does not exceed the maximum value specified for the service.

  E. The service has reached its cardinality defined by the number of preferred databases.

  F. No other database in the pool is a better candidate for starting the service.

  Correct Answer: ABD

  A: To provide global services, a database must be added to a Global Data Services pool. The valid node checking for registration (VNCR) feature provides the ability to configure and dynamically update a set of IP addresses, host names, or subnets from which registration requests are allowed by the global service manager. Database instance registration with a global service manager succeeds only when the request originates from a valid node.

  * Starting a Global Service

  The gdsctl start service command is used to start an existing service on the Global Data Services pool databases.

  GDSCTL>start service -service emp_report1 -gdspool hr If the -role parameter is specified for the service, the service only starts on the databases in which the role matches the specified value (not C). If the -lag parameter is specified for the service, the service only starts on the databases for which replication lag does not exceed the specified value (D). Unless -preferred_all is specified for the service, the service only starts on the databases that are listed as preferred for the service.

• Question 54:

  Which tablespace contains the data dictionary, being automatically created at database creation?

  A. USERS

  B. TEMP

  C. SYSAUX

  D. SYSTEM

  E. EXAMPLE

  Correct Answer: D

  Reference: http://docs.oracle.com/cd/B10500_01/server.920/a96524/c04space.htm

• Question 55:

  Which three tasks can you perform in Database Express?

  A. View performance and status information about the database instance.

  B. Start up the database.

  C. Shut down the database.

  D. Create database structures.

  E. Manage users and security.

  Correct Answer: ADE

• Question 56:

  Which two statements about multi section backup are true?

  A. It is available only for full backups.

  B. It supports incremental backups and image copies.

  C. Backup for each data file is divided into sections and is backed up in parallel. However, for image copies, sections are backed up sequentially.

  D. For image copies, sections are backed up in parallel and recomposed at the end.

  Correct Answer: BD

  B (Not A): Starting with Oracle Database 12c Release 1 (12.1), RMAN supports multisection incremental backups D (not C): Starting with Oracle Database 12c Release 1 (12.1), you can create multisection full backups that are stored as image copies. While the image copy is being created, multiple channels are used to write files sections. However, the output of this operation is one copy for each data file.

  Reference: Specifying Multisection Incremental Backups Making Multisection Backups Using Image Copies

• Question 57:

  You are in the middle of transaction, updating a table. The machine on which the database is running

  reboots because of a power outage. This causes a database instance failure.

  Which statement is true in this situation?

  A. The online redo log files and archived redo log files are required to accomplish a recovery.

  B. The uncommitted transaction is committed at the next startup of the database instance.

  C. The uncommitted transaction is rolled back automatically at the next opening of the database.

  D. The DBA has to perform a recovery on the database to recover the uncommitted transaction.

  Correct Answer: C

• Question 58:

  Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

  A. non-cumulative

  B. multi-version

  C. proactive

  D. stabilizing

  E. cumulative

  Correct Answer: CDE

• Question 59:

  For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?

  A. when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c

  B. when upgrading from Oracle Database 10g to Oracle Database 12c

  C. when upgrading from Oracle Database 11g to Oracle Database 12c

  D. when upgrading from any previous version of Oracle Database to Oracle Database 12c

  Correct Answer: A

  You will be able to use this feature to perform database version upgrades starting with the first patchset of Oracle Database 12c (that is, you cannot use it to upgrade from any version earlier than the first Oracle Database 12c patchset). This means that the manual Transient Logical Standby upgrade procedure must still be used when upgrading from Oracle Database 11g to Oracle Database12c, or when upgrading from the initial Oracle Database 12c release to the first patchset of Oracle Database 12c.

  Reference: Oracle Data Guard Concepts and Administration, 12c, Using DBMS_ROLLING to Perform a Rolling Upgrade

• Question 60:

  Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

  A. db_name

  B. maxdatafiles

  C. control_files

  D. instance_name

  Correct Answer: A

  Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch14.htm