RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
SQL*Loader
«Prev
Next»
Database Administration
Managing Storage
Tablespace Resource Management
Large Database Features
Internet Database Configurations
Security Features
Installation Configuration
Parameter Initialization Changes
Universal Installer Upgrade
Table Space Management
Locally Managed Tablespaces
Transportable Tablespaces
DB Resource Manager
Use Resource Manager
SQL*Loader
SQL Loader Improvements
SQL Loader Features
Relocate/Restructure Table
Create Temporary Table
Report Remove UnuseD Column
JDBC Client
Java Oracle
Intermedia Exchange
Text Retrieval
Oracle Internet Directory
JSP Web Development
Web Enterprise
Create Temporary Tables - Quiz
Table Management Concepts
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of these scenarios requires no control file when using SQL*Loader?
Please select the best answer.
A.
You have created your own application, which interfaces with the SQL*Loader API for loading specialty data for your clients.
B.
Your incoming data includes numbers, text, and dates, which you must load into an object table.
C.
The data you are loading includes individual 2GB files containing audio CDs.
D.
Your data contains names, addresses, and sets of phone numbers to be loaded into a varray data type.
2.
What is the maximum size of a file that can be loaded into a column of the LOB data type?
Please select the best answer.
A.
No limit
B.
2000 characters
C.
2GB
D.
4GB
3.
Which of the following descriptions is NOT a trait of a temporary table?
Please select the best answer.
A.
A temporary table can have an index.
B.
A temporary table can contain data inserted by two different users.
C.
A user's data is removed from a temporary table when the user's transaction or session ends.
D.
A temporary table is dropped after the user completes his session.
Correct answers:
Your Score: 0
Submit
Quiz Explanation