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

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

#311. A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?

#312. The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?

#313. You just issued the following statement:

 ALTER TABLE SALES DROP COLUMN PROFIT

Which of the following choices identifies when the column will actually be removed from Oracle?

#314. You need to make one of the data file of the PROD_TBS tablespace auto extensible. You issue this SQL command:

 ALTER TABLESPACE prod_tbs DATAFILE 
 '/uo1/private/oradata/prod.dbf' 
 AUTOEXTEND ON;

Which error occurs?

#315. You issue this command:
STARTUP MOUNT Which three events occur when the instance is started and the database is mounted? (Choose three)

#316. You are creating a data base manually and you need to limit the number of initial online redo log groups and members. Which two keywords should you use within the create database command to define the maximum number of online redo log files? (Choose two).

#317. Which four do you find in the alert log file? (Choose four)

#318. You need to determine the amount of space currently used in each tablespace. You can retrieve this information in a single SQL statement using only one DBA view in the FROM clause providing you use either the _______ or _______ DBA view.

#319. Which statement is true regarding the maintenance of tables?

#320. Which three statements regarding an extent are true? (Choose three.)

[1] ... [31] [32] [33] [34] [35] [36] [37]

gen. 0.092

Server date 09:05 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps