Oracle 1z0-497 Exam Questions Free Practice Test

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions

Questions # 21:

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;

Options:

books

pxx

MAXVALUE

cell_id

There is no partitioning criteria.

Questions # 22:

Which two statements about Automatic Data Optimization (ADO) are true?

Options:

ADO policies can automatically compress data when it qualifies.

ADO policies can automatically move segments when necessary.

ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

You cannot compress at block level, but you can compress at segment level.

You can compress at row level only for QUERY LOW.

Questions # 23:

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

Options:

the CDB as the ROOT user

the CDB as the CDBADMIN user

the PDB as the ROOT user

the PDB as the PDB Admin user

Questions # 24:

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

Options:

You can perform complete recovery by using the command:

RESTORE DATABASE

FROM TAG“consistent_whole_backup”;

RECOVER DATABASE;

You can perform incomplete recovery by using the command:

RESTORE DATABASE;

FROM TAG "consistent_whole_backup";

RECOVER DATABASE NOREDO;

Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

Media recovery is possible in most cases.

Questions # 25:

You execute some DMLcommands, followed by a COMMIT Statement.

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

Options:

1. LGWR writes the commit record to disk.

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

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

2. LGWR writes the commit record to disk.

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

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

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.

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.

Questions # 26:

You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What must take place before the block can be written to disk?

Options:

The buffer must be written to flash cache.

A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

The modified data block must be moved from the LRU list to the write queue.

The database must advance the checkpoint.

Questions # 27:

To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?

1 -Start the analysis.

2 - Set up the analysis policy type (database, role, context).

3 - Generate the results.

4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.

5 - Stop the analysis.

Options:

1, 2, 3, 4, 5

2, 1, 5, 3, 4

5, 1, 2, 3, 4

2, 3, I, 5, 4

1, 2, 4, 5, 2

Questions # 28:

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?

Options:

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;

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;

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;

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';

Questions # 29:

Which three tasks can you perform in Database Express?

Options:

View performance and status information about the database instance.

Start up the database.

Shut down the database.

Create database structures.

Manage users and security.

Questions # 30:

Question # 30

Options:

Option A

Option B

Option C

Option D

Option E

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions

Pass the Oracle Oracle Database 12c Certified Implementation Specialist 1z0-497 Questions and answers with CertsForce