Act now and download your Oracle 1Z0-052 test today! Do not waste time for the worthless Oracle 1Z0-052 tutorials. Download Up to the minute Oracle Oracle Database 11g: Administration I exam with real questions and answers and begin to learn Oracle 1Z0-052 with a classic professional.
2021 Feb 1Z0-052 test preparation
Q1. 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
Q2. 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
Answer: CD
Q3. Which three statements are correct about temporary tables? (Choose three.)
A. Indexes and views can be created on temporary tables
B. Both the data and structure of temporary tables can be exported
C. Temporary tables are always created in a user's temporary tablespace
D. The data inserted into a temporary table in a session is available to other sessions
E. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables
Answer: ACE
Q4. View the Exhibit.
You are creating an additional database by using the Database Configuration Assistant (DBCA).
You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled.
What could be the reason for this?
A. You have chosen the File System option as the storage option.
B. You have chosen the Automatic Storage Management (ASM) as the storage option.
C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
D. You are using General Purpose template and not the Custom Database template to create the database.
Answer: D
Q5. View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.
Which action would you take to release the lock and enable users HR and SH to continue with their transactions?
07 (exhibit):
A. Kill the session of the user SCOTT with session ID118.
B. Issue manual checkpoint using the ALTER SYSTEM command.
C. Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.
D. Flush the Shared Pool to remove the SQL statement causing "wait" in memory.
Answer: A
Refresh 1Z0-052 book:
Q6. 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
Q7. 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
Q8. The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1. Shut down the instance, if not already done.
2. Copy one of the remaining control files to a new location.
3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:
A. 1, 2, 4, 3, 5, 6
B. 2, 4, 3, 5, 6; 1 not required
C. 4, 5, 6, 2, 3; 1 not required
D. 5, 2, 3, 4; 1 and 6 not required
Answer: A
Q9. Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects. Which method would you adopt to achieve this objective?
A. Revoke the RESOURCE role from the users.
B. Set the value of the OS_ROLES parameter to TRUE.
C. Use Database Resource Manager to restrict user access to objects.
D. Grant ANY TABLE system privileges again without ADMIN OPTION.
E. Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.
Answer: E
Q10. 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