Free 1Z0-055 Questions for Oracle 1Z0-055 Exam

Question #1

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10 GB each. Which method would accomplish the task quickly and efficiently?

A. intrafile parallel backup

B. parallel image copy backup

C. backup with MAXPIECESIZE configured for the channel

D. parallel backup with MAXPIECESIZE configured for the channel

Discussion 0

Correct Answer: A Vote an answer

Question #2

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans can be manually loaded to the SQL plan baseline.

B. The plans generated for every SQL statement are stored in the SQL plan baseline by default.

C. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

D. The plan baselines are stored temporarily in the memory as long as the database instance is running.

E. The plans in the SQL plan baseline are verified and accepted plans.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #3

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?

A. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

C. The EMPLOYEES table will be changed to read-only mode during the shrink operation.

D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

Discussion 0

Correct Answer: A Vote an answer

Question #4

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup.
You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)

A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

C. Restore metadata in an existing disk group by passing the existing disk name as an input parameter.

D. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

Discussion 0

Correct Answer: A,C Vote an answer

Question #5

Observe the following PL/SQL block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
Which statement is correct regarding the above PL/SQL block?

A. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).

B. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

C. It reserves 30% of the space in the SYSTEM tablespace for SMB.

D. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.

Discussion 0

Correct Answer: B Vote an answer

Question #6

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

A. It contains the statement log, the plan history, plan baselines, and SQL profiles.

B. It is part of the data dictionary and stored in the SYSTEM tablespace.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It contains only SQL profiles generated by SQL Tuning Advisor.

E. It stores plans generated by the optimizer using a stored outline.

Discussion 0

Correct Answer: A,C Vote an answer

Question #7

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

A. TEST_TBS is a bigfile tablespace (BFT).

B. TEST_TBS is a small file tablespace.

C. TEST_TBS is the default temporary tablespace.

D. TEST_TBS is a dictionary-managed tablespace.

Discussion 0

Correct Answer: D Vote an answer

Question #8

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY
TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

A. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

B. All archived redo log files backed up at least twice to tape are deleted.

C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D. All archived redo log files backed up at least once to tape are eligible for deletion.

Discussion 0

Correct Answer: A Vote an answer

Question #9

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

A. temporary tables

B. fixed tables

C. Index-Organized Tables (IOTs)

D. heap tables

E. external tables

Discussion 0

Correct Answer: C,D Vote an answer

Question #10

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

A. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

B. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

C. The newly generated plans are directly placed into the SQL plan baseline without being verified.

D. The plan baselines can be evolved over time to produce better performance.

Discussion 0

Correct Answer: B,D Vote an answer

Question #11

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?

A. to prevent plan capturing when the SQL statement is executed after the database upgrade

B. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

C. to minimize plan regression due to the use of a new optimizer version

D. to completely avoid the use of new plans generated by a new optimizer version

Discussion 0

Correct Answer: C Vote an answer

Question #12

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

A. SQL statements that are part of the AWR baseline only

B. SQL statements that are part of the available SQL Tuning Set (STS) only

C. SQL statements that are available in the cursor cache and executed by a user other than SYS

D. SQL statements based on the AWR top SQL identification

Discussion 0

Correct Answer: D Vote an answer

Question #13

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?

A. It improves resync operations.

B. It improves performance by reading from a copy of an extent closest to the node.

C. It improves performance as fewer extent pointers are needed in the shared pool.

D. This feature enables much faster file opens.

Discussion 0

Correct Answer: B Vote an answer

Question #14

You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

A. Extent management is completely automated.

B. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

C. The allocation unit size may vary but the extent size is fixed.

D. The au_size disk group attribute determines the size of allocation units in the disk group.

Discussion 0

Correct Answer: A,D Vote an answer

Question #15

In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured.
A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command: $ SQLPLUS scott/tiger@DB01 AS SYSDBA
where DB01 is the net service name.
Which authentication method would be used first?

A. authentication by using the Oracle Internet Directory

B. authentication by using the local OS of the database server

C. authentication by password file

D. authentication by using certificates over SSL

Discussion 0

Correct Answer: C Vote an answer

Free 1Z0-055 Questions for Oracle Database 11g: New Features for 9i OCPs 1Z0-055 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z0-055 Demo