Exam Code: 1Z0-052 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration I
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-052 Exam.

2016 May 1Z0-052 Study Guide Questions:

Q21. Note the functionalities of various background processes:

1: Perform recovery at instance startup.

2: Free the resources used by a user process when it fails.

3: Cleanup the database buffer cache when a process fails.

4: Dynamically register database services with listeners.

5: Monitor sessions for idle session timeout.

6: Cleanup unused temporary segments.

7: Record the checkpoint information in control file.

Which option has the correct functionalities listed for a background process?

A. Checkpoint (CKPT): 1, 2, 5

B. System Monitor (SMON): 1, 6

C. Process Monitor (PMON): 4, 6, 7

D. Database Writer (DBWR): 1, 3, 4

Answer: B


Q22. You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.

Which data types would you use for the new column?

A. CLOB

B. BLOB

C. BFILE

D. LONG RAW

Answer: C


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


2passeasy.com

Regenerate 1z0-052 dumps pdf:

Q24. Automatic Shared Memory Management (ASMM) has been enabled for your database instance.

The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true in this scenario?

A. The minimum memory size for the database buffer cache is set to 100 MB.

B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

Answer: A


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


Q26. Which three statements are correct about temporary tables? (Choose three.)

A. Indexes and views can be created on temporary tables.

B. Both the data and the structure of temporary tables can be exported.

C. Temporary tables are always created in a user's temporary tablespace.

D. The data inserted into a temporary table in a session is available to other sessions.

E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

Answer: ACE


2passeasy.com

Free 1z0-052 dumps pdf:

Q27. These are points that describe the contents of different memory components:

1: Descriptive information or metadata about schema objects that are queried by using SQL statements

2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements

3: Results of SQL queries and PL/SQL functions

4: Executable forms of SQL cursors, PL/SQL programs, and Java classes

5: The information necessary to reconstruct changes made to the database by a transaction

Which of these will be stored in the Shared Pool if the necessary configurations are done?

A. 1 and 2

B. 2 and 5

C. 1,3, and 4

D. 3,4 and 5

E. 1,2,3 and 4

Answer: C


Q28. You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.

Which data types would you use for the new column?

A. CLOB

B. BLOB

C. BFILE

D. LONG RAW

Answer: C


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


Q30. You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.

Which statement is true in this case?

A. The ORACLE_BASE parameter is not set.

B. The installation is being performed by the root user.

C. The operating system group that will be specified should have root user as its member.

D. The installation is being performed without the "Create Starter Database" option selected.

E. The operating system group that will be specified must have permission to write to the inventory directory.

Answer: E