Master the 1z0 052 pdf Oracle Database 11g: Administration I content and be ready for exam day success quickly with this Actualtests 1z0 052 pdf exam answers. We guarantee it!We make it a reality and give you real 1z0 052 pdf questions in our Oracle oracle database 11g administration i 1z0 052 braindumps.Latest 100% VALID Oracle 1z0 052 pdf Exam Questions Dumps at below page. You can use our Oracle oracle database 11g administration i 1z0 052 braindumps and pass your exam.
Q1. You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requirements set for your database creation task are:
1. Configure the database to operate in shared server mode.
2. Disable automatic maintenance tasks such as optimizer statistics collection.
3. Configure a naming method to help the remote user connect to the database instance.
4. Use Automatic Storage Management (ASM) for storing the database files.
5. Configure daily database backup to flash recovery area.
6. Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?
A. 4 and 6
B. 2, 3, 4, and 6
C. 1, 2, 4, 5, and 6
D. 1, 2, 3, 4, 5, and 6
Answer: C
Q2. Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)
A. when the tablespace is online
B. when the tablespace has segments with data in it
C. when the tablespace is a default permanent tablespace for the database
D. when the tablespace contains a table that is currently being used by transactions
E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction
Answer: CDE
Q3. 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."
Answer: AE
Q4. For which database operation would you need the database to be in the MOUNT state?
A. Renaming the control files
B. Re-creating the control files
C. Dropping a user in your database
D. Dropping a tablespace in your database
E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
Answer: E
Q5. You plan to configure the new Oracle Database 11g installation by performing these tasks:
- Use Automatic Storage Management (ASM) as the storage option.
- Use Oracle Enterprise Manager Database Control to manage the database.
- Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during the installation.
- Configure the database to send email notifications.
Some tools available to you for installation are:
1: Oracle Universal Installer (OUI)
2: Database Configuration Assistant (DBCA)
3: Database Upgrade Assistant (DBUA)
4: Oracle Net Configuration Assistant
Which tools would you use for this installation?
A. 2
B. 3
C. 1 and 2
D. 3 and 4
E. 1,2 and 4
Answer: E
Q6. 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 SHARE MODE;
B. LOCK TABLE emp IN EXCLUSIVE MODE;
C. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'
D. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');
E. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
Answer: ABE
Q7. In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Answer: C
Q8. View the Exhibit. What would happen if Oracle Home is not empty?
A. The installation will not be continued until the location is empty.
B. The installation will proceed without overwriting the existing files.
C. The installation can be continued, but the existing files will be overwritten.
D. The installation terminates automatically after showing an error message.
Answer: A
Q9. See the Exhibit:
Identify the component marked with a question mark:
A. Checkpoint (CKPT)
B. Process Monitor (PMON)
C. Archiver Processes (ARcn)
D. Recoverer Process (RECO)
E. Memory Manager Process (MMAN)
Answer: A
Q10. Identify the memory component from which memory may be allocated for:
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)
Answer: A
Q11. The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:
Which statement is true after HR issues the REVOKE command?
A. The command fails because SCOTT still has privileges.
B. The command succeeds and privileges are revoked from JIM.
C. The command fails because HR cannot revoke the privileges from JIM.
D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
Answer: C
Q12. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. The ADDM requires at least four AWR snapshots for analysis
B. The ADDM runs after each AWR snapshot is collected automatically by MMON
C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
D. The ADDM analysis provides only diagnostics information but does not provide recommendations
E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
Answer: BC
Q13. You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.
What is the location of the alert_orcl.log file?
A. ORACLE_HOME/dbs
B. ORACEL_HOME/rdbms
C. /u01/app/oracle/admin/orcl/adump
D. /u01/app/oracle/flash_recovery_area
E. ORACLE_BASE/diag/rdbms/orcl/alert
F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace
Answer: F
Q14. You are managing an Oracle Database 11g database with the following backup strategy:
1. On Sunday, an incremental level 0 tape backup is performed
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed
Which two statements are true regarding the backups performed? (Choose two.)
A. The backup performed in step 1 backs up all blocks that have ever been in use in the database
B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1
Answer: AB
Q15. 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
Answer: A