【B9】A．to singB．singingC．sang

A. Change in the Oracle Database version

B. Change in your network infrastructure

C. Change in the hardware configuration of the database server

D. Migration of database storage from non-ASM to ASM storage

E. Database and operating system upgrade

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.

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.

— Which of these two hotels do you like？— Neither.()

Which of your two hnds do you use more Very few of us cn use both hnds eqully well. MWhich of your two hnds do you use more Very few of us cn use both hnds eqully well. Most of usre right-hnded. Onlybout five people out of hundredre left-hnded. New-born bbies cn tke hold of things with either of their hnds, but. inbout two yers they usully use their right hnds. Scientists hve found tht monkeys like to use one of their hnds more thn the other, but it cn be either hnd. Thereres mny right-hnded monkeyss therere left-hnded ones. Next time when you visit zoo, you’ll see tht some of them will use their right hndsnd others will use their left hnds. But most of the people use their right hnds betternd this mkes life difficult for those left-hnded people. We live in right-hnded world. Most people ______.re left-hnded B．re right-hnded C．cn use both hnds eqully well D．never use left hnds

A．are left-handed

B．are right-handed

C．can use both hands equally well

D．never use left hands

You？work？in？a？company？which？is？named？Wiikigo？Corp.？The？company？uses？SQL？Server？2008.？You？are？the？administrator？of？the？company？database.？Now？you？are？in？charge？of？a？SQL？Server？2008？instance.？There？is？a？database？named？DB1？in？the？instance.？In？the？database,？a？small？percentage？of？data？is？modified？everyday.？Ever？day？in？the？morning,？you？have？to？create？a？read-only？copy？of？the？database？for？reporting？purposes？and？make？sure？that？you？use？as？little？disk？space？as？possible.

In？the？options？below,？which？strategy？should？you？use？（）？？

A. You？should？use？database？snapshots？

B. You？should？use？database？backup？and？restore？

C. You？should？use？database？backup？and？restore？along？with？compression？

D. You？should？use？schema-bound？views？in？a？read-only？database.？The？database？resides？on？the？same instance.

to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader();You need to execute a method named Do Work() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use？ （）

A.while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

B.while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

C.while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

D.while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

A. Flashback queries

B. Shared server requests

C. Login and logoff activities of sessions

D. Direct path load of data from external files by using utilities such as SQL *loader

E. Data definition language (DDL) and data manipulation language (DML) operations