It is more faster and easier to pass the Oracle 1Z0-052 exam by using Accurate Oracle Oracle Database 11g: Administration I questuins and answers. Immediate access to the Down to date 1Z0-052 Exam and find the same core area 1Z0-052 questions with professionally verified answers, then PASS your exam with a high score now.

2021 Feb 1Z0-052 dumps

Q81. You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

A. No flashback is possible to bring back the ITEM table.

B. The ORDERS table is dropped along with the ITEM table.

C. The dependent referential integrity constraints in the ORDERS table are disabled.

D. The dependent referential integrity constraints in the ORDERS table are removed.

E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

Answer: AD


Q82. Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0

LOG_CHECKPOINT_INTERVAL=0

Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

Answer: BC


Q83. You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements ...

Expected result: 1512MB

Actual Result: 1018MB

Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the required swap space.

What happens to the installation in this situation?

A. It can be continued.

B. It resizes the swap space automatically when you proceed further.

C. It can be continued, but the instance cannot be started without increasing the swap space.

D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.

Answer: A


Q84. You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using the APP_USER profile.

This command is used to drop the profile:

SQL> DROP PROFILE app_user;

Which statement describes the result?

A. The command produces an error.

B. The profile is dropped and current user sessions use the DEFAULT profile immediately.

C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.

D. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

Answer: A


Q85. View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.

Which type of index would you select in this scenario?

Exhibit:

A. Bitmap index

B. Reverse key index 

C. Normal BTree index 

D. Functionbased index

Answer: A


Improve 1Z0-052 free exam questions:

Q86. 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?

A. Set REMOTE_OS_ROLES to FALSE

B. Set OS_ROLES parameter to FALSE

C. Set the REMOTE_OS_AUTHENT parameter to FALSE

D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE

Answer: C


Q87. 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 opened.

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

Answer: A


Q88. In your production database, data manipulation language (DML) operations are executed on the SALES table.

You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.

What action would you take to achieve this task?

A. Apply fine-grained auditing.

B. Implement value-based auditing.

C. Impose standard database auditing to audit object privileges.

D. Impose standard database auditing to audit SQL statements.

Answer: B


Q89. See the Exhibit:

Identify the component marked with a question mark:

A. Checkpoint (CKPT)

B. Process Monitor (PMON)

C. Archiver Processes (ARcn)

D. Recoverer Process (RECO)

E. Memory Manager Process (MMAN)

Answer: A


Q90. 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. Lock statistics for the tables.

B. Change STALE_PERCENT to zero for the tables.

C. Set the TIMED_STATISTICS parameter to TRUE.

D. Set the STATISTICS_LEVEL parameter to BASIC.

E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Answer: A