Download Oracle Database 11g: Administration I.1z0-052.ExamTopics.2026-07-12.39q.vcex

Vendor: Oracle
Exam Code: 1z0-052
Exam Name: Oracle Database 11g: Administration I
Date: Jul 12, 2026
File Size: 490 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Which of these is true about undo tablespace?
  1. Undo tablespace is a temporary tablespace.
  2. Undo tablespace has only one datafile
  3. Undotablespace has a datafile which is reused in cyclic manner
Correct answer: A
Question 2
View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_REP user executes this command to create a table:
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes the effect of the command?
Exhibit:
  1. The command executes successfully and creates the table in the USERS tablespace.
  2. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
  3. The command produces an error because the user does not have the privilege to createthe table.
  4. The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
Correct answer: B
Question 3
You set the following parameters in the parameter file and restarted the database:
Which two statements are true about these parameters after the database instance is restarted?
(Choose two.)
  1. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  2. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
  3. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
  4. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
Correct answer: A, D
Question 4
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP
What happens to the sessions that are presently connected to the database instance?
  1. The sessions are able to perform only queries
  2. The sessions are not affected and continue to function normally
  3. The sessions are terminated and the active transactions are rolled back
  4. The sessions are not allowed to perform any operations till the listener is started
Correct answer: B
Question 5
Examine these facts about a database:
  1. The database default tablespace is USERS
  2. DEFERRED_SEGMENT_CREATION IS TRUE
  3. The default tablespace of USER1 is tbs1
  4. USER1 has only these privileges:
    1. CREATE SESSION
    2. CREATE TABLE
    3. UNLIMITED quota on tbs1
Examine these commands executed by USER1:
What will be the outcome of the INSERT operation and why?
  1. 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
  2. It will fail because an indexed column cannot have NULL values
  3. It will fail because USER1 has no quota on USERS
  4. A row will be inserted into EMP but no index entry will be made into EMP_IDX
  5. A row will be inserted into EMP and an index entry will be made into EMP_IDX
Correct answer: E
Question 6
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to /u01/oracle/db01.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)
  1. RMAN backups
  2. data files
  3. archived redo logs
  4. temp files
  5. control files
  6. audit logs
  7. audit files
  8. redo logs
Correct answer: B, E, F, H
Explanation:
Reference: https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams051.htm#REFRN10034
Reference: https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams051.htm#REFRN10034
Question 7
Which two are true about data dictionary views? (Choose two.)
  1. DBA prefixed views are accessible when a database is in mount state
  2. A user can query the DBA prefixed with DBA or ALL or USER
  3. All data dictionary views are prefixed with DBA or ALL or USER
  4. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views
  5. ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views
Correct answer: C, D
Question 8
Which four are true about the tools used to administer Oracle databases? (Choose four.)
  1. SQL *Plus can be used to create databases
  2. DBCA can be used to upgrade databases
  3. RMAN can be used to start up Oracle instances
  4. SQL *Plus can be used to start up Oracle instances
  5. SRVCTL can be used to shut down Oracle instances
  6. Data Pump can be used to load data from text files
Correct answer: A, B, C, D
Question 9
In a database, EXAMPLE is the default tablespace and DEFERRED_SEGMENT_CREATION is FALSE.
Examine these commands executed by SYS:
What will be the outcome and why?
  1. U1.TAB1 will be created
  2. It will fail because U1 has no quota on EXAMPLE
  3. It will fail because U1 has no default tablespace
  4. It will fail because U1 does not have the CREATE TABLE privilege
  5. It will fail because U1 does not have the CREATE SESSION privilege
Correct answer: D
Explanation:
Reference: http://www.dba-oracle.com/t_oracle_deferred_segment_creation.htm
Reference: http://www.dba-oracle.com/t_oracle_deferred_segment_creation.htm
Question 10
Which two events always cause the LGWR to write? (Choose two.)
  1. when a checkpoint occurs
  2. when DBWn writes dirty buffers
  3. when LGWR is notified by a server process that performs a COMMIT OR ROLLBACK
  4. when a log switch occurs
  5. when PMON restarts a server process
Correct answer: A, D
Question 11
Which is true about the SYSTEM and SYSAUX tablespaces?
  1. Both tablespaces can be used for temporary storage if no temporary tablespace is defined
  2. Both tablespaces must be online for a database to be accessible
  3. The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot
  4. Only the SYSTEM tablespace contains data dictionary tables
Correct answer: C
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!