Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-052 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

Which two are true about AWR snapshots? (Choose two.)

A They are always created automatically.
B They can be modified by using DMLs.
C They are not generated if STATISTICS_LEVEL is set to TYPICAL.
D They are stored in the SYSAUX tablespace.
E They can be retained forever.

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

Question 5

Examine these commands and their output:

Question Image

A power failure occurs. The instance is restarted and this query is executed.
SQL> SELECT ename FROM emp;
What is the outcome?

A No rows are returned
B Only Adam and Alan are displayed
C Adam, Alan, Ben, and Bryan are displayed
D Only Adam, Alan, and Bryan are displayed
E Only Adam, Alan, and Ben are displayed

Question 6

Your database is configured in archivelog mode.
The USERS01 tablespace is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

A either the NORMAL or the IMMEDIATE clause
B only the IMMEDIATE clause
C either the NORMAL or the TEMPORARY clause
D only the TEMPORARY clause
E only the NORMAL clause

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 2 • Questions 1-25 of 26

1 2

→

Know a question that should be here? Contribute to this exam

You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:

Each student must be uniquely identifiable by the STUDENT_ID.
STUDENT_ID column should not be left blank.
The student should not be less than 15 years of age.
The student can only take a course that is specified in the COURSE table in the database.
Which three constrains must be explicitly enforced on this table? (Choose three.)

A check constraint on the COURSE_ID column
B foreign key constraint on the COURSE_ID column
C check constraint on the DATE_OF_BIRTH column
D unique key constraint on the STUDENT_ID column
E not null constraint on the DATE_OF_BIRTH column
F primary key constraint on the COURSE_ID column

Which three are true about auditing? (Choose three.)

A DDL statements can be audited when they fail to execute.
B Audit of the use of system privileges can be enabled for individual database users.
C Auditing is active only when the database is OPEN.
D All Oracle auditing operations occur by default.
E Audit records are always stored in the database.
F DML statements can be audited when they execute successfully.