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

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. S srvctl start database -db SORACLE_SID

B. S sqlplus / as sysdba SQL> startup immediate;

C. S sqlplus / as sysdba SQL> restart;

D. S rman target / RMAN> Startup

E. S sqlplus / as sysdba SQL> startup open recover;

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. less instance overhead

B. isolation

C. fast and easy provisioning

D. minor application changes

E. increased storage cost

F. same time needed for patching and upgrade as in the previous release

A. A seed PDB can sometimes be opened for particular operations.

B. Oracle-supplied metadata resides only in the root container.

C. You can create common users in PDBs.

D. A CDB can have an infinite number of PDBs.

E. Multiple PDBs with the same name can reside in the same CDB.

A. The redo log buffer becomes full.

B. The database advances a checkpoint.

C. A client process commits a transaction.

D. A tablespace is changed to read-only status.

E. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

F. The database is shut down in immediate mode.

A. from either a client or server, even if the database instance is not up

B. from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

C. from either a client or server, only if the database instance is up, and the command connects the session to the instance

D. only from the server, if the database instance is not up

A. FILESYSTEMIO_OPTIONS

B. CLONEDB

C. DB_CREATE_FILE_DEST

D. RECYCLEBIN

E. TAPE_ASYNCH_IO

A. Process Monitor Process (PMON)

B. Recoverer process (RECO)

C. Space Management Coordinator process (SMCO)

D. Checkpoint Process

E. Flashback Data Archive process (FBDA)

F. Listener Registration process (LREG)

A. COMMIT

B. SELECT

C. SAVEPOINT

D. CREATE

E. ROLLBACK