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

Question #29

Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects. Which method would you adopt to achieve this objective?

A. Set the value of the OS_ROLES parameter to TRUE.

B. Grant ANY TABLE system privileges again without ADMIN OPTION.

C. Use Database Resource Manager to restrict user access to objects.

D. Revoke the RESOURCE role from the users.

E. Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.

Discussion 0

Correct Answer: E Vote an answer

Question #30

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

A. The size of the Flash Recovery Area for the database instance

B. The retention period to support flashback

C. The number of undo tablespaces in the database

D. The expected length of the longest-running query

Discussion 0

Correct Answer: B,D Vote an answer

Question #31

Which four are true about transaction, table, and row locks in an Oracle Database?
(Choose four.)

A. A table's row-level locks escalate to table locks when a majority of rows in that table are locked in exclusive mode

B. DML statements lock modified rows in exclusive mode

C. DML statements lock modified tables in exclusive mode

D. Transaction locks are released when that transaction executes a COMMIT statement

E. DDL statements never lock the objects that they modify

F. SELECT statements are never blocked by row-level locks

G. Transaction locks are released when that transaction executes a ROLLBACK statement

Discussion 0

Correct Answer: B,C,F,G Vote an answer

Question #32

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. The archived redo log files are missing for which the backup is not available

B. The database files are corrupted when the database is open

C. The user has dropped an important table that needs to be recovered

D. The database is not opening because the required database files are missing

Discussion 0

Correct Answer: B,D Vote an answer

Question #33

View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?
09 (exhibit):

10 (exhibit):

A. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially

B. because Automatic Memory Management (AMM) is disabled for the database instance

C. because the DB_CACHE_ADVICE parameter is set to OFF

D. because Automatic Shared Memory Management (ASMM) is enabled for the database instance

Discussion 0

Correct Answer: D Vote an answer

Question #34

Which two are true about Optimizer Statistics? (Choose two.)

A. They are gathered by the Manageability Monitor (MMON) background process

B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package

C. They can be used to determine the events on which a database instance waited

D. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements

E. They are automatically updated when DDL statements execute

F. They do not persist across instance restarts

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #35

Which are three of the various resources that must be accessible to keep a database open?

A. spfile

B. SYSTEM tablespace

C. control file

D. all members of a redo log group

E. SYSAUX tablespace

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #36

Your database is using Automatic Memory Management.
Which two SGA components must be managed manually? (Choose two)

A. keep buffer pool

B. shared pool

C. redo log buffer

D. default buffer cache

E. large pool

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #37

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using the APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?

A. The profile is dropped and current user sessions use the DEFAULT profile immediately.

B. The command produces an error.

C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.

D. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

Discussion 0

Correct Answer: B Vote an answer

Question #38

View the Exhibit and examine the output.

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

A. The ORCL instance is registered dynamically with the listener.

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

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

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

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #39

USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:

What will be the outcome and why?

A. It will fail because there is an uncommitted transaction on USER1.DEPT

B. It will fail because a referential integrity constraint is defined on USER1.EMP

C. It will execute successfully and drop the DEPT.DNO and EMP.DNO columns

D. It will execute successfully and drop DEPT.DNO

E. It will fail because there is an uncommitted transaction on USER1.EMP

Discussion 0

Correct Answer: D Vote an answer

Question #40

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

A. Data Files

B. Control Files

C. Server Parameter File

D. Online Redo Log Files

E. Parameter Files

Discussion 0

Correct Answer: B,C Vote an answer

Question #41

Which two statements are true regarding a PL/SQL package body? (Choose two.)

A. It can be changed and recompiled without making the package specification invalid.

B. It can contain only the subprograms defined in the package specification.

C. It cannot invoke subprograms defined in other packages.

D. It cannot be created without a package specification.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #42

Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.
What could be the reason for this?

A. To limit the amount of memory to be used for the dispatcher queue of a session in SGA

B. To limit the User Global Area (UGA) memory allocated to a session from the SGA

C. To limit the amount of memory to be used for the request pool in System Global Area (SGA)

D. To control the amount of memory allocated in SGA for the local variables for each shared server process

Discussion 0

Correct Answer: B Vote an answer

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

Download Free Oracle 1Z1-052 Demo