Oracle 1Z0-052 Dumps 2023 | You Need Exam Questions
Whether you’re new or experienced, our 1Z0-052 dumps 2023 will help you prepare for the Oracle 1Z0-052 exam.
The updated version of PassITDump 1Z0-052 dumps 2023 consists of 285 new questions from the latest exams to ensure they are authentic and valid. Definitely, that 1Z0-052 exam question you need!
The following questions and answers are from the latest 1Z0-052 free dumps. It will help you understand the validity of the latest 1Z0-052 dumps.
Question 1:
Which four are true about the tools used to administer Oracle databases? (Choose four.)
A. SQL *Plus can be used to create databases
B. DBCA can be used to upgrade databases
C. RMAN can be used to start up Oracle instances
D. SQL *Plus can be used to start up Oracle instances
E. SRVCTL can be used to shut down Oracle instances
F. Data Pump can be used to load data from text files
Correct Answer: ABCD
Question 2:
Which three are true about UNDO data? (Choose three.)
A. It is used during online backups to guarantee their consistency
B. It is used to roll back failed transactions
C. It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP
D. It is used to rewind a database by using FLASHBACK DATABASE
E. It is used to provide read consistency
F. It is used to enable ROLLBACK statements to roll back uncommitted updates
Correct Answer: DEF
Question 3:
Your database is open in ARCHIVELOG mode.
LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes
place.
What is the outcome?
A. The archivelog entries are made in the diagnostic destination and when space is available, new archivelogs are generated
B. Obsolete backups are automatically deleted and new archivelogs are generated
C. All active sessions hang until the database administrator (DBA) makes space available in the FRA
D. No archivelogs are generated
E. All active sessions are disconnected and their transactions rolled back
Correct Answer: B
Question 4:
Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)
A. UNDO segments grow or shrink automatically
B. UNDO tablespaces are created and dropped automatically
C. UNDO segments are created and dropped automatically
D. UNDO tablespaces are brought ONLINE or OFFLINE as required
E. All transactions belonging to a single session use the same UNDO segment
Correct Answer: AB
Question 5:
Which two are true about roles? (Choose two.)
A. A role can be created only by a user with the SYSDBA privilege.
B. A role can be granted only multiple system privileges not multiple object privileges.
C. A role can be granted to another role.
D. A role can be password-protected.
E. Only one default role can be granted to a user.
Correct Answer: CD
Question 6:
Which two are true about the Data Recovery Advisor? (Choose two.)
A. It can be used when a database IS MOUNTED
B. It can be used when a database IS OPEN
C. It can be used only with databases that are running in ARCHIVELOG mode
D. It can repair only databases for which RMAN backups exist
E. It can be used to take RMAN backups
F. It can be used to validate RMAN backups
Correct Answer: DF
Question 7:
Which two are true about data dictionary views? (Choose two.)
A. DBA prefixed views are accessible when a database is in mount state
B. A user can query the DBA prefixed with DBA or ALL or USER
C. All data dictionary views are prefixed with DBA or ALL or USER
D. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views
E. ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views
Correct Answer: CD
Question 8:
Examine these facts about a database:
The database default tablespace is USERS DEFERRED_SEGMENT_CREATION IS TRUE The default tablespace of USER1 is tbs1 USER1 has only these privileges: CREATE SESSION CREATE TABLE UNLIMITED quota on tbs1
Examine these commands executed by USER1: What will be the outcome of the INSERT operation and why?
A. A row will be inserted into EMP and an index entry will be inserted into a virtual column of EMP because USER1 has no quota on USERS
B. It will fail because an indexed column cannot have NULL values
C. It will fail because USER1 has no quota on USERS
D. A row will be inserted into EMP but no index entry will be made into EMP_IDX
E. A row will be inserted into EMP and an index entry will be made into EMP_IDX
Correct Answer: E
Question 9:
Which three are true about dynamic performance views? (Choose three.)
A. Read consistency is not guaranteed for these views
B. Some of them display data that is useful for SQL statement tuning
C. They display selected data from data dictionary base tables
D. They can be queried only by SYS even when the database is open
E. They contain information that is not available in data dictionary views
Correct Answer: ADE
Question 10:
Which is true about the Database Configuration Assistant (DBCA)?
A. It can register a database with Cloud Control and configure Database Control for the same database.
B. It can change the server mode from dedicated to shared and vice versa for an existing database.
C. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.
D. It can create new database templates only from existing templates or databases.
Correct Answer: D
Question 11:
You want to install an Oracle 11g database and deploy it on ASM. Your plan is to install both Oracle database and Grid Infrastructure.
Which two are true in this scenario? (Choose two.)
A. Grid Infrastructure must be installed first
B. Both products must be installed by the same OS user
C. Each product must be installed in a different ORACLE_HOME
D. Both products must be installed by using the same ORACLE_BASE
E. Both products must be of the same version
F. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups
Correct Answer: CF
Question 12:
Which two are true about external tables? (Choose two.)
A. They can be stored in Oracle Automatic Storage Management File System (Oracle ACFS)
B. They can always be updated using SQL
C. They have extents
D. They support the ORACLE_DATAPUMP access driver.
E. They support all DML operations.
Correct Answer: BD
Question 13:
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:
1.
SGA is allocated.
2.
Control file is read.
3.
Redo log files are read.
4.
Instance recovery is started.
5.
Background processes are started.
6.
Data file headers are checked for consistency.
7.
Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?
A. 7, 1, 5, 2, 3, 6, 4
B. 1, 2, 3, 7, 5, 6, 4
C. 7, 1, 4, 5, 2, 3, 6
D. 1, 7, 5, 4, 2, 3, 6
Correct Answer: A
Question 14:
Where is backup metadata stored for use by Recovery Manager (RMAN)?
A. in the SYSTEM tablespace
B. in the control file
C. in the SPFILE
D. in the SYSAUX tablespace
E. in the diagnostic destination files
Correct Answer: B
Question 15:
Which is true about invalid PL/SQL objects?
A. They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.
B. They are automatically recompiled against the new definition of a referenced object when they are called.
C. They are automatically recompiled against the new definition of a referenced object at the same time as the modified referenced object.
D. They can be manually recompiled only by using SQL commands.
Correct Answer: B