[Solved] Which statement is true regarding external tables?

McqMate

Q.	Which statement is true regarding external tables?
A.	the default reject limit for external tables is unlimited
B.	the data and metadata for an external table are stored outside the database
C.	oracle_loader and oracle_datapump have exactly the same functionality when used with an external table
D.	the create table as select statement can be used to unload data into regular table in the database from an external table
Answer» D. the create table as select statement can be used to unload data into regular table in the database from an external table

2.1k

0

Do you find this helpful?

6

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables. Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers? SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;
Which statement is true regarding synonyms?
Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
In which model of database data is stored in tables:
In which ways two tables may be related:
Which command creates database objects like tables, views and indexes:
Which of the following is one of the basic approaches for joining tables?
Which data model organizes the data in the form of tables and relations?
Which of the following clause specifies the table or tables from where the data has to be retrieved?