1Z0-052 試験問題を無料オンラインアクセス

Which two statements are true regarding a tablespace? (Choose two.)

• A.It can consist of multiple data files
• B.It can contain blocks of different files
• C.It can span multiple databases
• D.It can contains a part of nonpartitioned segment
• E.It can contains segments of different sizes

You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.
Which is the most effective method to access this data in your database?

• A.Use the Oracle Data Pump utility.
• B.Use the database link.
• C.Create an external table and leave the data in the flat file.
• D.Use the SQL*Loader utility.

A database instance was terminated due to a lost data file and has not been restarted.
You wish to restore database availability by using the Data Recovery Advisor.
Examine this list of RMAN commands:

What are the minimum required commands and in what order must they be executed to achieve this?

• A.1, 2, 3, 4, and 5
• B.1, 2, 3, and 4
• C.1, 3, and 4
• D.1, 3, 4, and 5
• E.1 and 4

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.Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command
• B.Validate the index structure using the ANALYZE .... INDEX command
• C.Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command
• D.Change the block space utilization parameters using the ALTER INDEX command

You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requirements set for your database creation task are:
1 . Configure the database to operate in shared server mode.
2 . Disable automatic maintenance tasks such as optimizer statistics collection.
3 . Configure a naming method to help the remote user connect to the database instance.
4 . Use Automatic Storage Management (ASM) for storing the database files.
5 . Configure daily database backup to flash recovery area.
6 . Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?

• A.2, 3, 4, and 6
• B.4 and 6
• C.1, 2, 4, 5, and 6
• D.1, 2, 3, 4, 5, and 6