Proper study guides for Update Oracle Oracle Database 11g: Administration I certified begins with Oracle 1z0 052 pdf preparation products which designed to deliver the Verified 1z0 052 pdf questions by making you pass the 1z0 052 pdf test at your first time. Try the free 1z0 052 dumps demo right now.
♥♥ 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
Q61. You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)
A. Flashback log files
B. Backups that have become obsolete
C. User managed backups of the data files and control files
D. Archived redo log files that have multiple copies in a different archive location and not backed up
Answer: AB
Q62. Note the following points describing various utilities in Oracle Database 11g:
Which point describes the Oracle Data Pump utility?
1. It enables the transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3. It enables the loading of data from an external file into tables of an Oracle Database
4. It provides a tape backup management for the Oracle ecosystem
A. 1
B. 2
C. 3
D. 4
E. 1 and 3
F. 1, 2, 3 and 4
Answer: A
Q63. Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)
A. The SGA advisor will be disabled
B. The MTTR advisor will be disabled
C. Automatic checkpoint tuning will be disabled
D. Checkpoint information will not be written to the alert log file
Answer: BC
Q64. Note the following functionalities of various background processes:
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?
A. Archiver Process (ARCn): 1, 2, 5
B. System Monitor Process (SMON): 1, 4, 5
C. Process Monitor Process (PMON): 4, 5, 6
D. Database Writer Process (DBWn): 1, 3, 4
Answer: C
Q65. 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
Q66. Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)
A. You can load data into multiple tables during the same load session
B. You can load data from multiple files to a table during the same load session
C. You cannot perform selective data loading based on the values available in the records
D. You can use an export file generated by the EXPDP utility as an input data file to load the data
E. You can load data only if the input file is available on the disk and tape but not a named pipes
Answer: AB
Q67. 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
Q68. 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
Answer: C
Q69. You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:
Checking available swap space requirements ...
Expected result: 1512MB
Actual Result: 1018MB
Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the required swap space.
What happens to the installation in this situation?
A. It can be continued.
B. It resizes the swap space automatically when you proceed further.
C. It can be continued, but the instance cannot be started without increasing the swap space.
D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.
Answer: A
Q70. 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
