Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion

You are using flat files as the data source for one of your data warehousing applications.
To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

Which two statements are true regarding Oracle Data Pump? (Choose two.)

Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

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

View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

Examine the following output:

Which two statements about the above index are true? (Choose two.)

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command? (Choose two.)

The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace.
Which three action would allow the user to insert data? (Choose three.)

You have an ORDERS table with the following structure:

The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future.
Which method would serve the purpose?

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

Which are the two possible solutions to enable SMITH to query the data in V$SESSION?
(Choose two.)

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?