Your success in Oracle 1z0 052 dumps is our sole target and we develop all our 1z0 052 pdf 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. oracle database 11g administration i 1z0 052 Practice Exams for Oracle oracle database 11g administration i 1z0 052 are written to the highest standards of technical accuracy.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-052 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-052 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-052-exam-dumps.html
Q11. You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)
A. No flashback is possible to bring back the ITEM table.
B. The ORDERS table is dropped along with the ITEM table.
C. The dependent referential integrity constraints in the ORDERS table are disabled.
D. The dependent referential integrity constraints in the ORDERS table are removed.
E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.
Answer: AD
Q12. View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.
Which type of index would you select in this scenario?
Exhibit:
A. Bitmap index
B. Reverse key index
C. Normal BTree index
D. Functionbased index
Answer: A
Q13. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;
REASON METRIC_VALUE
------------------------------ ----------------------
Tablespace [TEST] is [28 perce nt] full 28.125
What could be the reason for the elimination of the other rows in the output?
Exhibit:
A. An Automatic Workload Repository snapshot has been taken recently.
B. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.
D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
Answer: C
Q14. You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:
Warning (%): 90
Critical (%): 95
Which background process is responsible for issuing alerts when the threshold is crossed?
A. System monitor (SMON)
B. Process monitor (PMON)
C. Memory manager process (MMAN)
D. Manageability Monitor process (MMON)
Answer: D
Q15. In which situation would you use static database registration for a listener?
A. When multiple databases are to be registered with the listener
B. When DBAs need to connect remotely to start up the database instance
C. When users need to connect the database instance using the host naming method
D. When the database instance that is to be registered with the listener is configured in shared server mode
Answer: B
Q16. 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
Q17. View the Exhibit to examine the error that occurred during the database startup.
You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of this command?
A. The command performs the recovery and closes the failure
B. The command only displays the advice and the RMAN script required for recovery
C. The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)
D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command
Answer: D
Q18. 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
Q19. 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
Q20. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
A. Failure when no standby database is configured
B. Failure because a data file is renamed accidentally
C. Failure that requires no archive logs to be applied for recovery
D. Failure due to loss of connectivity-for example, an unplugged disk cable
Answer: BD