Latest Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion, Page 7

Question #67

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

Question #68

View the Exhibit.

You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.
Which configuration could have enabled the block selection of 16 KB?

A. Setting autoextension on for the data file mentioned for the tablespace

B. Choosing the Segment Space Management option to manual

C. Choosing the extent allocation type to uniform

D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

Discussion 0

Correct Answer: D Vote an answer

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

Question #69

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:
SQL> SELECT ename FROM emp
2 WHERE job='CLERK' FOR UPDATE OF empno;
SCOTT has opened another session to work with the database instance.
Which three operations would wait when issued in SCOTT's second session? (Choose three.)

A. LOCK TABLE emp IN EXCLUSIVE MODE;

B. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');

C. LOCK TABLE emp IN SHARE MODE;

D. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;

E. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #70

Which two operations can be performed on an external table? (Choose two.)

A. Create a view on the table

B. Delete rows in the table using the DELETE command

C. Update the table using the UPDATE statement

D. Add a virtual column to the table

E. Create a synonym on the table

F. Create an index on the table

Discussion 0

Correct Answer: A,E Vote an answer

Question #71

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

Question #72

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

B. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

C. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

D. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

E. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

Discussion 0

Correct Answer: B Vote an answer

Question #73

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

A. A lower value increases the time taken to perform instance recovery

B. A higher value increases the I/O overhead

C. It is applicable only when the database is in ARCHIVELOG mode

D. If it is set to 0, the MTTR Advisor is disabled

E. It is overridden by LOG_CHECKPOINT_INTERVAL

Discussion 0

Correct Answer: B,E Vote an answer

Question #74

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old What could be the reason for this error?
Exhibit:

A. The query is unable to get a read-consistent image.

B. The query is unable to place data blocks in undo tablespace.

C. There is not enough space in Flash Recovery Area.

D. There is not enough free space in the flashback archive.

Discussion 0

Correct Answer: A Vote an answer

Question #75

In a database, EXAMPLE is the default tablespace and
DEFERRED_SEGMENT_CREATION is FALSE.
Examine these commands executed by SYS:

What will be the outcome and why?

A. It will fail because U1 does not have the CREATE TABLE privilege

B. U1.TAB1 will be created

C. It will fail because U1 has no default tablespace

D. It will fail because U1 has no quota on EXAMPLE

E. It will fail because U1 does not have the CREATE SESSION privilege

Discussion 0

Correct Answer: A Vote an answer

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

Question #76

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:
Which two statements are true about differential incremental backups? (Choose two.)

A. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

B. The backup performed on Sundays contains all the blocks that have ever been used in the database

C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup

D. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

Discussion 0

Correct Answer: A,B Vote an answer

Question #77

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

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

Download Free Oracle 1Z0-052 Demo