单选题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

题目
单选题
Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）
A

Log file

B

Discard file

C

Parameter file

D

Bad file

相似考题

1.Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece

2.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.

3.In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）A、the alert log fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files

4.You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)A. The KEEP option overrides the configured retention policyB. The KEEP option is an attribute of an individual backup pieceC. The backup contains only data files and archived redo log filesD. The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

更多“单选题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”相关问题

  • 第1题：

    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

    正确答案:C

  • 第2题：

    You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

    • A、Image of the control file
    • B、Location of the control file
    • C、Contents of the control file in text format
    • D、SQL command to re-create the database
    • E、SQL command to re-create the control file
    • F、Contents of the control file in binary format

    正确答案:E

  • 第3题：

    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.

    正确答案:A,B,E

  • 第4题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

    • A、the trace file
    • B、the alert log file
    • C、an RMAN session log file
    • D、the server parameter file
    • E、the formatted name of a control file autobackup

    正确答案:C,E

  • 第5题：

    Which two file types must be included in a closed database backup taken with operating system commands？（）

    • A、data files
    • B、control file
    • C、password file
    • D、online redo log files
    • E、initialization parameter file

    正确答案:A,B

  • 第6题：

    Which six files are maintained in the Flash Recovery Area？（）

    • A、 control file
    • B、 RMAN files
    • C、 password file
    • D、 parameter file
    • E、 flashback logs
    • F、 data file copies
    • G、 core dump files
    • H、 archived log files
    • I、 RMAN recovery scripts
    • J、 control file autobackpus

    正确答案:A,B,E,F,H,J

  • 第7题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）

    • A、 data file
    • B、 password file
    • C、 archivelog file
    • D、 temporary file
    • E、 online redo log file
    • F、 the current control file
    • G、 the tnsnames.ora file
    • H、 current server parameter file

    正确答案:A,C,F,H

  • 第8题：

    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）

    • A、data files
    • B、control files
    • C、parameter file
    • D、online redo log files
    • E、server parameter file

    正确答案:B,E

  • 第9题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）

    • A、data file
    • B、password file
    • C、archivelog file
    • D、temporary file
    • E、online redo log file
    • F、the current control file
    • G、the tnsnames.ora file
    • H、current server parameter file

    正确答案:A,C,F,H

  • 第10题：

    Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）

    • A、Log file
    • B、Discard file
    • C、Parameter file
    • D、Bad file

    正确答案:B

  • 第11题：

    单选题
    Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）
    A

    Log file

    B

    Discard file

    C

    Parameter file

    D

    Bad file


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Where do you find information about a missing redo log file？（）

    • A、trace file
    • B、audit trail
    • C、control file
    • D、alert log file
    • E、event viewer

    正确答案:D

  • 第14题：

    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

    • A、 control file
    • B、 all datafiles
    • C、 password file
    • D、 online redo log file
    • E、 archive redo log file
    • F、 server parameter file
    • G、 only the SYSTEM datafile

    正确答案:A,B,F

  • 第15题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）

    • A、 the alert log file
    • B、 the server parameter file
    • C、 the formatted name of a control file autobackup
    • D、 an RMAN session log file
    • E、 the trace file

    正确答案:C,D

  • 第16题：

    You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）

    • A、 The backup contains data files， the server parameter file，and the control file even if the control file  autobackup is disabled.
    • B、 The KEEP option overrides the configured retention policy.
    • C、 The backup contains only data files and archived redo log files.
    • D、 The KEEP option is an attribute of an individual backup piece.

    正确答案:A,B

  • 第17题：

    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)

    • A、The KEEP option overrides the configured retention policy
    • B、The KEEP option is an attribute of an individual backup piece
    • C、The backup contains only data files and archived redo log files
    • D、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

    正确答案:A,D

  • 第18题：

    Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)

    • A、Alert log file
    • B、Archived redo log files
    • C、Control file autobackups
    • D、Server Parameter file (SPFILE)
    • E、Recovery Manager (RMAN) backup piece

    正确答案:B,C,E

  • 第19题：

    Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2？（）

    • A、 Alert log file
    • B、 Archived redo log files
    • C、 Control file autobackups
    • D、 Server Parameter file （SPFILE）
    • E、 Recovery Manager （RMAN） backup piece

    正确答案:B,C,E

  • 第20题：

    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

    • A、Data files
    • B、Control files
    • C、Parameter file
    • D、Online redo log files
    • E、Server parameter file

    正确答案:B,E

  • 第21题：

    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）

    • A、any control file
    • B、any archive log file
    • C、one of the redo log members
    • D、loss of the initialization parameter file
    • E、any data file belonging to the default permanent tablespac

    正确答案:A

  • 第22题：

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

    • A、control file
    • B、password file
    • C、listener controller file
    • D、control file and password file

    正确答案:B

  • 第23题：

    多选题
    You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）
    A

    The backup contains data files， the server parameter file，and the control file even if the control file  autobackup is disabled.

    B

    The KEEP option overrides the configured retention policy.

    C

    The backup contains only data files and archived redo log files.

    D

    The KEEP option is an attribute of an individual backup piece.


    正确答案： A,B
    解析： 暂无解析

  • 第24题：

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


    正确答案： C,B
    解析： 暂无解析

相关内容