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?
Answer : A,C
Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?
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?
Answer : A,D
Reference: http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm
When executing shutdown abort in a pluggable database (PDB), you ____________.
Answer : C
Which statement is true about loading data by using the conventional path of SQL*Loader?
Answer : C
Reference: http://www.orafaq.com/wiki/SQL*Loader
As part of your Oracle Database 12c post-installation tasks, you run these commands:
Cd $ORACLE_HOME/bin -
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?
Answer : A
Reference:
http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (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?
Answer : B,D
Explanation: https://www.youtube.com/watch?v=JitJRb5x9vI
Which three statements are true about database storage structures?
Answer : C,D,E
Explanation:
https://docs.oracle.com/cd/E11882_01/server.112/e40540/physical.htm#CNCPT1109
Which three are initialization parameters for backup and recovery?
Answer : A,D,E
Explanation:
http://docs.oracle.com/database/121/REFRN/refrn00102.htm#REFRN00102
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
Answer : C
Explanation: https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035 https://docs.oracle.com/database/121/LADBI/post_inst_task.htm#LADBI7749
Which statement regarding Oracle Active Data Guard 12c is false?
Answer : E
Which three statements represent the benefits of multitenant architecture for database consolidation?
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
URL:
http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239
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?
Answer : A,C
Identify three key properties of a transaction in Oracle Database 12c.
Answer : A,B,D
Reference:
http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016
What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?
Answer : D
Reference:
http://docs.oracle.com/cd/E16655_01/backup.121/e17631/release_changes.htm#RCMRF9
0521 (sys backup privilege)