1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 21

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#201. You need to create an index on the CUSTOMER_ID column of the CUSTOMERS table.
The index has these requirements:
1. The index will be called CUST_PK.
2. The index should be sorted in ascending order.
3. The index should be created in the INDEX01 tablespace, which is a dictionary
4. All extents of the index should be 1 MB in size.
5. The index should be unique.
6. No redo information should be generated when the index is created.
7. 20% of each data block should be left free for future index entries.
Which command creates the index and meets all the requirements?

#202. Which data dictionary view would you use to get a list of all database users and their default settings?

#203. User A issues this command:

 UPDATE emp 
 SET id=200 
 WHERE id=1

Then user B issues this command:

 UPDATE emp 
 SET id=300 
 WHERE id=1

User B informs you that the UPDATE statement seems to be hung. How can you resolve the problem so user B can continue working?

#204. Which statement about an Oracle instance is true?

#205. You decided to use multiple buffer pools in the database buffer cache of your database. You set the sizes of the buffer pools with the DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE parameters and restarted your instance. What else must you do to enable the use of the buffer pools?

#206. Which three statements are true about the use of online redo log files? (Choose three.)

#207. Your database contains a locally managed uniform sized tablespace with automatic segmentspace management, which contains only tables. Currently, the uniform size for the tablespace is 512 K. Because the tables have become so large, your configuration must change to improve performance. Now the tables must reside in a tablespace that is locally managed, with uniform size of 5 MB and automatic segment-space management.
What must you do to meet the new requirements?

#208. You need to create an index on the PASSPORT_RECORDS table. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator. Which type of index would be best for this type of table?

#209. Which statement about the shared pool is true?

#210. Which two actions cause a log switch? (Choose two.)

[1] ... [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] ... [85]

gen. 0.064

Server date 06:11 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump