Question No. 1

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

AThese administrative privileges enable you to connect to the database only if the database is open.

BAfter connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

CThese administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

DWithout being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

Show Answer

Correct Answer: B, D

https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11052

Question No. 2

Which three tasks can you perform in Database Express?

AView performance and status information about the database instance.

BStart up the database.

CShut down the database.

DCreate database structures.

EManage users and security.

Show Answer

Correct Answer: A, D, E

Question No. 3

Which tablespace contains the data dictionary, being automatically created at database creation?

AUSERS

BTEMP

CSYSAUX

DSYSTEM

EEXAMPLE

Show Answer

Correct Answer: D

http://docs.oracle.com/cd/B10500_01/server.920/a96524/c04space.htm

Question No. 4

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

APMON performs process recovery when a client process fails.

BDuring instance startup, PMON takes care of instance recovery.

CPMON performs listener registration.

DPMON restarts background and dispatcher processes when they fail.

EPMON resolves failures of distributed transactions.

Show Answer

Correct Answer: A, D

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

Question No. 5

Which two statements about multitenant architecture are true?

AIt ensures full backward compatibility with non-CDBs.

BIt fully operates with RAC .

CIt is integrated with Enterprise Manager, but not with the Resource Manager.

DIt allows central management and administration of single databases.

Show Answer

Correct Answer: A, D

http://oracle-base.com/articles/12c/multitenant-resource-manager-cdb-and-pdb-12cr1.php

https://docs.oracle.com/database/121/RACAD/admcon.htm#RACAD8961

https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#BRADV89725

Free Oracle 1Z0-497 Exam Actual Questions

The questions for 1Z0-497 were last updated On Dec 20, 2024