Oracle认证考试
Which two SQL*Loader instructions are used to assemble logical records？（）A、WHENB、INFILEC、CONTINUEIFD、CONCATENATEE、TRAILING NULLCOLS
题目
Which two SQL*Loader instructions are used to assemble logical records？（）
- A、WHEN
- B、INFILE
- C、CONTINUEIF
- D、CONCATENATE
- E、TRAILING NULLCOLS
相似问题和答案
第1题：
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$> sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command?（）
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B. It fails because no SQL *Loader data file location is specified.
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D. It fails because no SQL *Loader control file location is specified.
第2题：
下面关于SQL*LOADER中输入文件，（）说法是错误的。
- A、对于SQL*Loader，除控制文件外就是输入数据
- B、SQL*Loader只能从指定的文件中读出数据
- C、如果数据是在控制文件中指定，就要在控制文件中写成INFILE*格式
- D、当数据固定的格式（长度一样）时且是在文件中得到时，要用INFILE”fixn”
正确答案:B
第3题：
A. /SQL*Plus commands cannot be abbreviated.
B. /SQL*Plus commands are accesses from a browser.
C. /SQL*Plus commands are used to manipulate data in tables.
D. /SQL*Plus commands manipulate table definitions in the database.
E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
第4题：
Which statement is true about loading data using the conventional path of SQL*Loader（）
- A、Redo is not generated while performing conventional path loads.
- B、Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
- C、No exclusive locks are acquired when the conventional path loads are performed.
- D、Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
- E、INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
正确答案:C
第5题：
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）
- A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
- B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.
- C、The SQL* Loader operation fails because no record terminators are specified.
- D、Field names should be the first line in the both the SQL* Loader data files.
- E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
正确答案:A,B,E
第6题：
IMPORT和SQL*LOADER 这2个工具的不同点
第7题：
SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）
- A、direct-path load
- B、conventional path load
正确答案:A
第8题：
A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
C. The SQL* Loader operation fails because no record terminators are specified.
D. Field names should be the first line in the both the SQL* Loader data files.
E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
第9题：
Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)
- A、It contains only SQL profiles generated by SQL Tuning Advisor.
- B、It stores plans generated by the optimizer using a stored outline.
- C、It is part of the data dictionary and stored in the SYSAUX tablespace.
- D、It is part of the data dictionary and stored in the SYSTEM tablespace.
- E、It contains the statement log, the plan history, plan baselines, and SQL profiles.
正确答案:C,E
第10题：
Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
- A、The constraint remains valid.
- B、The index on the constraint is dropped.
- C、It allows the loading of data into the table using SQL*Loader.
- D、New data conforms to the constraint， but existing data is not checked
- E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
正确答案:A,B,C