1z0-497 by Oracle Actual Free Exam Q&As

Question 1

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?

A. The session is terminated after receiving the error and JIM can continue with his transaction. B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction. C. SCOTT has to re-execute the last command in the transaction after he commits the transaction. D. The session is rolled back after receiving the error and JIM can continue with his transaction.

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

Identify the correct order of consolidation density.

A. schema consolidation< VMs< dedicated databases< multitenant B. dedicated databases< VMs< schema consolidation< multitenant C. multitenant< schema consolidation< dedicated database< VMs D. VMs< dedicated databases< schema consolidation< multitenant

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which logical storage relationship is correct?

A. Data File <Tablespace< Segment < Extent < Oracle Datablock B. Tablespace< Segment < Extent < Oracle Datablock C. B) Segment < Extent < Oracle Datablock<Tablespace D. Tablespace< Extent < Segment < Oracle Datablock

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

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

A. shut down abort the CDB B. shut down immediate the CDB C. shut down immediate the PDB D. shut down abort the PDB

Discussion 0

Correct Answer: C Vote an answer

Question 5

Which three background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?

A. Recoverer process (RECO) B. Flashback Data Archive process (FBDA) C. Listener Registration process (LREG) D. Space Management Coordinator process (SMCO) E. Checkpoint Process F. Process Monitor Process (PMON)

Discussion 0

Correct Answer: A,E,F Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

A. CREATE DATABASE B. ALTER DATABASE RECOVER C. DROP DATABASE D. SHUTDOWN E. STARTUP

Discussion 0

Correct Answer: B,D,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

Which four statements about users in Oracle Database 12c are correct?

A. A common user can be created only in the root container. B. A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause. C. A local user with the proper privileges can also create a common user. D. A common user is one that has the same username and authentication credentials across multiple PDBs. E. A common user cannot have the same name as any local user across all PDBs. F. If a PDB is closed, the common and local users of the PDB are not visible.

Discussion 0

Correct Answer: A,D,E,F Vote an answer

Question 8

You are about to apply a patch to a database. Which recommended action is incorrect?

A. You should stop all applications running from the software directory that is being patched. B. You should make sure that you have a good backup of the software, database, and configuration files. C. You should check the patch conflict with installed patches before applying the patch. D. You should install the latest O patch before applying the patch. E. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

Discussion 0

Correct Answer: E Vote an answer

Question 9

Which two statements about multitenant architecture are true?

A. It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases. B. A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB. C. Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs. D. Multiple PDBs on a single server need multiple database instances and multiple sets of database files. E. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Oracle Database 12c Essentials - 1z0-497 Exam Practice Test