网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which command will result in a trace file being created with the create controlfile command contained in it?()
A
alter database backup controlfile
B
alter database backup controlfile to trace
C
alter database controlfile backup
D
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E
alter database begin controlfile backup
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which command will result in a trace file being created with the create controlfile command contained in it?()A alter database backup controlfileB alter database backup controlfile to traceC alter database controlfile backupD alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E alter database begin controlfile backup” 相关考题
考题
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:SQL exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);The possible outcome and actions to aggregate the trace files are as follows:1. The command fails because a module name is not specified.2. A trace file is created for each session that is running the SRV1 service.3. An aggregated trace file is created for all the sessions that are running the SRV1 service.4. The trace files may be aggregated by using the trcess utility.5. The trace files be aggregated by using the tkprof utility.Identify the correct outcome and the step to aggregate by using tkprof utility?()A. 1B. 2 and 4C. 2 and 5D. 3 and 4E. 3 and 5
考题
Which of the following dbx commands should be used to obtain a stack trace from a coredump file?()A、trace B、where C、status D、which
考题
A file named "core" exists in the current directory. Which of the following commands should be used to determine what created the "core" file?()A、 dump -t core B、 strings core C、 trace -a core D、 crash core /unix_up
考题
Which of the following will occur if an operator types the command vi file.out?()A、If the file exists it will be opened for editing. If the file does not exist an error message will be displayed.B、If the file exists it will be opened for editing. If the file does not exist a new file with the name file.out will be created and opened for editing.C、If the file exists an error message will be displayed. If the file does not exist a new file with the name file.out will be created and opened for editing.D、If the file exists the operator will be asked whether to open the file or overwrite the file. If the file does not exist a new file with the name file.out will be created and opened for editing.
考题
Which two statements are true regarding trace options on Junos devices?()A、You can see the contents of the log file by entering the show log filename command.B、Trace options will send information to your screen automatically.C、Trace options are limited to one protocol at a time.D、The file name and a set of flags may be specified when enabling traceoptions.
考题
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
考题
You issued the following statement: SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?() A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.
考题
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file?()A、 Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B、 Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C、 Issue the SERVICES command at the LSNRCTL prompt.D、 Issue the STATUS command at the LSNRCTL prompt.
考题
You executed the following command to back up your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?()A、USER_DUMP_DESTB、CORE_DUMP_DESTC、TRACE_DUMP_DESTD、BACKUP_DUMP_DESTE、BACKGROUND_DUMP_DEST
考题
Which command will result in a trace file being created with the create controlfile command contained in it?() A、 alter database backup controlfileB、 alter database backup controlfile to traceC、 alter database controlfile backupD、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E、 alter database begin controlfile backup
考题
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?() A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
考题
Which two outcomes result when a domain is created in development mode?()A、WebLogic server starts automatically upon the restarting of the machineB、each new cluster will automatically be created with two managed serversC、boot.properties file automatically stored D、creation of an auto deploy folder used for the application to deploy automaticallyE、Node Manager will be automatically configured
考题
单选题A file named "core" exists in the current directory. Which of the following commands should be used to determine what created the "core" file?()A
dump -t core B
strings core C
trace -a core D
crash core /unix_up
考题
单选题You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE); Which statement is true?()A
When a file is created in DGROUP1 with the template, it would have threeway mirroring. B
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.C
When a file is created in DGROUP1 with the template, it would have twoway mirroring and file striping.D
When a file is created in DGROUP1 with the template, it would have threeway mirroring and file striping.E
When a file is created in DGROUP1 with the template, it would have twoway mirroring but no file striping.
考题
单选题You backed up the control file to trace. Which statement is true about the trace file generated?()A
The trace file is in binary format.B
The trace file has a SQL script to re-create the control file.C
The trace file is a backup set created during the backup of the control file. D
The trace file contains the instructions to manually re-create the control file.E
The trace file is an image copy of the control file created during the backup of the control file.
考题
单选题You executed the following command to back up your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?()A
USER_DUMP_DESTB
CORE_DUMP_DESTC
TRACE_DUMP_DESTD
BACKUP_DUMP_DESTE
BACKGROUND_DUMP_DEST
考题
多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’; Which two statements are true regarding the backup created using this command?()AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.
考题
单选题You issued the following statement: SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()A
The control file will be multiplexed.B
The control file will be recreated.C
The script containing the CREATE CONTROLFILE statement will be created.D
The binary backup of the control file will be created.
考题
单选题Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?()A
1B
2 and 4C
2 and 5D
3 and 4E
3 and 5
考题
单选题Which command will result in a trace file being created with the create controlfile command contained in it?()A
alter database backup controlfileB
alter database backup controlfile to traceC
alter database controlfile backupD
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E
alter database begin controlfile backup
考题
单选题Which of the following will occur if an operator types the command vi file.out?()A
If the file exists it will be opened for editing. If the file does not exist an error message will be displayed.B
If the file exists it will be opened for editing. If the file does not exist a new file with the name file.out will be created and opened for editing.C
If the file exists an error message will be displayed. If the file does not exist a new file with the name file.out will be created and opened for editing.D
If the file exists the operator will be asked whether to open the file or overwrite the file. If the file does not exist a new file with the name file.out will be created and opened for editing.
考题
单选题Which command will result in a trace file being created with the create controlfile command contained in it?()A
alter database backup controlfileB
alter database backup controlfile to traceC
alter database controlfile backupD
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E
alter database begin controlfile backup
考题
单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
考题
单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()A
None of the data definition language (DDL) statements are logged in the trace file.B
Only DDL commands that resulted in errors are logged in the alert log file.C
A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D
Only DDL commands that resulted in the creation of new database files are logged.
考题
单选题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
考题
单选题The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file?()A
Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B
Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C
Issue the SERVICES command at the LSNRCTL prompt.D
Issue the STATUS command at the LSNRCTL prompt.
考题
多选题Which two outcomes result when a domain is created in development mode?()AWebLogic server starts automatically upon the restarting of the machineBeach new cluster will automatically be created with two managed serversCboot.properties file automatically storedDcreation of an auto deploy folder used for the application to deploy automaticallyENode Manager will be automatically configured
热门标签
最新试卷