Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-497 - Oracle Database 12c Essentials

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

Which two statements are true about this common user?

A.

SQL> conn c##usr/pwd@pdb1

You are connected to PDB1 successfully.

B.

SQL> conn c##usr/pwd@pdb2

You are connected to PDB2 successfully.

C.

SQL> conn c##usr/pwd@pdb2

You are unable to create a connection. You first need to sync PDB2 by executing:

SQL> conn / as sysdba

SQL>exec DBMS_PDB.SYNC_PDB;

D.

SQL> conn c##usr/pwd@pdb2

You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing:

SQL>conn system/pwd@pdb2

SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT;

Now you are able to connect as common user c##usr to PDB2.

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.

A.

1, 2, 3, 4, 5

B.

2, 1, 5, 3, 4

C.

5, 1, 2, 3, 4

D.

2, 3, I, 5, 4

E.

1, 2, 4, 5, 2

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.

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?

a - Shut down the database.

b - Restart the database.

c - Copy an existing control file to a new location by using operating system commands.

d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

A.

b, c, d

B.

a, c, d, b

C.

a, d, b, c

D.

c, d, b

Which normalization level is adopted in real-world database systems?

A.

1NF

B.

2NF

C.

3NF

D.

BCNF

Which is the default isolation level in Oracle Database 12c?

A.

serializable

B.

read-only

C.

read committed

D.

read uncommitted

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

Which two statements describe data dictionary views?

A.

They are stored in the SYSTEM tablespace.

B.

They are based on virtual tables.

C.

They are owned by the SYS user.

D.

They speed up query and data manipulation language (DML) operations.

E.

The VSFIXED_TABLEview can be queried to list the names of these views.

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 two items are key for maintaining data consistency in Oracle Database 12c?

A.

undo data

B.

isolation level

C.

lock mechanism

D.

serializability