Latest Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion, Page 4

Question #43

Which two events always cause the LGWR to write? (Choose two.)

A. when a log switch occurs

B. when a checkpoint occurs

C. when LGWR is notified by a server process that performs a COMMIT OR ROLLBACK

D. when PMON restarts a server process

E. when DBWn writes dirty buffers

Discussion 0

Correct Answer: A,B Vote an answer

Question #44

Which two statements are true regarding transactions in an Oracle database? (Choose two.)

A. A transaction is assigned an undo segment when it is started.

B. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

C. Multiple transactions can use the same undo segment.

D. More than one transaction cannot share the same extent in the undo tablespace.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #45

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.

B. AWR data is stored in the SYSAUX tablespace.

C. By default, AWR data is retained for eight days.

D. It includes statistics that contain the number of distinct values per table column.

E. Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.

F. It includes statistics that contain the number of rows per table.

Discussion 0

Correct Answer: B,C,E Vote an answer

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

Question #46

To make audit information more productive, the DBA executes the following command before starting an audit operations:
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting the database?

A. It contains the plan and statistics associated with the SQL statement executed by the user

B. It contains the SQL text executed by the user and the bind variables used with it

C. It contains the plan for the SQL statement executed by the user and the bind variables used with it

D. It contains only the plan for the SQL statement executed by the user

Discussion 0

Correct Answer: B Vote an answer

Question #47

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. By default, AWR snapshots are taken every 60 minutes

B. AWR data is stored in the SYSTEM tablespace

C. It is the foundation for the self-managing infrastructure

D. The taking of AWR snapshots cannot be disabled

E. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #48

Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench?

A. invoking the Data Recovery Advisor and SQL Repair Advisor

B. Creating a service request with My Oracle Support

C. invoking the SQL Test Case Builder

D. gathering metadata from the Automatic Diagnostic Repository (ADR)

Discussion 0

Correct Answer: D Vote an answer

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

Question #49

Which two are true about roles? (Choose two.)

A. Only one default role can be granted to a user.

B. A role can be password-protected.

C. A role can be granted only multiple system privileges not multiple object privileges.

D. A role can be created only by a user with the SYSDBA privilege.

E. A role can be granted to another role.

Discussion 0

Correct Answer: B,E Vote an answer

Question #50

Which is true about the Automatic Diagnostic Repository (ADR)?

A. It includes diagnostic data for critical errors for each server and background process

B. It is used only if the DISGNOSTIC_DEST parameter is manually configured

C. It only contains the alert log and trace files for background processes

D. Its location is always set by the ORACLE_BASE variable

Discussion 0

Correct Answer: C Vote an answer

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

Question #51

Which two statements are true about checkpointing? (Choose two.)

A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

B. It ensures that all committed data is written to the data files during normal shutdown.

C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.

D. The checkpoint frequency decreases with the smaller redo log file size.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #52

Which two are true about undo tablespaces? (Choose two.)

A. Tables can be created in undo tablespaces by SYS

B. Single instance databases can have only one active undo tablespace

C. They always retain undo for the time period defined by UNDO_RETENTION

D. They can be recovered only when an instance is in MOUNT state

E. They must have only one data file

Discussion 0

Correct Answer: A,C Vote an answer

Question #53

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
* ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem. (Choose two.)

A. Add data files to the USERS tablespace.

B. Grant the CREATE ANY TABLE privilege to SCOTT.

C. Grant the RESOURCE role to SCOTT.

D. Increase the size of the data file associated with the USERS tablespace.

E. Increase the space for SCOTT on the USERS tablespace.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #54

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

A. Shared SQL Area will be allocated in the shared pool

B. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

C. Shared SQL Area will be allocated in the large pool always

D. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

E. Shared SQL Area will be allocated when a session starts

F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

Discussion 0

Correct Answer: A,F Vote an answer

Question #55

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. Online and archived redo files are required to accomplish instance recovery

Discussion 0

Correct Answer: C Vote an answer

Question #56

You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.
Which is the most effective method to access this data in your database?

A. Use the SQL*Loader utility.

B. Use the database link.

C. Create an external table and leave the data in the flat file.

D. Use the Oracle Data Pump utility.

Discussion 0

Correct Answer: C Vote an answer

Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-052 Demo