Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-497 - Oracle Database 12c Essentials

Oracle 1z0-497 Premium Access     Download Demo    
Page: 4 / 5
Total 150 questions

You execute some DMLcommands, followed by a COMMIT Statement.

Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

A.

1. LGWR writes the commit record to disk.

2. LGWR writes all redo entries from Redo Log Buffer to disk.

B.

1. GWR writes only the transaction's redo entries from Redo Log Buffer to disk.

2. LGWR writes the commit record to disk.

C.

1. LGWR puts the commit record to Redo Log Buffer.

2. IGWR writes all redo entries from Redo Log Buffer to disk.

D.

1. LGWR puts the commit record to Redo Log Buffer.

2. If the activity is high, LGWR waits three seconds for other transactions to commit.

3. LGWR writes all redo log entries from Redo Log Buffer to disk.

E.

1. LGWR puts the commit record to Redo Log Buffer.

2. LGWR signals the database writer (DBW) process to write dirty blocks to disk.

3. LGWR writes all redo entries from Redo Log Buffer to disk.

Which process is responsible for writing the contents of database buffers to data files?

A.

Process Monitor process (PMON)

B.

Listener Registration process (LREG)

C.

System Monitor process (SMON)

D.

Database Writer process (DBW)

E.

Log Writer process (LGWR)

F.

Checkpoint process (CKPT)

Your database is down. You log in as the SYS user and issue this command:

SQL> STARTUP

What happens after the instance is started?

A.

Nothing else happens.

B.

The database is mounted but not opened.

C.

The database is mounted and finally opened.

D.

The database is opened and finally mounted.

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.

YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

A.

FULL

B.

SCHEMAS

C.

TRANSFORM

D.

REMAP_SCHEMA

E.

REMAP_TABLESPACE

Which three are initialization parameters for backup and recovery?

A.

CLONEDB

B.

FILESYSTEMIO_OPTIONS

C.

DB_CREATE_FILE_DEST

D.

RECYCLEBIN

E.

TAPE_ASYNCH_IO

After a ___________ statement is issued, a transaction ends. (select three)

A.

COMMIT

B.

ROLLBACK

C.

SAVEPOINT

D.

SELECT

E.

CREATE

Which three options correctly match environment variables with their specific functionality?

A.

ORACLE_SID specifies the instance name.

B.

ORACLE_SID specifies the global database name.

C.

ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

D.

ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

E.

ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

F.

ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

Which three tasks can you perform in Database Express?

A.

View performance and status information about the database instance.

B.

Start up the database.

C.

Shut down the database.

D.

Create database structures.

E.

Manage users and security.

Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?

A.

You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;

SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;

B.

You alter the salesprd source database to open in read-only mode, and start cloning the source database:

SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;

SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

C.

You alter the salesprd source database to open in read-only mode:

SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;

In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB:

SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;

D.

Connected as the salesprd local DBA, you create an XML using:

SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;

Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using:

SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';