网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
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.


参考答案

更多 “ 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. ” 相关考题
考题 在Oracle中,以下工具可以逻辑备份数据库对象或整个数据库()。 A.SQL*PlusB.导出实用程序C.导入实用程序D.SQL*Loader

考题 以下哪些函数能读取文件的全部内容?() A.file_get_contents()B.fread()C.readfile()D.file()

考题 GiventhatfileisareferencetoaFileobjectthatrepresentsadirectory,whichcodefragmentswillsucceedinobtainingalistoftheentriesinthedirectory?() A.Vectorfilelist=((Directory)file).getList();B.String[]filelist=file.directory();C.Enumerationfilelist=file.contents();D.String[]filelist=file.list();E.Vectorfilelist=(newDirectory(file)).files();

考题 WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader() A.Redoisnotgeneratedwhileperformingconventionalpathloads.B.OnlyPRIMARYKEY,UNIQUEKEY,andNOTNULLconstraintsarechecked.C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperformed.D.Insteadofperformingtransactions,SQL*Loaderdirectlywritesdatablockstothedatafiles.E.INSERTtriggersaredisabledbeforetheconventionalpathloadandreenabledattheendoftheload

考题 YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective,youspecifythefollowingparametersintheparameterfileofthedatabase:INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT=$ORACLE_SID_%s_%t.%tDB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD?()A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST

考题 使用VC6打开考生文件夹下的工程test14_3,此工程包含一个test14_3.cpp,其中定义了类File,但类的定义并不完整。请按要求完成下列操作,将程序补充完整。(1)完成构造函数的定义,使数据成员filename,content指向为空。请在注释“//**1**”之后添加适当的语句;(2)完成函数set_contents的定义,该函数为content申请新的空间来存储new_content的内容,成功返回true,失败返回false。请在注释“//**2**”之后添加适当的语句;(3)完成成员函数copy(File source,File target)的定义,该函数实现将source的内容拷贝至target的功能,注意必须使用已经定义的成员函数来实现。请在注释“//**3**”之后添加适当的语句:(4)完成析构函数的定义,要求释放content指向的空间。请在注释“//**4**”之后添加适当的语句。输出结果如下:file2:file1 contentsfile2:file2 contents注意:除在指定的位置添加语句外,请不要改动程序中的其他语句。源程序文件testl4—3.cpp清单如下:include<iostream.h>include<string.h>class File{private:char file_name[64];char*contents;public:File(char*filename){// ** 1 **};File::~File(){// ** 4 **}void printfile(){cout<<file_name<<":"<<contents<<endl;)friend bool copy(File source,File target);bool set_contents(char * new_contents);};bool File::set_contents(char*new_contents){// ** 2 **if(contents==NULL)return false;strcpy(contents,new_contents);return true;}bool copy(File source,File target){// ** 3 **}void main{){File f1("filel"),f2("file2");f1.set_contents("filel contents");copy(f1,f2);f2.printfile();f2.set_contents("file2 contents,);f2.printfile();}

考题 IMPORT和SQL*LOADER 这2个工具的不同点

考题 Whileinstallinganapplication,theadministratorisinstructedtoperformtwofinaltaskspriortostartingtheapplication:1.Settheownershipofafilenamed’control_file’tobeownedbytheuser’database’andthegroup’appsrvr’.2.Changethepermissionsof’control_file’to0766.Afterthesetwotaskshavebeencompleted,whatwillthefilepermissionslooklikewhen’ls-lcontrol_file’isexecuted?()A.-rwxrw-rw-1databaseappsrvr4913Mar1708:24control_fileB.-rw-r--r--1appsrvrdatabase4913Mar1708:24control_fileC.-rw-r--r--1databaseappsrvr4913Mar1708:24control_fileD.-rwxrw-rw-1appsrvrdatabase4913Mar1708:24control_file

考题 WhichtwostatementsregardingthecontrolfileandRecoverManageraretrue?() A.Thecontrolfilecangrowinsize.B.ThecontrolfilecanstoreRMANscripts.C.CONTROL_FILE_RECORD_KEEP_TIMEdeterminesretentiontimeforRMANrecords.D.TheRMANcatalogcanexistsolelyinthecontrolfileofthetargetdatabase.

考题 使用数据库初始化参数文件中的()参数可以指定控制文件名。 A.CONTROL_FILESB.CONTROL_FILES_NAMEC.CONTROL_NAMED.CONTROL_FILE