Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Home
Oracle
Oracle Database 12c Certified Implementation Specialist
1z0-497
Oracle Database 12c Essentials Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-497 Premium Access

View all detail and faqs for the 1z0-497 exam

Go to Exam

377 Students Passed

94% Average Score

96% Same Questions

Viewing page 1 out of 5 pages

Viewing questions 1-10 out of questions

Questions # 1:

For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?

Options:

when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c

when upgrading from Oracle Database 10g to Oracle Database 12c

when upgrading from Oracle Database 11g to Oracle Database 12c

when upgrading from any previous version of Oracle Database to Oracle Database 12c

Answer

Explanation

You will be able to use this feature to perform database version upgrades starting with the first patchset of Oracle Database 12c (that is, you cannot use it to upgrade from any version earlier than the first Oracle Database 12c patchset). This means that the manual Transient Logical Standby upgrade procedure must still be used when upgrading from Oracle Database 11g to Oracle Database12c, or when upgrading from the initial Oracle Database 12c release to the first patchset of Oracle Database 12c.

[Reference: Oracle Data Guard Concepts and Administration, 12c, Using DBMS_ROLLING to Perform a Rolling Upgrade, , ]

Questions # 2:

Which three statements represent the difference between a container database (CDB)and a non-container database?

Options:

A container database has exactly one seed PDB, and a non-container database has no seed PDB.

In a newly created non-CDB that does not yet contain user data, the data dictionary contains only system metadata. When application users create their own objects, this metadata is mixed with the system metadata. In a CDB, the data dictionary metadata is split between the root and the PDBs. The data dictionary in the PDB contains pointers to the data dictionary in the root.

New views are introduced. Next to DBA_views, AIL_-views, and USER_-views, there are CDB_-views. Both CDB and non-CDB databases can access this information.

You are allowed to create only a single HR user in a non-CDB database. This restriction is identical for a CDB database.

Every PDB in a CDB has its own control file. A non-CDB, which has no containers, needs only one control file.

Answer

A, B, C

Questions # 3:

Examine the command below:

LSNRCTL> SERVICES LISTENER2

Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com) (PORT=1525)))

Services Summary. . .

Service "orcl.oracle.com" has 1 instance(s).

Instance "oracle", status UNKNOWN, has 1 handler(s) for this service... Handler(s):

"DEDICATED" established:2 refused:0 LOCAL SERVER The command completed successfully

Which two statements are true about LISTENER2?

Options:

The ORCL instance is registered dynamically with the listener.

The ORCL instance is registered statically in the listener.ora file.

The number of current client connections handled by the service handler is two.

The total number of client connections handled so far by the service handler is two.

Answer

B, D

Questions # 4:

Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

Options:

The average active sessions were more than three times the number of CPU cores.

Active sessions were more than 10% of total load and CPU utilization was more than 50%.

Memory allocations were more than 95% of physical memory.

Hung sessions were more than 10% of total sessions.

A deadlock was detected.

The session limit was close to 100%.

Answer

Explanation

[Reference: http://docs.oracle.com/cd/E16655_01/server.121/e15857/pfgrf_diag.htm#TGDBA95369 (table 7-1), , ]

Questions # 5:

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

Options:

You can perform complete recovery by using the command:

RESTORE DATABASE

FROM TAG“consistent_whole_backup”;

RECOVER DATABASE;

You can perform incomplete recovery by using the command:

RESTORE DATABASE;

FROM TAG "consistent_whole_backup";

RECOVER DATABASE NOREDO;

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

Media recovery is possible in most cases.

Answer

B, C

Explanation

[Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmrecov.htm#CACGEAEE, , ]

Questions # 6:

Which two statements about the Process Monitor (PMON) process are true?

Options:

PMON performs process recovery when a client process fails.

During instance startup, PMON takes care of instance recovery.

PMON performs listener registration.

PMON restarts background and dispatcher processes when they fail.

PMON resolves failures of distributed transactions.

Answer

A, D

Explanation

http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9840

Questions # 7:

Which two statements about switchover and failover are true?

Options:

A snapshot standby can be the target of a switchover or fast-start failover operation.

Neither a switchover nor a failover is possible to a far sync instance.

For fast-start failover, you must preselect the target standby database that will be used.

You can activate a standby database to test whether it is being updated correctly.

Answer

B, C

Explanation

[Reference: http://www.oracle.com/technetwork/database/availability/farsync-2267608.pdf, , , ]

Questions # 8:

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

Options:

durability

consistency

concurrency

isolation

scalability

manageability

Answer

A, B, D

Explanation

[Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016, , ]

Questions # 9:

Examine the command:

SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;

Which two statements are true about the execution of the command?

Options:

A CHECK constraint is created on the OID column.

A NOT NULL constraint is created on the OID column.

The ORDERS table is the only object created in the USERS tablespace.

The ORDERS table and a unique index are created in the USERS tablespace.

The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

Answer

B, D

Explanation

B: A NOT NULL constraint is put on the primary key.

* To enable a unique or primary key constraint, you must have the privileges necessary to create an index on the table. You need these privileges because Oracle Database creates an index on the columns of the unique or primary key in the schema containing the table.

* TABLESPACE Specify the tablespace in which Oracle Database creates the table, object table OIDINDEX, partition, LOB data segment, LOB index segment, or index-organized table overflow data segment. If you omit TABLESPACE, then the database creates that item in the default tablespace of the owner of the schema containing the table.

[Reference: Oracle Database SQL Language Reference 12c , CREATE TABLE, ]

Questions # 10:

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?