1z0-032 Oracle - Braindumps.com.ua: question list for "Oracle 9i: Database Fundamentals II", page: 6

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-032: Oracle 9i: Database Fundamentals II

#51. You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas?

#52. Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three)

#53. The direct handoff connection method to an Oracle 9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated?

#54. The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these

 SELECT statements IN the ORDER shown below: 
 SELECT * FROM employees WHERE department_id=50; 
 SELECT * FROM employees WHERE department_id=70;

There is an index on the DEPARTMENT ID column of the 1,000,000 row EMPLOYEES table. Ninety percent of the employees are part of the DEPARTMENT_ID 50. In which two scenarios will Oracle 9i share the corresponding cursors for the two statements? (Choose two)

#55. An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?

#56. Data file DF1 belongs to table space TS1.,and the database is in ARCHIVE LOG mode. You did an incomplete recover in the following steps:
1. Take data file DF1 offline.
2. Copy a backup copy of DF1 into the current DF1 location.
3. Execute RECOVER DATA FILE UNTIL TIME sometime in the past.
4. Bring DF1 online.
5. Execute ALTER DATABASE OPEN RESET LOGS.
To guarantee that the database is recoverable in the future, what is the least amount of work needed?

#57. Some data storage and transfer media have fixed-length physical records.
When the data records are short, more then one can be stored in a single, physical record to use the storage space efficiently. Consider this data:

 1119    Smith    1120    Yvonne 
 1121    Albert   1130    Thomas

Which two statements can you use to load the data into the EMP table? (Choose two)

#58. Which three statements about direct path exports are true? (Choose three)

#59. In RMAN, when the RESYNC CATALOG command is issued, in which two situations does the command file actually perform synchronization? (Choose two)

#60. Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago, you just archived arch_4.arch to tape, then removed all archived files to save disk space.
Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today, you see arch_3.arc in the archive directory. Which two could you happened? (Choose two)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37]

gen. 0.067

Server date 05:40 02-12-2008

Oracle 1z0-032

Forum

Start online exam simulation

Master braindump

User braindumps