Want to Pass 1Z0-052 Exam In Next HOURS? Get it now →
October 7, 2017

[Avant-garde] 1z0 052 dumps

Our pass rate is high to 98.9% and the similarity percentage between our 1z0 052 dumps study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle oracle database 11g administration i 1z0 052 exam in just one try? I am currently studying for the Oracle 1z0 052 pdf exam. Latest Oracle 1z0 052 dumps Test exam practice questions and answers, Try Oracle 1z0 052 dumps Brain Dumps First.

Q91. Your database is in shutdown state. What will happend if you issue next command:

SQL> startup

A. instance will started

B. instance started and DB is mounted

C. instance started, DB opened and finally mounted

D. instance started, DB mounted and finally opened

Answer: D

Q92. Examine the commands executed in the following sequence:

Which statement is true about the above commands?

A. The commands execute successfully.

B. Command 6 produces an error because of circular role grant.

C. Command 5 produces an error because a role cannot be granted to another role.

D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.

E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

Answer: B

Q93. Note the following points describing various utilities in Oracle Database 11g:

1. It enables the high-speed transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

3. It enables the loading of data from an external file into table of an Oracle Database

4. It provides a tape backup management for the Oracle ecosystem

Which point describes Oracle Secure Backup?

A. 1

B. 2

C. 3

D. 4

E. 1,2 and 4

F. 1,2,3, and 4

Answer: D

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

A. Modify the column using the ALTER TABLE ... MODIFY command.

B. Add a UNIQUE constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

C. Add a NOT NULL constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

D. Add a PRIMARY KEY constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

Answer: A

Q95. You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.

View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?



C. /u01/app/oracle/admin/orcl/adump

D. /u01/app/oracle/flash_recovery_area

E. ORACLE_BASE/diag/rdbms/orcl/alert

F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Answer: F

Q96. View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:

A. init.ora

B. spfile.ora

C. initorcl.ora

D. spfile+ASM.ora

Answer: B

Q97. You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:

1) Shut down the instance.

2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.

3) Execute the ALTER DATABASE FLASHBACK OFF command.

4) Start up the instance and mount the database.

5) Execute the ALTER DATABASE FLASHBACK ON command.

6) Open the database.

Select the correct order in which these tasks need to be performed.

A. 2, 1, 4, 3, 5, 6

B. 1, 4, 3, 2, 6, 5

C. 1, 4, 2, 6, 3, 5

D. 3, 2, 1, 4, 5, 6

Answer: A

Q98. You want to create a role to meet these requirements:

1. The role is to be protected from unauthorized usage.

2. The password of the role is not to be embedded in the application source code or stored in a table.

Which method would you use to restrict enabling of such roles?

A. Create the role with external authentication. B.

Create the role as a secure application role. C.

Create the role as a password-protected role.

D. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.

Answer: B

Q99. You used the IMMEDIATE option to shutdown 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 read.

4. Instance recovery is started.

5. Background processes are started.

6. Data files 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, 5, 7, 2, 3, 6; step 4 is not required

C. 7, 1, 5, 2, 3, 6 step 4 is not required

D. 1, 2, 3, 5, 6, 4; step 7 is not required

Answer: C

Q100. View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

A. The DBA is working on the incident and prefers that the incident be kept in the ADR

B. The incident is now in the Done state and the ADR can select the incident to be purged

C. The incident has been newly created and is in the process of collecting diagnostic information

D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

Answer: D

see more free 1Z0-052 exam dumps