Q1. 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.
Correct Answer: A, B, E
Q2. 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
Q3. Which new process was introduced as of Oracle Database 12c?
A.Result Cache Background process (RCBG)
B. AQ Coordinator process (QMNC)
C. Change Tracking Writer process (CTWR)
D. Listener Registration process (LREG)
Correct Answer: D
Q4. In this SQL statement, what is the partitioning criteria? CREATE TABLE books_part PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN (3) , . . . PARTITION pl4 VALUES LESS THAN (15), PARTITION pl5 VALUES LESS THAN (16), PARTITION pl6 VALUES LESS THAN (MAXVALUE) ) AS SELECT * FROM books;
A.books
B. pxx
C. MAXVALUE
D. cell_id
E. There is no partitioning criteria.
Correct Answer: D
Q5. 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: A, D, F
$ 39
Reviews
There are no reviews yet.