1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 13

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-007: Introduction to Oracle9i: SQL

#121. Which four are correct guidelines for naming database tables? (Choose four)

#122. Examine the structure of the EMPLOYEES table:

You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?

#123. Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)

#124. What does the TRUNCATE statement do?

#125. Which statement about a table is true?

#126. The ACCOUNT table contains these columns:

 ACCOUNT_ID          NUMBER(12) 
 FINANCE_CHARGE      NUMBER(7,2) 
 PREV_BALANCE        NUMBER(7,2) 
 PAYMENTS            NUMBER(7,2) 
 NEW_PURCHASES       NUMBER(7,2)

You created the ACCOUNT_ID_SEQ sequence to generate sequential values for the ACCOUNT_ID column.
You issue this statement:

 ALTER TABLE account 
 MODIFY (finance_charge NUMBER(8,2));

Which statement about the ACCOUNT_ID_SEQ sequence is true?

#127. Examine the structure of the EMPLOYEE table.

Which statement should you use to increase the EMP_LNAME column length to 25 if the column currently contains 3000 records?

#128. Examine the structure of the PO_DETAIL table.

Which statement will permanently remove all the data in, the indexes on, and the structure of the PO_DETAIL table?

#129. The MGR_ID column currently contains employee identification numbers, and you need to allow users to include text characters in the identification values. Which statement should you use to implement this?

#130. Which CREATE TABLE statements will fail? (Choose all that apply.)

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

gen. 0.057

Server date 05:04 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps