1. Home
  2. Oracle
  3. Oracle Database 12c Certified Implementation Specialist
  4. 1z0-497
  5. Oracle Database 12c Essentials Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 4 out of 5 pages
Viewing questions 31-40 out of questions
Questions # 31:

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?

Options:
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.

Questions # 32:

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?

Options:
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.

Questions # 33:

Which statement about CDB architecture is true?

Options:
A.

Oracle-supplied metadata resides only in the root container.

B.

A seed PDB can sometimes be opened for particular operations.

C.

Multiple PDBs with the same name can reside in the same CDB.

D.

A CDB can have an infinite number of PDBs.

E.

You can create common users in PDBs.

Questions # 34:

Examine the table:

Table name: PRODUCTS

Schema: SCOTT

Tablespace: USERS

Organization: Standard (Heap Organized)

This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.

Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

Options:
A.

PROD_NAME size can be increased from five to 10 characters.

B.

PROD_ID can be changed from CHAR to NUMBER data type.

C.

PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

D.

New columns can be added only if they have a NOT NULL constraint.

E.

None of the existing columns can be dropped because they contain data.

Questions # 35:

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;

Options:
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.

Questions # 36:

Which process is responsible for writing the contents of database buffers to data files?

Options:
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)

Questions # 37:

Which statement is true regarding this connect string?

(DESCRIPTION

(FAILOVER=on)

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=sales-east1) (port=1522) )

(ADDRESS=(host=sales-east2)(port=1522))

(ADDRESS=(host=sales-east3) (port=1522) ))

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=sales-west1) (port=1522) )

(ADDRESS=(host=sales-west2) (port=JS22))

(ADDRESS=(host=sales-west3) (port=lS22) ) )

(CONNECT_DATA=

(SERVICE_NAME=sales)

(REGION=east)))

Options:
A.

It contains three global service managers in the client's local region (east).

B.

Client-side load balancing has been enabled only for the global service managers within the client's buddy (west).

C.

Connect-time failover between regions has not been enabled.

D.

The REGION parameter is optional.

Questions # 38:

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

Options:
A.

1NF

B.

2NF

C.

3NF

D.

BCNF

Questions # 39:

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

Options:
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

Questions # 40:

Which new process was introduced as of Oracle Database 12c?

Options:
A.

Result Cache Background process (RCBG)

B.

AQ Coordinator process (QMNC)

C.

Change Tracking Writer process (CTWR)

D.

Listener Registration process (LREG)

Viewing page 4 out of 5 pages
Viewing questions 31-40 out of questions