单选题Which backup option defines a user-defined name for a backup? （）A FORMATB NAMEC TAGD FORMAT U%

题目
单选题
Which backup option defines a user-defined name for a backup? （）
A

FORMAT

B

NAME

C

TAG

D

FORMAT U%

相似考题

1.多选题Where can subqueries be used?（）Afield names in the SELECT statementBthe FROM clause in the SELECT statementCthe HAVING clause in the SELECT statementDthe GROUP BY clause in the SELECT statementEthe WHERE clause in only the SELECT statementFthe WHERE clause in SELECT as well as all DML statements

2.多选题Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

3.单选题Which statement is true regarding the COALESCE function?（）A It can have a maximum of five expressions in a list B It returns the highest NOT NULL value in the list for all rows C It requires that all expressions in the list must be of the same data type D It requires that at least one of the expressions in the list must have a NOT NULL value

4.单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）A alter tablespace DAVE_TBS backup modeB alter tablespace DAVE_TBS start backup C alter tablespace DAVE_TBS begin backup D alter tablespace DAVE_TBS backup begin E alter tablespace DAVE_TBS backup

更多“Which backup option defines a user-defined name for a backup”相关问题

  • 第1题：

    单选题
    NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracle‟s order of precedence: （） a. Default setting b. Client environment variable c. Explicit ALTER SESSION statement d. Inside SQL function e. Server initialization parameter
    A

    b, d, e, a, c

    B

    e, a, b, c, d

    C

    d, c, b, e, a

    D

    a, b, d, c, e

    E

    d, c, b, a, e


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

  • 第2题：

    多选题
    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）
    A

    Backup compression should be enabled

    B

    Parallelism for the channel should be set to 2

    C

    All the files must be backed up as backup sets

    D

    The backup may be stored either on disk or on media with media manager


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

  • 第3题：

    多选题
    You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）
    A

    issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

    B

    issuing the ALTER SESSION ENABLE RESUMABLE; statement

    C

    modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

    D

    issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement


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

  • 第4题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


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

  • 第5题：

    单选题
    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
    A

    Open the database in NORMAL mode

    B

    Open the database in read-only mode

    C

    Open the database in RESTRICTED mode

    D

    Open the database with the RESETLOGS option


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

  • 第6题：

    单选题
    You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）
    A

    The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.

    B

    The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.

    C

    The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.

    D

    Only the BZIP2 compression algorithm can be used to make compressed backups to disk.


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

  • 第7题：

    多选题
    Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?（）
    A

    It can be used to allow the access privilege settings for users but not roles.

    B

    It can be used to allow the access privilege settings for users as well as roles.

    C

    It can be used to control the time interval for which the access privilege is available to a user.

    D

    It can be used to selectively restrict the access for each user in a database to different host computers.

    E

    It can be used to selectively restrict a user's access to different applications in a specific host computer.


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

  • 第8题：

    单选题
    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）
    A

    PLSQL_BLOCK

    B

    JAVA_STORED_PROCEDURE

    C

    STORED_PROCEDURE

    D

    EXECUTABLE

    E

    None of the above are invalid settings.


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

  • 第9题：

    多选题
    Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）
    A

    The block change tracking data will be used only from the next incremental 0 backup.

    B

    The incremental backup will use change tracking data for accomplishing the backup.

    C

    The incremental backup will not use change tracking data for accomplishing the backup.

    D

    The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.


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

  • 第10题：

    单选题
    Which statement is true regarding synonyms?（）
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


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

  • 第11题：

    单选题
    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
    A

    Perform Export before TSPITR and Import after TSPITR

    B

    Move objects to another schema that has the same tablespace assigned

    C

    Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

    D

    Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)


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

  • 第12题：

    单选题
    When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）
    A

    SET_JOB_ARGUMENT_VALUE

    B

    SET_JOB_VALUE_ANYDATA

    C

    SET_JOB_ANYDATA_VALUE

    D

    SET_SPECIAL_JOB_VALUE

    E

    SET_JOB_ANYTYPE_VALUE


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

  • 第13题：

    单选题
    You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
    A

    ASM_POWER_LIMIT

    B

    ASM_DISKSTRING

    C

    ASM_DISKGROUPS

    D

    INSTANCE_TYPE


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

  • 第14题：

    单选题
    Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）
    A

    It cancels all pending disk drops within the disk group.

    B

    It restores disks that are being dropped as the result of a DROP DISKGROUP operation

    C

    It mounts disks in the disk group for which the drop-disk operation has already been co pleted

    D

    It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed

    E

    It adds previously dropped disks back into the disk group


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

  • 第15题：

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


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

  • 第16题：

    多选题
    In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）
    A

    partitioning recommendations

    B

    statistics collection recommendations

    C

    index creation recommendations

    D

    materialized view recommendations

    E

    materialized view log recommendations


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

  • 第17题：

    多选题
    Which two client requests are captured during database replay Capture?（）
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language (DDL) and data manipulation language (DML) operations


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

  • 第18题：

    单选题
    Which of the following tasks is not performed by the job coordinator?（）
    A

    Update job log when a job completes

    B

    Spawn and remove job slaves

    C

    Write/read job info to/from memory cache

    D

    Query job table

    E

    Pass job information to job slaves


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

  • 第19题：

    单选题
    While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
    A

    It updates the existing SQL profiles with current statistics

    B

    It makes the statistics information available to GATHER_STATS_JOB

    C

    It initiates the statistics collection process by running GATHER_STATS_JOB

    D

    It logs a warning message in the alert log so that the DBA can perform statistics collection manually


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

  • 第20题：

    单选题
    After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）
    A

    Opening the database in RESTRICTED mode

    B

    Opening the database with the RESETLOGS option

    C

    Setting a new DBID for the newly restored database

    D

    Restoring the server parameter file (SPFILE) to the new host


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

  • 第21题：

    单选题
    What is the implication of this command?（）
    A

    The command produces an error because the retention time cannot be reduced. 

    B

    All historical data is retained but the subsequent flashback data archives are maintained for only three years. 

    C

    All historical data is purged and the new flashback data archives are maintained for three years. 

    D

    All historical data older than three years is purged from the flashback archive FLA1. 


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

  • 第22题：

    单选题
    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）
    A

    The collection level for the AWR should be set to BASIC

    B

    The moving window size must be less than Undo Retention

    C

    The moving window size should be greater than the Automatic Workload Repository (AWR) retention period

    D

    The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period


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

  • 第23题：

    多选题
    Which three statements correctly describe the features of the I/O calibration process?（）
    A

    Only one I/O calibration process can run at a time.

    B

    It automates the resource allocation for the Automated Maintenance Tasks.

    C

    It improves the performance of the performance-critical sessions while running.

    D

    It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

    E

    The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.


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

  • 第24题：

    单选题
    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）
    A

    PLSQL_BLOCK

    B

    JAVA_STORED_PROCEDURE

    C

    STORED_PROCEDURE

    D

    EXECUTABLE

    E

    None of the above are invalid settings.


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

相关内容