Latest Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion, Page 9

Question #113

View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body?
Exhibit:

A. The USE_P procedure becomes invalid.

B. The USE_P procedure remains valid.

C. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.

D. The SHOW_DETAIL procedure becomes invalid.

Discussion 0

Correct Answer: B Vote an answer

Question #114

Examine these components:
* Execution plan for a non-embedded SQL statement
* Local, global, and package variables for a session
* Execution plan for a SQL statement contained in a PL/SQL program unit
* Results of executed queries and query fragments
* PL/SQL function result sets
Which of these are stored in the shared SQL area?

A. 1, 2, 4, and 5

B. 1, 2, and 3

C. 1 and 3

D. 1 and 4

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #115

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

A. You can compress the data during export but not the metadata because it is not supported.

B. You cannot export data from a remote database.

C. You can overwrite existing dump files during an export operation.

D. You can rename tables during an import operation.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #116

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?

A. The command produces an error because the EMP table is owned by SCOTT

B. The command executes successfully

C. The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table

D. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION

Discussion 0

Correct Answer: B Vote an answer

Question #117

You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?

A. REMAP_SCHEMA

B. SCHEMAS

C. FULL

D. TRANSFORM

E. REMAP_TABLESPACE

Discussion 0

Correct Answer: A Vote an answer

Question #118

Note the following structures in your database server:
1 . Extents
2 . OS Blocks
3 . Tablespace
4 . Segments
5 . Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?

A. 2, 5, 1, 4, 3

B. 1, 2, 3, 4, 5

C. 5, 2, 1, 3, 4

D. 2, 1, 5, 4, 3

Discussion 0

Correct Answer: A Vote an answer

Question #119

In your database:
SGA_TARGET = 270M
PGA_AGGREGATE_TARGET = 90M
The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not
configured.
You execute the command:
ALTER SYSTEM SET MEMORY_TARGET = 400M;
What is the outcome and why?

A. The execution is successful but does not enable automatic memory management because the MEMORY_MAX_TARGET parameter must be configured to a value greater than MEMORY_TARGET

B. The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are
already configured

C. The execution is successful and automatic memory management is enabled

D. The execution fails because the MEMORY_MAX_TARGET parameter must be
configured to 400M before configuring the MEMORY_TARGET parameter

Discussion 0

Correct Answer: C Vote an answer

Question #120

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

A. An extent cannot spread across data files.

B. A data file can belong to only one tablespace.

C. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

D. A segment cannot spread across data files.

E. A data file can have only one segment created in it.

Discussion 0

Correct Answer: A,B Vote an answer

Question #121

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 profile is dropped and current user sessions use the DEFAULT profile immediately.

B. The command produces an error.

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

Discussion 0

Correct Answer: B Vote an answer

Question #122

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

A. They can be modified by using DMLs.

B. They are not generated if STATISTICS_LEVEL is set to TYPICAL.

C. They are always created automatically.

D. They can be retained forever.

E. They are stored in the SYSAUX tablespace.

Discussion 0

Correct Answer: A,C Vote an answer

Question #123

What function is performed by the System Monitor (SMON) background process in a database instance?

A. It monitors memory space allocation within the SGA and the Program Global Area (PGA).

B. It performs instance recovery when failed database instance is restarted.

C. It performs recovery when a user process fails.

D. It monitors memory space allocation only within the System Global Area (SGA).

Discussion 0

Correct Answer: B Vote an answer

Question #124

When would you use memory advisors?

A. to generate memory-related alerts when memory demand exceeds a specified percentage

B. to determine the impact of adding memory on logical and physical reads

C. to determine the impact of adding memory on hard parse count

D. to get a recommendation whether Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) should be implemented.

E. to determine the impact of adding or reducing memory on DB Time

Discussion 0

Correct Answer: E Vote an answer

Question #125

See the Exhibit to observe the roles assigned to the SL_REP user.

Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

A. The user cannot user the role until the DBA enables it explicitly

B. The user must enable the role explicitly

C. The user can start using the role immediately without any changes

D. The user can grant the role to other users

Discussion 0

Correct Answer: B Vote an answer

Question #126

Which is true about the Database Configuration Assistant (DBCA)?

A. It can create new database templates only from existing templates or databases.

B. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.

C. It can register a database with Cloud Control and configure Database Control for the same database.

D. It can change the server mode from dedicated to shared and vice versa for an existing database.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

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

Download Free Oracle 1Z1-052 Demo