Oracle 1Z1-052 valid study dumps : Oracle Database 11g: Administration I

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname
VARCHAR2, v_mgr NUMBER, v_loc NUMBER)
BEGIN
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);
END;
The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table.
You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would you suggest to the PL/SQL developers to achieve this?

• A. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
• B. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.
• C. Create the procedure with invoker's right.
• D. Create the procedure with definer's right.

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

• A. The session is rolled back after receiving the error and JIM can continue with his transaction.
• B. SCOTT has to reexecute the last command in the transaction after he commits the transaction.
• C. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
• D. The session is terminated after receiving the error and JIM can continue with his transaction.

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?

• A. It must be made up of a database name and a domain name.
• B. It must be made up of the value in ORACLE_SID and HOSTNAME.
• C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
• D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

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

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

• A. The alert log file is corrupted
• B. A database user terminates the session abnormally
• C. A tablespace is accidentally dropped
• D. One of the redo log members is corrupted
• E. The hard disk on which the data files is stored is corrupted

Your database is configured in archivelog mode.
The USERS01 tablespace is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

• A. only the NORMAL clause
• B. only the IMMEDIATE clause
• C. either the NORMAL or the IMMEDIATE clause
• D. only the TEMPORARY clause
• E. either the NORMAL or the TEMPORARY clause

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