English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (422)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 9i: Database Fundamentals II 

АвторSubject: Q184
written 12 January 2008 13:03   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
Because Oracle 9i supports user-defined record sizes larger than 64 KB (see READ SIZE (read buffer size)), the need to break up logical records into multiple physical records is reduced. However, there may still be situations in which you may want to do so. At some point, when you want to combine those multiple physical records back into one logical record, you can use one of the following clauses, depending on your data:
CONCATENATE
CONTINUE IF
Use CONCATENATE when you want SQL*Loader to always combine the same number of physical records to form one logical record.
Use CONTINUE IF if the number of physical records to be continued varies. The parameter CONTINUE IF is followed by a condition that is evaluated for each physical record, as it is read. For example, two records might be combined if a pound sign (#) were in byte position 80 of the first record. If any other character were there, the second record would not be added to the first. Incorrect Answer:
1: If the WHEN, NULL IF, or DEFAULT IF clause specifies a position, SQL*Loader compares the clause to the original logical record in the data file. No whitespace trimming is done on the logical record in that case.
2: To load data from one or multiple data files in one SQL*Loader run, use an IN FILE statement for each data file.
5: The TRAILING NULL COLS clause tells SQL*Loader to treat any relatively positioned columns that are not present in the record as null columns.
Reference:
OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 449-462
Chapter 19: Loading Data into a database

Current tread:
back to list

Q184 - Go to question 13:03 12.01.08

back to list
Up ^ gen. 0.071 Server date 07:37 08-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments