网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）
A
direct-path load
B
conventional path load
参考答案
参考解析
解析：
暂无解析
更多 “单选题SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）A direct-path loadB conventional path load” 相关考题
考题
You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
考题
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.
考题
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table 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.
考题
Accelerated analysis approaches emphasize the construction of (71) to more rapidly identify business and user requirements for a new system. As an accelerated analysis technology,(72) reads the program code and automatically generates the equivalent system model, and the code can be obtained from (73) All system analysis approaches require some form. of (74) which includes those techniques to be used to identify or extract system problems and solution requirements from user community.(75) is a classical set of techniques used to collect information about system problems, opportunities, solution requirements, and priorities.A．object modelsB．prototypesC．use casesD．components
考题
SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）A、direct-path loadB、conventional path load
考题
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
考题
How should an administrator change the order in which host name lookup is performed so that it reads the host file before using DNS？（） A、Edit the /etc/inetd.conf file so that it reads ’local， bind’.B、Edit the /etc/resolv.conf file so that it reads ’local， bind’.C、Edit the /etc/netsvc.conf file so that it reads ’local， bind’.D、Edit the /etc/nslookup.conf file so that it reads ’local， bind’.
考题
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.
考题
Why would you run the delete obsolete command？（） A、 To remove missing backup set pieces physically from diskB、 To remove metadata related to backup set pieces in the control file and the recovery catalogC、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsD、 To delete backup set pieces associated with backups that are no longer needed due to retention criteriaE、 To remove old versions of RMAN backups
考题
Which two SQL*Loader instructions are used to assemble logical records？（）A、WHENB、INFILEC、CONTINUEIFD、CONCATENATEE、TRAILING NULLCOLS
考题
What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）A、To verify space requirements in the target database before importing.B、To generate the SQL for the DDL operations that would occur during import.C、To check character set compatibility between the export file and the target database.D、To check for integrity constraint violations that would occur in the target database.
考题
Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use? （）A、 Default B、 SAFE C、 EXTERNAL_ACCESS D、 UNSAFE
考题
多选题For which two tasks would it be best NOT to use the utility SQL*Loader？（）AWhen loading selected rows into each table.BWhen loading data from an export dump file.CWhen loading data from disk， tape， or named pipes.DWhen your data is NOT being inserted from a flat file.EWhen using a record management system to access data files.
考题
单选题You issue the following RMAN command to set a retention policy on a database： RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of issuing this command？（）A
After two days，a backup will be marked obsoleteB
After two days，a backup will be deleted from the mediaC
If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.D
If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
考题
多选题Why would you run the delete obsolete command？（）ATo remove missing backup set pieces physically from diskBTo remove metadata related to backup set pieces in the control file and the recovery catalogCTo mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsDTo delete backup set pieces associated with backups that are no longer needed due to retention criteriaETo remove old versions of RMAN backups
考题
单选题You issue the following RMAN command to set a retention policy on a database： RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of the above command？（）A
After two days， the backup will be marked obsolete.B
After two days， the backup will be deleted from the media.C
If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.D
If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.
考题
单选题Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）A
Log fileB
Discard fileC
Parameter fileD
Bad file
考题
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
考题
多选题Which two SQL*Loader instructions are used to assemble logical records？（）AWHENBINFILECCONTINUEIFDCONCATENATEETRAILING NULLCOLS
考题
多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $ sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
考题
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）A
After two days, a backup will be marked obsoleteB
After two days, a backup will be deleted from the mediaC
If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.D
If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
考题
单选题Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use? （）A
Default B
SAFE C
EXTERNAL_ACCESS D
UNSAFE
考题
单选题Application developers in TestKing.com create an assembly that contains a CLR function.This CLR function reads data from a spreadsheet， performs some calculations， and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use？（）A
DefaultB
SAFEC
EXTERNAL ACCESSD
UNSAFE
考题
多选题Which two statements are true regarding the usage of the SQL*Loader utility（）AYou can load data into multiple tables during the same load session.BYou can load data from multiple files to a table during the same load session.CYou cannot perform selective data loading based on the values available in the records.DYou can use an export file generated by the EXPDP utility as an input data file to load the data.EYou can load data only if the input file is available on the disk and tape but not in a named pipes.
考题
单选题You create a Web application to process XML documents. The Web application receives XML document files from several sources, reads them, and stores them in a Microsoft SQL Server database. The Web application parses all incoming data files to ensure that they conform to an XML schema. You need to find all validation errors in the XML document. What should you do? （）A
Load the XML data by using an instance of the XmlDocument class and specify a location for the application schema.B
Configure the ValidationEventHandler in the XmlReaderSettings of the XmlReader object.C
Read the XML file into a DataSet object and set the EnforceConstraints property to True.D
Read the XML file into a DataSet object. Handle the DataSet.MergeFailed event to parse the data that does not conform to the XML schema.
考题
单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）A
ROWSB
SKIPC
LOADD
BINDSIZE
热门标签
最新试卷
