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

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

#181. You are creating a locally-managed temporary tablespace. To which value should you set UNIFORM SIZE when creating the tablespace?

#182. Which statement represents a characteristic of a segment?

#183. Evaluate this statement:

 ALTER DATABASE prod DATAFILE '/disk3/user_data01.dbf' RESIZE 50M;

Data in the data file only fills the first 30M.
What will be the size of user_data01.dbf if it was 150M when the data file was created?

#184. When the USER_DATA tablespace was created, you overestimated the amount of space required for the user01.dbf data file. The file only contains 5M of data. How would you change the size of the data file from 100M to 10M?

#185. The PROD database contains the USER_DATA tablespace. The USER_DATA was created using this CREATE TABLESPACE statement:

 CREATE TABLESPACE user_data 
 DATAFILE '/user01/oradata/user_data.dbf' SIZE 200M 
 EXTENT MANAGEMENT DICTIONARY 
 DEFAULT STORAGE (INITIAL 20M NEXT 20M);

The requirements of the tablespace have changed and you need to alter the tablespace so that the tablespace manages its own extents using a bitmap. What should you do to change the space management method used by the USER_DATA tablespace?

#186. The USER_DATA01 tablespace is offline and contains the PRODUCT table. The USER_DATA02 tablespace is online and contains the ORDERS table. Which four SQL statements will return an error due to the tablespace online/offline status? (Choose four.)

#187. You create the PROD_DATA tablespace using this CREATE TABLESPACE statement:

 CREATE TABLESPACE prod_data 
 DATAFILE '/u01/oradata/prod_data01.dbf' SIZE 50M 
 LOCALLY MANAGED UNIFORM SIZE 2M 
 AUTOMATIC SEGMENT SPACE MANAGEMENT;

Which statement about the PROD_DATA tablespace is true?

#188. Which characteristic relates to a tablespace?

#189. Evaluate this statement:

 CREATE TABLESPACE user_data01 
 DATAFILE '/disk2/us_data01.dbf' SIZE 10M 
 MINIMUM EXTENT 500K 
 DEFAULT STORAGE 
 (INITIAL 100K NEXT 100K MAXEXTENTS 500 PCTINCREASE 0);

Why will this statement fail?

#190. Evaluate this statement:

 CREATE TABLESPACE user_tbs 
 DATAFILE '/user/oracle9i/orahome91/user_data.dbf' SIZE 1M AUTOEXTEND ON 
 MINIMUM EXTENT 4K 
 NOLOGGING 
 DEFAULT STORAGE (INITIAL 10K NEXT 10K PCTINCREASE 50) 
 EXTENT MANAGEMENT DICTIONARY 
 SEGMENT SPACE MANAGEMENT AUTO;

Which statement about this CREATE TABLESPACE statement is true?

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

gen. 0.101

Server date 01:05 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps