Testpassport 1z0-052 题库

11g 1z0-052 试题库由资深IT认证讲师和 11g 产品专家结合 PROMETRIC 或 VUE 的真实考试环境最新原题倾心打造.最新 1z0-052题库

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

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

2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

A.All AWR tables belong to the SYSTEM schema.

B.The AWR contains systemwide tracing and logging information.

C.The snapshots collected by the AWR are accessible through data dictionary views.

D.The snapshots collected by the AWR are used by self-tuning components in the database.

Answer: CD

3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in

poor database performance. Which option would you use to reduce fragmentation without affecting the

users who are currently using the index?

A.Validate the index structure using the ANALYZE...INDEX command.

B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.

C.Change the block space utilization parameters using the ALTER INDEX command.

D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.

Answer: B

4. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of

backups that can be performed on the database?

A.You can perform online whole database backups.

B.You can perform offline whole database backups.

C.You cannot perform schema-level export/import operations.

D.You can perform the backup of only the SYSTEM tablespace when the database is open.

Answer: B

5. The database instance is currently using SPFILE. View the Exhibit and examine the error that you

received while running the DB Structure Integrity check.

Given below are the steps to recover from the error in random order:

1: Shut down the instance, if not already done.

2: Copy one of the remaining control files to a new location.

3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of

the control files.

4: Start up the database instance to the NOMOUNT stage.

5: Recover the database to the point of failure of the control file.

6: Open the database.

Identify the correct sequence of steps?

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

B.2, 4, 3, 5, 6; 1 not required

C.4, 5, 6, 2, 3; 1 not required

D.5, 2, 3, 4; 1 and 6 not required

Answer: A

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

7. You have issued a SHUTDOWN ABORT command to bring down 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, 2, 3,7, 5, 6, 4

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

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

Answer: A

8. Observe the information in the columns:

1: The SGAa. Text and parsed forms of all SQL statements

2: The cursor stateb. Run-time memory values for the SQL statement, such as rows retrieved

3: User-session datac. Security and resource usage information

4: The stack spaced. Local variables for the process

Which option has the correct match between the memory areas and their contents?

A.1-c, 2-b, 3-d, 4-a

B.1-c, 2-b, 3-d, 4-a

C.1-a, 2-b, 3-c, 4-d

D.1-a, 2-b, 3-d, 4-c

Answer: C

9. 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 executes successfully.

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

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

ADMIN_OPTION.

D.The command produces an error because SL_REP does not have the SELECT privilege with

GRANT_OPTION on the EMP table.

Answer: A

10. Examine the following statement that is used to modify the constraint on the SALES table:

SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;

Which three statements are true regarding the above command? (Choose three.)

A.The constraint remains valid.

B.The index on the constraint is dropped.

C.It allows the loading of data into the table using SQL *Loader.

D.New data conforms to the constraint, but existing data is not checked.

E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

Answer: ABC

有需要的朋友自己下载（PDF格式）