Oracle Database 11g Administration I

Here you have the best Oracle 1z0-052 practice exam questions

  • You have 37 total questions to study from
  • Each page has 5 questions, making a total of 8 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on November 29, 2024
Question 1 of 37

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?

    Correct Answer:

    The sessions that are already connected to the database instance are not affected by stopping the listener. The primary role of the listener is to manage incoming connections to the database. Once a session is connected, the listener is no longer involved in the communication between the client and the database instance. Therefore, stopping the listener will not affect active sessions, and they will continue to function normally.

Question 2 of 37

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.)

    Correct Answer: A, D

    When you set MEMORY_TARGET=500M and restart the database, MEMORY_MAX_TARGET is automatically set to 500M if it was previously set to 0. This makes option 'A' correct. Additionally, the lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters remain the same as specified, which means they are set to 90 MB and 270 MB, respectively. Therefore, option 'D' is also correct.

Question 3 of 37

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:

1) Each student must be uniquely identifiable by the STUDENT_ID.

2) STUDENT_ID column should not be left blank.

3) The student should not be less than 15 years of age.

4) 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.)

    Correct Answer: B, C, D

    To ensure the table STUDENTS meets the specified constraints, the following should be explicitly enforced: A foreign key constraint on the COURSE_ID column ensures that students can only enroll in courses listed in the COURSE table (satisfying constraint 4). A check constraint on the DATE_OF_BIRTH column ensures that the student's age is at least 15 years (satisfying constraint 3). A unique key constraint on the STUDENT_ID column ensures that each student is uniquely identifiable by their STUDENT_ID (satisfying constraint 1). While a primary key constraint on STUDENT_ID would also enforce uniqueness and not null constraints simultaneously, the combination of the chosen constraints specifically addresses the outlined requirements without assuming additional constraints not explicitly mentioned.

Question 4 of 37

Which two are true about server-generated alerts? (Choose two.)

    Correct Answer: A, E

    Stateful alerts are indeed preserved across instance restarts, which helps in maintaining alert continuity and is a crucial feature for monitoring. Additionally, by default, a server-generated alert is raised for each tablespace that has 85% or more of its space used, ensuring that resources are monitored effectively to prevent space issues.

Question 5 of 37

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?

    Correct Answer: E

    The only clause that ensures no media recovery is required when the tablespace is brought back online is the NORMAL clause. Taking a tablespace offline with the NORMAL clause guarantees that the tablespace will be in a consistent state and will not require recovery when brought back online. While the TEMPORARY clause may avoid media recovery if no write errors exist, it does not guarantee this in all cases. Thus, only the NORMAL clause reliably ensures that no media recovery will be needed.