1Z0-031 Oracle - Braindumps.com.ua: question list for "Oracle9i: Database Fundamentals I", page: 18

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-031: Oracle9i: Database Fundamentals I

#171. Oracle guarantees read-consistency for queries against tables. What provides readconsistency?

#172. Which steps should you follow to increase the size of the online redo log groups?

#173. You need to determine the location of all the tables and indexes owned by one user. In which DBA view would you look?

#174. As a DBA, one of your tasks is to periodically monitor the alert log file and the background trace files. In doing so, you notice repeated messages indicating that Log Writer (LGWR) frequently has to wait for a redo log group because a checkpoint has not completed or a redo log group has not been archived. What should you do to eliminate the wait LGWR frequently encounters?

#175. The server parameter file (SPFILE) provides which three advantages when managing initialization parameters? (Choose three.)

#176. Your database is in ARCHIVELOG mode Which two must be true before the Log Writer (LGWR) can reuse a filled online redo log file? (Choose two).

#177. Which two are true about the data dictionary views with prefix USER_? (Choose two.)

#178. A DBA has issued the following SQL statement:

 SELECT max_blocks 
 FROM dba_ts_quotas 
 WHERE tablespace_name='USER_TBS' 
 AND username='JENNY';

User Jenny has unlimited quota on the USER_TBS tablespace. Which value will the query return?

#179. You created a tablespace SH_TBS. The tablespace consists of two data files: sh_tbs_datal .dbf and sh_tbs_data2.dbf. You created a nonpartitioned table SALES_DET in the SH_TBS tablespace. Which two statements are true? (Choose two.)

#180. Examine the list of steps to rename the data file of a non-SYSTEM tablespace HR_TBS. The steps are arranged in random order.
1. Shut down the database.
2. Bring the HR_TBS tablespace online.
3. Execute the ALTER DATABASE RENAME DATAFILE command
4. Use the operating system command to move or copy the file
5. Bring the tablespace offline.
6. Open the database.
What is the correct order for the steps?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [37]

gen. 0.06

Server date 08:44 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps