Oracle Database 12c Essentials v9.0 (1z0-497)

Page:    1 / 10   
Total 154 questions

Examine the table:

Table name: PRODUCTS -

Schema: SCOTT -

Tablespace: USERS -
Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and
PROD_RATE has four-digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

  • A. PROD_NAME size can be increased from five to 10 characters.
  • B. PROD_ID can be changed from CHAR to NUMBER data type.
  • C. PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).
  • D. New columns can be added only if they have a NOT NULL constraint.
  • E. None of the existing columns can be dropped because they contain data.

Answer : A,C

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

  • A. The DML operations re-create the bitmap index blocks.
  • B. The bitmap index is rebuilt automatically after a DML operation.
  • C. The smallest amount of a bitmap that can be locked is a bitmap segment.
  • D. Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

Answer : C

Explanation: Bitmap indexes in currently supported versions of Oracle are maintained in a much more efficient manner than they were previously, to the point where the need for frequently rebuilds has been much reduced, even in tables in which such indexes are not dropped during heavy loads.
That said, Bitmap indexes are still unsuitable in OLTP type environments (even in 11g or later) due to the locking implications associated with them.
Note: bitmap indexes are only suitable for static tables and materialized views which are updated at nigh and rebuilt after batch row loading.
Not B: Like b-tree indexes, bitmap indexes should be rebuilt (ALTER INDEX . . . REBUILD) if there is a lot of DML (UPDATE, INSERT, DELETE) activity.
Not A: Since 10g, Oracle is significantly more efficient and where possible will simply adjust the current rowid range of the Bitmap index entry and modify the bitmap string accordingly to accommodate a new row value (resulting in an overall increase of just 2 bytes overall in this example) rather than create a totally new index entry (which required an additional 21 bytes in the 9i example).

Which two statements are true regarding SQL*Plus?

  • A. It has commands for performing database administration operations.
  • B. It can be used in interactive but not batch mode for SQL commands.
  • C. It has to be installed separately after the Oracle Database 12c installation.
  • D. Operating system commands can be executed from the SQL*Plus command prompt.

Answer : A,D


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

Answer : C

Which statement is true about loading data by using the conventional path of SQL*Loader?

  • A. Redo is not generated while performing conventional path loads.
  • B. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
  • C. No exclusive locks are acquired when the conventional path loads are performed.
  • D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
  • E. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

Answer : C


As part of your Oracle Database 12c post-installation tasks, you run these commands:

srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?

  • A. It enables the Oracle Data Mining option in your Oracle binary files.
  • B. It creates the Fast Recovery Area disk group.
  • C. It generates Client Static Library.
  • D. It configures one of the Oracle user accounts.
  • E. It configures Oracle Net Services.
  • F. It configures Oracle Messaging Gateway.

Answer : A

Reference: (see 4.4)

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock.
Which two statements are true about SCOTT's session in this scenario?

  • A. The session is terminated after receiving the error and JIM can continue with his transaction.
  • B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
  • C. The session is rolled back after receiving the error and JIM can continue with his transaction.
  • D. SCOTT has to re-execute the last command in the transaction after he commits the transaction.

Answer : B,D


Which three statements are true about database storage structures?

  • A. A data file can span across tablespaces.
  • B. An extent contains one or more segments.
  • C. Tablespaces contain one or more data files.
  • D. Data objects are stored as segments in tablespaces.
  • E. Segments can span across data files within a tablespace.

Answer : C,D,E


Which three are initialization parameters for backup and recovery?


Answer : A,D,E


You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

  • A. You should not install the Oracle Database software into an existing Oracle home from a different release.
  • B. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
  • C. Oracle recommends that you back up the root. sh script after you complete the installation.
  • D. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
  • E. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

Answer : C


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.

Answer : E

Which three statements represent the benefits of multitenant architecture for database consolidation?

  • A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
  • B. You can consolidate shared database memory by combining multiple PDBs in a single CDB.
  • C. Patching individual PDBs requires the same amount of time as patching individual databases.
  • D. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
  • E. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

Answer : A,B,E

Explanation: By design, you can quickly plug a PDB into a CDB, unplug the PDB from the
CDB, and then plug this PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the transportable tablespace technique.
A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle
Database 12c were non-CDBs.
Reference: Benefits of the Multitenant Architecture for Database Consolidation

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B. which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?

  • A. Oracle GoldenGate
  • B. Oracle Advanced Replication
  • C. Oracle Active Data Guard
  • D. Oracle Streams

Answer : A,C

Identify three key properties of a transaction in Oracle Database 12c.

  • A. durability
  • B. consistency
  • C. concurrency
  • D. isolation
  • E. scalability
  • F. manageability

Answer : A,B,D


What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?


Answer : D

0521 (sys backup privilege)

Page:    1 / 10   
Total 154 questions