최신 1z1-497 무료덤프 - Oracle Database 12c Essentials

A. An SPFILE is a binary file that cannot be edited by using a text editor.

B. You can create an SPFILE from an existing text initialization parameter file or from memory.

C. You can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE.

D. The instance first searches for an SPFILE named spfileoRACLE_SIora and, if this is not found. It searches for spfile.ora.

A. 1521

B. 22

C. 7801

D. 2243

E. 5500

A. select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual

B. opatchlsinventory -xml

C. select patch from vSoption where opatch_data=' 333333' ;

D. select opatch from vSpatchsets where opatch_number = '333333';

A. When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

B. A buffer cache always resides completely in System Global Area (SGA).

C. A buffer cache stores copies of data blocks from all files of the database.

D. Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

E. A buffer cache contains exactly three pools: default, keep, and recycle pool.

A. User Global Area is stored in System Global Area (SGA).

B. No Program Global Area (PGA) is allocated for shared server processes.

C. Large Pool is used for SQL work areas.

D. Shared SQL Area is allocated from Program Global Area (PGA).

E. Private SQL Area is allocated from Library Cache.

A. You can drop the PDB and keep the data files to be reused by another PDB.

B. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

C. You can drop the seed PDB, but you cannot create any other PDB within the CD

D. You can drop the PDB only if it is closed.

A. the CDB as the ROOT user

B. the PDB as the PDB Admin user

C. the CDB as the CDBADMIN user

D. the PDB as the ROOT user

A. Oracle GoldenGate

B. Oracle Streams

C. Oracle Advanced Replication

D. Oracle Active Data Guard

A. a, b, c, d

B. b, c, a, d

C. c, b, a, d, f, e

D. b, c, a, d, e, f

E. a, b, c, d, e, f

A. Shut down the database.

B. Create database structures.

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

D. Start up the database.

E. Manage users and security.