Oracle Database Administration II - 1Z1-083 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

A. It fails because the command does notspecify when the unified audit policy should be enforced. B. It fails because system privileges cannot be granted with roles in the same audit policy. C. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role. D. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

Discussion 0

Correct Answer: C Vote an answer

Question 2

Which four are true about RMAN backup sets? (Choose four.)

A. A backup piece can belong to only one backup set. B. A backup set must be written to media. C. Blocks from multiple data files can be contained in one backup piece, D. A data file can be split into multiple sections stored in different backup pieces in the same backup set. E. A backup set must be written to disk. F. Blocks from multiple data files can be contained in one backup set, G. A backup set can contain only one backup piece. H. A data file can be split into multiple sections stored in different backup sets.

Discussion 0

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

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

Question 3

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

A. New templates can only be created by modifying an existing user-created template. B. Oracle DBCA templates can store only logical structure and not database files. C. Oracle DBCA templates can be used to create new databases and duplicate existing databases. D. The Data Warehouse template is most suitable when transaction response time is the key criterion. E. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question 4

Which three are true about recovery operations done without using Recovery Manager (RMAN)?
(Choose three.)

A. A lost password file can be re-created with SQL*PLUS. B. A lost PFILE can be re-created alert.log using SQL*PLUS. C. A lost TEMPFILE must always be re-created manually. D. A lost index tablespace can be re-created without performing any recovery. E. A lost SPFILE can be recovered from memory using SQL*PLUS. F. A lost password file can be manually re-created with the orapwd utility.

Discussion 0

Correct Answer: D,E,F Vote an answer

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

Question 5

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

A. It can be used to patch Grid Infrastructure homes containing Oracle Restart. B. It can be used to provision middleware. C. It is an Oracle Database service D. It can be used to provision applications. E. It cannot be used to upgrade Oracle Database homes.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question 6

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

A. The C # # A_ADMIN user can perform wallet operations. B. TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only. C. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus. D. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker. E. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 7

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

A. Active Session History (ASH) report B. Database Replay C. Automatic Database Diagnostic Monitor (ADDM) Compare Period report D. SQL Performance Analyzer

Discussion 0

Correct Answer: C Vote an answer

Question 8

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; C. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M; D. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M; E. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; F. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; G. BACKUP SPFILE SECTION SIZE 1M;

Discussion 0

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