Oracle 1Z0-052 Free Practice Questions

Q1. 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 retention period to support flashback

B. The expected length of the longest-running query

C. The number of undo tablespaces in the database

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

View Answer

Q2. Which is the correct description of a pinned buffer in the database buffer cache?

A. The buffer is currently being accessed

B. The buffer is empty and has not been used

C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process

D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk

View Answer

Q3. The user HR receives the following error while inserting data into the TTK table:

ERROR at line 1:

ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD

Upon investigation, you find that SMD is a small file tablespace.

Which three action would allow the user to insert data? (Choose three.)

A. Add a data file to the SMD tablespace.

B. Add a data file to the temporary tablespace associated with the user HR.

C. Resize the data file associated with the SMD tablespace to make it larger.

D. Alter the data file associated with the SMD tablespace to grow automatically.

E. Change the segment space management for the SMD tablespace to automatic.

View Answer

Q4. Examine the command:

SQL>ALTER USR skd ACCOUNT LOCK;

Which two statements are true after the command is executed? (Choose two.)

A. The SKD user cannot log in to the database instance

B. The objects owned by the SKD user are not accessible to any user

C. The other users can access the objects owned by the SKD user, on which they have access

D. The password for the SKD user expires and the user is forced to change the password at the next log in

View Answer

Q5. Given below is a list of scenarios:

1. A user terminates his session abnormally.

2. The connection between the server and the client application terminates because of a network failure.

3. A schema is accidentally dropped.

4. The tablespace is accidentally dropped from the database.

5. The hard disk gets corrupted and the data files in the disk are lost.

6. The database instance abnormally shuts down because of power failure.

Which scenarios require DBA intervention to perform recovery?

A. 1, 3, and 6

B. 4, 5, and 6

C. 3, 4, and 5

D. 1, 2, and 6

View Answer

Q6. Which of these is true about undo tablespace?

A. Undo tablespace is a temporary tablespace

B. Undo tablespace has only one datafile

C. Undotablespace has a datafile which is reused in cyclic manner

View Answer

Q7. A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)

A. granting SELECT privilege to SMITH on V$SESSION

B. granting SELECT privilege to SMITH on V_$SESSION

C. asking the user SMITH to run the catalog.sql script

D. granting SELECT privilege to SMITH on V$FIXED_TABLES

E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

View Answer

Q8. In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:

1. The user account must be locked after four unsuccessful login attempts.

2. The user must be prompted to change the password at regular intervals.

3. The user may not have more than three simultaneous sessions.

4. The user session must automatically be logged off if more than 10 minutes elapsed time used.

How would you accomplish the above?

A. By assigning profiles for the users

B. By implementing Fine-Grained Auditing (FGA)

C. By granting a secure application role to the users

D. By implementing the Database Resource Manager plan

View Answer

Q9. View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body?

Exhibit:

A. The USE_P procedure remains valid.

B. The USE_P procedure becomes invalid.

C. The SHOW_DETAIL procedure becomes invalid.

D. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.

View Answer

Q10. You want to create a role to meet these requirements:

1. The role is to be protected from unauthorized usage.

2. The password of the role is not to be embedded in the application source code or stored in a table.

Which method would you use to restrict enabling of such roles?

A. Create the role with external authentication. B.

Create the role as a secure application role. C.

Create the role as a password-protected role.

D. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.

View Answer

Q11. All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions:

SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029'

123 rows updated.

SQL> DELETE FROM persons WHERE exp='Y'

3 rows deleted.

The SYS user opens a new session after HR executed the above commands.

Which sessions can see the effect of the UPDATE and DELETE commands?

A. All sessions of the HR user only

B. All sessions of the HR user and the SYS user

C. The session of the HR user that executed the commands

D. All the sessions for which the database users have access privilege to the PERSONS table

View Answer

Q12. The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:

SQL> INSERT INTO cust VALUES(101, 'JACK');

1 row created.

SQL> INSERT INTO cust VALUES(102, 'SMITH');

1 row created.

As a DBA, you execute the following command from another session:

ALTER TABLESPACE sales READ ONLY;

Which statement is true regarding the effect of this command on the transaction in Scott's session?

A. The command fails as a transaction is still pending.

B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.

C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

View Answer

Q13. Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

A. Running a query on a table returns "ORA-600: Internal Error."

B. Inserting a value in a table returns "ORA-01722: invalid number."

C. Creating a table returns "ORA-00955: name is already used by an existing object."

D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

View Answer

Q14. 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 generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

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

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

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

View Answer

Q15. 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. Grant the RESOURCE role to SCOTT.

B. Add data files to the USERS tablespace.

C. Grant the CREATE ANY TABLE privilege to SCOTT.

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

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

View Answer