1Z0-497 Online Practice Questions and Answers

A DBA informs you that an Oracle instance has started. What does this imply?

A. Users can access the data in the database.

B. Only SGA has been allocated for the database.

C. Only background and user processes are running.

D. Memory areas have been allocated and background processes have been started.

Which two are client-side components of Oracle Data Guard Broker?

A. Oracle Enterprise Manager Cloud Control

B. Oracle Data Guard monitor

C. Oracle Data Guard command-line interface (DGMGRL)

D. Oracle Data Guard Broker Manager

You execute the following command:

SQL> ALTER USER skd ACCOUNT LOCK;

Which two statements are correct?

A. The SKD user cannot log in to the database instance.

B. The objects owned by the SKD user are not accessible to any user.

C. Other users can access objects owned by the SKD user, to which they have access.

D. The SKD user's password expires and the user is forced to change the password at the next login.

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.

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

A. Oracle Database alert.log file

B. object-level statistics

C. Automatic SGA Memory Management

D. Oracle Database Trace files

E. all server-generated alerts

You want to start a global service on your database. Which three conditions must be met?

A. The database is open and registered with a global service manager.

B. The service has been disabled on that database.

C. The database role is different from the role attribute of the service.

D. The replication lag on the database does not exceed the maximum value specified for the service.

E. The service has reached its cardinality defined by the number of preferred databases.

F. No other database in the pool is a better candidate for starting the service.

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.

When executing shutdown abort in a pluggable database (PDB), you ____________.

A. shut down abort the CDB

B. shut down abort the PDB

C. shut down immediate the PDB

D. shut down immediate the CDB

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

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

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

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

D. opatchlsinventory -xml

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

A. SYSBKP

B. SYSBKPRMAN

C. SYSRMAN

D. SYSBACKUP