单选题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
单选题
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
参考解析
解析：
暂无解析
相关考题：
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
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
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.
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
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
Where do you find information about a missing redo log file？（）A、trace fileB、audit trailC、control fileD、alert log fileE、event viewer
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 fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
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 fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
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 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 fileB、 the server parameter fileC、 the formatted name of a control file autobackupD、 an RMAN session log fileE、 the trace file
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 fileB、the alert log fileC、an RMAN session log fileD、the server parameter fileE、the formatted name of a control file autobackup
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.
Which two file types must be included in a closed database backup taken with operating system commands？（）A、data filesB、control fileC、password fileD、online redo log filesE、initialization parameter file
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 six files are maintained in the Flash Recovery Area？（）A、 control fileB、 RMAN filesC、 password fileD、 parameter fileE、 flashback logsF、 data file copiesG、 core dump filesH、 archived log filesI、 RMAN recovery scriptsJ、 control file autobackpus
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 fileB、Archived redo log filesC、Control file autobackupsD、Server Parameter file (SPFILE)E、Recovery Manager (RMAN) backup piece
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）A、 data fileB、 password fileC、 archivelog fileD、 temporary fileE、 online redo log fileF、 the current control fileG、 the tnsnames.ora fileH、 current server parameter file
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
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）A、data filesB、control filesC、parameter fileD、online redo log filesE、server parameter file
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）A、Data filesB、Control filesC、Parameter fileD、Online redo log filesE、Server parameter file
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file
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 fileB、any archive log fileC、one of the redo log membersD、loss of the initialization parameter fileE、any data file belonging to the default permanent tablespac
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 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 fileB、password fileC、listener controller fileD、control file and password file
单选题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 performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）AThe backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.BThe KEEP option overrides the configured retention policy.CThe backup contains only data files and archived redo log files.DThe KEEP option is an attribute of an individual backup piece.
单选题Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）AROWSBSKIPCLOADDBINDSIZE
多选题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.