Getting Smart with: oracle database 11g administration i 1z0 052

Your success in Oracle 1z0 052 pdf is our sole target and we develop all our oracle database 11g administration i 1z0 052 braindumps in a way that facilitates the attainment of this target. Not only is our 1z0 052 dumps study material the best you can find, it is also the most detailed and the most updated. 1z0 052 pdf Practice Exams for Oracle 1z0 052 dumps are written to the highest standards of technical accuracy.

Q21. 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 ORCL instance is registered statically in the listener.ora file.

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

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

Answer: BD


Q22. Which three descriptions are correct about the effects of the TRUNCATE command on a table?

(Choose three.)

A. The corresponding indexes for the table are also truncated.

B. Delete triggers on the table are fired during the execution of the TRUNCATE command.

C. The child table is truncated when the TRUNCATE command is applied on the parent table.

D. The highwater mark (HWM) is set to point to the first usable data block in the table segment.

E. No undo or very little undo data is generated during the execution of the TRUNCATE command.

Answer: ADE


Q23. View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

A. The DBA is working on the incident and prefers that the incident be kept in the ADR

B. The incident is now in the Done state and the ADR can select the incident to be purged

C. The incident has been newly created and is in the process of collecting diagnostic information

D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

Answer: D


Q24. You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.

Which constraints will remain enabled by default during this operation? (Choose all that apply.)

A. CHECK

B. UNIQUE

C. NOT NULL

D. PRIMARY KEY

E. FOREIGN KEY

Answer: BCD


Q25. Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

A. Run the root.sh script.

B. Create the oraInst.loc file.

C. Create the tnsnames.ora file.

D. Run the oraInstRoot.sh script.

Answer: B


Q26. 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.

Answer: BE


Q27. Which three operations require undo data? (Choose three.)

A. Committing a transaction

B. Flashing back a transaction

C. Recovering a failed transaction

D. Running a read-consistent query

E. Changing a tablespace status from READ ONLY to READ WRITE

Answer: BCD


Q28. 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

Answer: C


Q29. 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.

Answer: A


Q30. You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?

A. Multiplex all database files.

B. Configure the Flash Recovery Area.

C. Configure the database instance for ARCHIVELOG mode.

D. Configure the FAST_START_MTTR_TARGET initialization parameter.

Answer: C