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

examout.co

Your database instance is running. db01 is a net service name. You issue a connection request by using the command:

SQL> CONNECT scott/tiger@db01

Which component receives the request and establishes the appropriate connection?

A.

listener

B.

user process

C.

service name

D.

server process

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

Identify three key properties of a transaction in Oracle Database 12c.

A.

durability

B.

consistency

C.

concurrency

D.

isolation

E.

scalability

F.

manageability

Which two statements correctly distinguish between undo and redo data?

A.

Undo reverses a change, whereas redo re-creates a change.

B.

Redo reverses a change, whereas undo re-creates a change.

C.

Undo protects against inconsistent reads, whereas redo protects against data loss.

D.

Redo protects against inconsistent reads, whereas undo protects against data loss.

John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?

A.

Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.

B.

Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.

C.

Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

D.

Recovery of individual PDBs is not possible at all.

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.

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.

What happens if you execute these SQL statements?

SQL> show con_name

CON_NAME

--------------------------------

CDB$ROOT

SQL> create user 1_freed identified by y container=current;

A.

A common user is created in the root container.

B.

A local user is created in the root container.

C.

A local user is created in all the PDBs.

D.

The second SQL statement fails because a local user cannot be created in the root container.

You add the following code in the tnsnames.ora file on a client PC:

sales=

(DESCRIPTION=

(ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) )

(CONNECT_DATA=

(SERVICE_NAME=sales.acme)))

Which statement is true about the code with respect to creating a new connect identifier?

A.

It is created for the SALES database in the network domain ACME on the SALESDATA server.

B.

It is created for the SALESDATA database on the SALES server in the network domain called ACME.

C.

It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.

D.

It generates an error because the server configuration mode (dedicated or shared) is not specified.