1z0-052 study guide (131 to 140)

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:

Q131. View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

ORA-01555: snapshot too old What could be the reason for this error?

Exhibit:


A. The query is unable to get a read-consistent image.

B. There is not enough space in Flash Recovery Area.

C. There is not enough free space in the flashback archive.

D. The query is unable to place data blocks in undo tablespace.

Answer: A


Q132. Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

A. Running a query on a table returns "ORA-600: Internal Error."

B. Inserting a value in a table returns "ORA-01722: invalid number."

C. Creating a table returns "ORA-00955: name is already used by an existing object."

D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

Answer: AE


Q133. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. The database files are corrupted when the database is open

B. The user has dropped an important table that needs to be recovered

C. The archived redo log files are missing for which the backup is not available

D. The database is not opening because the required database files are missing

Answer: AD


1Z0-052  exam cost

Update 1z0-052 dumps:

Q134. Examine the command:

SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');

Which statement describes the effect of the above command?

A. Automatic statistics collection is stopped for the CUSTOMERS table

B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Answer: D


Q135. You notice that the performance of the database has degraded because of frequent checkpoints.

Which two actions resolve the issue? (Choose two.)

A. Disable automatic checkpoint tuning

B. Check the size of the redo log file size and increase the size if it is small

C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group

Answer: BC


Q136. In which situation would you use static database registration for a listener?

A. When multiple databases are to be registered with the listener

B. When DBAs need to connect remotely to start up the database instance

C. When users need to connect the database instance using the host naming method

D. When the database instance that is to be registered with the listener is configured in shared server mode

Answer: B


1Z0-052  exam cost

Real 1z0-052 dumps pdf:

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


Q138. You are using Enterprise Manager to schedule backups for your database.

Which type of script would be generated by the backup scheduler?

A. XML script

B. PL/SQL script

C. Operating system script

D. Recovery Manager (RMAN) script

Answer: D


Q139. Identify the memory component from which memory may be allocated for:

Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

A. Large Pool

B. Redo Log Buffer

C. Database Buffer Cache

D. Program Global Area (PGA)

Answer: A


Q140. You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.

View the Exhibit to examine the commands used to create tables.

Which action would you take to delay the referential integrity checking until the end of the transaction?

Exhibit:


A. Set the constraint to deferred before starting the transaction

B. Alter the constraint to NOVALIDATE state before starting the transaction

C. Enable the resumable mode for the session before starting the transaction

D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

Answer: A



see more 1Z0-052 dumps