网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

如果一个数据库举例(instance)失败,但是没有停止运行,你必须使用哪个命令使实例恢复能被执行?()

  • A、startup nomount
  • B、shutdown immediate;start force
  • C、startup mount
  • D、shutdown abort;startup

参考答案

更多 “如果一个数据库举例(instance)失败,但是没有停止运行,你必须使用哪个命令使实例恢复能被执行?()A、startup nomountB、shutdown immediate;start forceC、startup mountD、shutdown abort;startup” 相关考题
考题 You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.  The current consumption of your CPU is approximately 40 percent.  Which type of backup should you perform?()  A、 standard backup setB、 image copyC、 compressed backupD、 user-managed backup

考题 Which two statements regarding the Flashback Table feature are correct?()A、 Flashback Table can be performed on system tables.B、 Flashback Table operation does not shrink the segments.C、 Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D、 Flashback Table operation acquires exclusive data manipulation language (DML) locks.

考题 Which statement is true about XpauseTarget in Oracle JRockit JVM ? ()A、 This option is supported by all type of Garbage collection modes.B、 This option is only supported by Generational Garbage Collection mode.C、 This option is only supported by Mark and Sweep Garbage Collection mode.D、 This option is only supported by Dynamic Garbage Collection mode.

考题 Which two statements are true about the primary key constraint in a table? ()A、It is not possible to disable the primary key constraint.B、It is possible to have more than one primary key constraint in a single table.C、The primary key constraint can be referred by only one foreign key constraint.D、The primary key constraint can be imposed by combining more than one column.E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

考题 Which statement is FALSE regarding WebLogic Server 12c?()A、supports Java EE 6.0B、supports WebLogic Web Services 8.1 Application EnvironmentC、includes a new Maven plug-inD、supports use of annotations in resource adapter class files

考题 You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

考题 You want to enforce a company’s business policy on several objects by using a singlepolicy function.  Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective?()A、DBMS_RLS.STATICB、DBMS_RLS.DYNAMICC、DBMS_RLS.SHARED_STATICD、DBMS_RLS.CONTEXT_SENSITIVEE、DBMS_RLS.SHARED_CONTEXT_SENSITIVE

考题 Which two statements are true regarding the usage of the SQL*Loader utility()A、You can load data into multiple tables during the same load session.B、You can load data from multiple files to a table during the same load session.C、You cannot perform selective data loading based on the values available in the records.D、You can use an export file generated by the EXPDP utility as an input data file to load the data.E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

考题 You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DB  A. While observing the server settings, you find that the  following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?()A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client

考题 You are performing a backup of your database across the network. While taking the backup, you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup?()A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET;B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY;C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET;D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY;

考题 You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A、It will display a list of files that need incremental backupB、It will display a list of files that need backup after five daysC、It will display a list of files that were backed up in the last five daysD、It will display a list of files that have not been backed up in the last five daysE、It will apply the current retention policy to determine the files that need to be backed up