单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()AROWSBSKIPCLOADDBINDSIZE

单选题
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()
A

ROWS

B

SKIP

C

LOAD

D

BINDSIZE


参考解析

解析: 暂无解析

相关考题:

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.

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?()A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL

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

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()A、’SQL ALTER DATABASE OPEN’;B、SQL ALTER DATABASE ’OPEN’;C、OPEN DATABASE;D、DATABASE OPEN

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.

You issued the following statement in your SQL*Plus session:   SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

Identify four uses of the Oracle Scheduler.()A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?()A、 RESUMABLE_SPACE_TIMEB、 RESUMABLE_SPACEC、 RESUMABLE_TIMED、 RESUMABLE_TIMEOUTE、 TIME_RESUMABLE

Which two SQL*Loader instructions are used to assemble logical records?()A、WHENB、INFILEC、CONTINUEIFD、CONCATENATEE、TRAILING NULLCOLS

Which of the following parameters would you use to record the errors that might be generated during the import operation?()A、LOGB、HELPC、BUFFERD、PARFILEE、INCTYPE

You design a Business Intelligence (BI) solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services (SSRS) solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met: Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform?()A、 Filter data by using expressions.B、 Specify the default values for each parameter.C、 Create an available values list for each parameter.D、 Create report parameters by using query parameters to filter data at the data source.

Which of the following features enables you to modify the addresses of senders and recipients on messages that Exchange 2010 organization?()A、Transport ruleB、JournalingC、Address rewritingD、Sender filtering

You design a SQL Server 2008 Reporting Services (SSRS) solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components: A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report? ()A、 ListB、 TableC、 MatrixD、 Subreport

单选题You design a SQL Server 2008 Reporting Services (SSRS) solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components: A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report? ()A ListB TableC MatrixD Subreport

单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()ALibrary cache BRow cacheCDictionary cache DLarge area EBuffer cache

单选题You are developing a method to decrypt data that was encrypted with the Triple DES Algorithm. The method accepts the following parameters:  The byte array to be decrypted, which is named cipherMessage  The key, which is named key   An initialization vector, which is named iv  You need to decrypt the message by using the TripleDES class and place the result in a string.  Which code segment should you use?()A AB BC CD D

单选题Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file?()ALog fileBDiscard fileCParameter fileDBad 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 issued the following statement in your SQL*Plus session:   SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()A creating a table in your schema and you exceed your allocated space quota on the tablespaceB executing a long query that involves a sort operation and the statement runs out of temporary spaceC loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

多选题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.

单选题Which of the following parameters would you use to record the errors that might be generated during the import operation?()ALOGBHELPCBUFFERDPARFILEEINCTYPE

单选题Which of the following is the new permissions model in Microsoft Exchange Server 2010, which enables you to continuous levels, what administrators and end-users can do?()ARole Based Access ControlBAccess Control ListCDynamic distribution groupDUniversal distribution group

单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?()AOPTIMAL BINITIAL CPCTINCREASE DNEXT

单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()AROWSBSKIPCLOADDBINDSIZE

单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()A’SQL ALTER DATABASE OPEN’;BSQL ALTER DATABASE ’OPEN’;COPEN DATABASE;DDATABASE OPEN