单项选择题

A.Upgrade the hardware memory to accommodate the data.B……

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

A.Upgrade the hardware/memory to accommodate the data.
B.Load the data into your database by using the PARALLEL clause.
C.Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
D.Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

<上一题目录下一题>

热门试题

单项选择题Whichnamingmethodusesthetnsnames.orafiletostoretheconnectdescriptorusedbytheclientwhileconnectingtothedatabaseinstancefromaremotemachine？（）

A.host naming method
B.local naming method
C.external naming method
D.directory naming method

单项选择题While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）

A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture

多项选择题Whichtwostatementsaretrueaboutsimpleviews？（）

A.Views can be created as read only.
B.Views are data segments like tables.
C.Views can be created on the basis of more than one table.
D.Data manipulation language （DML） operations cannot be performed on views.

单项选择题YouwanttheuserAPP_DBAtoadministertheOracledatabasefromaremotemachine.APP_DBAisgrantedtheSYSDBAprivilegetoperformadministrativetasksonthedatabase.WhichfileisusedbytheOracledatabaseservertoauthenticateAPP_DBA？（）

A.control file
B.password file
C.listener controller file
D.control file and password file

多项选择题WhichtwostatementsaretrueabouttherolesintheOracledatabase？（）

A.A role can be granted to itself.
B.Roles are owned by the SYS user.
C.Roles can be granted to other roles.
D.A role cannot be assigned external authentication.
E.A role can contain both system and object privileges.