Exam Code: 1Z0-052 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration I
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-052 Exam.
2021 Jun 1Z0-052 Study Guide Questions:
Q111. Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)
A. Undo tablespace
B. USERS tablespace
C. SYSAUX tablespace
D. SYSTEM tablespace
E. Temporary tablespace
Q112. 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
Q113. You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.
Which is the most effective method to access this data in your database?
A. Use the database link.
B. Use the SQL*Loader utility.
C. Use the Oracle Data Pump utility.
D. Create an external table and leave the data in the flat file.
Latest 1z0-052 dumps pdf:
Q114. Which two statements are true about checkpointing? (Choose two.)
A. The checkpoint frequency decreases with the smaller redo log file size.
B. It ensures that all committed data is written to the data files during normal shutdown.
C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
Q115. You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:
ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.
What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)
A. Back up the Flash Recovery Area.
B. Decrease the retention time for the database backup and flashback log files.
C. Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
D. Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.
Q116. Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
A. Recover from failures in the RAC environment.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair a data file corruption offline.
D. Diagnose and repair failures on a standby database.
Verified oracle exam 1z0-052:
Q117. Which statement is true about the Manageability Monitor (MMON) background process?
A. It transfers statistics from memory to disk at regular intervals.
B. It coordinates the rebalance activity for disk groups when ASM is used.
C. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance.
D. It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance.
Q118. 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
Q119. View the Exhibit.
You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.
Which configuration could have enabled the block selection of 16 KB?
A. Choosing the extent allocation type to uniform
B. Choosing the Segment Space Management option to manual
C. Setting autoextension on for the data file mentioned for the tablespace
D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
Q120. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?
A. The statistics collection continues until all objects are processed.
B. The job is terminated and the statistics collected are restored to a time before the job started.
C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.