1Z0-497 Online Practice Questions and Answers

As part of your Oracle Database 12c post-installation tasks, you run these commands:

Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb

What does this do?

A. It enables the Oracle Data Mining option in your Oracle binary files.

B. It creates the Fast Recovery Area disk group.

C. It generates Client Static Library.

D. It configures one of the Oracle user accounts.

E. It configures Oracle Net Services.

F. It configures Oracle Messaging Gateway.

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.

Which is the default port number for Database Express?

A. 7801

B. 5500

C. 2243

D. 1521

E. 22

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?

A. You have to copy the seed data files yourself,

B. You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.

C. The seed pluggable database is not required.

D. The seed pluggable database does not require data files.

E. The seed pluggable database is always kept in READ ONLY mode.

F. The seed pluggable database is not a container.

G. The seed pluggable database can be dropped.

You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer

(OUI) shows a message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements...

Expected result: 1512MB

Actual Result: 1018MB

Check complete. The overall result of this check is: failed «« Problem: The system does not have the

required swap space.

What happens to the installation in this situation?

A. It can be continued.

B. It resizes the swap space automatically when you proceed further.

C. It can be continued, but the instance cannot be started without increasing swap space.

D. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

Which three statements are true about a database instance that has mounted a database but has not opened it?

A. System administrators and users with the CREATE SESSION system privilege may connect to the instance.

B. Data files are open in read-only mode.

C. A control file is open.

D. System Global Area (SGA) is allocated and background processes are started.

E. An alert log and trace files are open.

F. Instance recovery is performed for the database.

View the current parameter settings shown in the output below.

NAMETYPEVALUE db_file_multiblock_read_count integer 107 ddl_lock_timeout integer 60 Distributed_lock_timeout integer 60 dml_locks integer 748 lock_sga boolean FALS E enab1e_dd1_1ogging boolean FALS E resumable_timeout integer 0

A user logs in to the HRschema and issues the following commands:

SQL> CREATE TABLE emp (empno NUMBER(3), enamo VARCHAR2(20), sal NUMBER (8, 2));

SQL> INSERT INTO emp (empno, ename) VALUES(1, 'JAMES');

At this moment, a second user also logs in to the HRschema and issues the following command:

SQL> ALTER TABLE emp MODIFY salNUMBER(10, 2);

What happens in this scenario?

A. The second user's session immediately produces a "resource busy" error.

B. The second user's command executes successfully.

C. The second user's session waits for a time before producing a "resource busy" error.

D. A deadlock is created.

Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime. Which Oracle solution would you recommend?

A. Active Data Guard

B. Oracle GoldenGate

C. Oracle Real Application Clusters

D. Oracle Transportable Tablespaces

E. Oracle Cloud Platform as a Service

The session of user SCOTT receives the following error after executing an UPDATE command on the

EMP table:

ERROR at line 1:

ORA-00060: deadlock detected while waiting for resource

You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two

statements are true about SCOTT's session in this scenario?

A. The session is terminated after receiving the error and JIM can continue with his transaction.

B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

C. The session is rolled back after receiving the error and JIM can continue with his transaction.

D. SCOTT has to re-execute the last command in the transaction after he commits the transaction.

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

A. You can perform complete recovery by using the command: RESTORE DATABASE FROM TAG"consistent_whole_backup"; RECOVER DATABASE;

B. You can perform incomplete recovery by using the command: RESTORE DATABASE; FROM TAG "consistent_whole_backup"; RECOVER DATABASE NOREDO;

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

D. Media recovery is possible in most cases.

Which tablespace contains the data dictionary, being automatically created at database creation?

A. USERS

B. TEMP

C. SYSAUX

D. SYSTEM

E. EXAMPLE

Examine the command: sqlplus /nolog

In which scenario would this command execute successfully?

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

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

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

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

Which three statements are true about database storage structures?

A. A data file can span across tablespaces.

B. An extent contains one or more segments.

C. Tablespaces contain one or more data files.

D. Data objects are stored as segments in tablespaces.

E. Segments can span across data files within a 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

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)