单选题What is the default value for the ENABLED attribute of a job or program when it is created？（）ATRUEBFALSECThere is no default. It must be defined at creation time.DPENDINGENULL

题目
单选题
What is the default value for the ENABLED attribute of a job or program when it is created？（）
A

 TRUE

B

 FALSE

C

 There is no default. It must be defined at creation time.

D

 PENDING

E

 NULL

相似考题

1.单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）AIssue the ALTER DISKGROUP ... ADD DISK command.BIssue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.CIssue the ALTER DISKGROUDRetrieve the disk from the Recycle Bin after the operation completes.

2.单选题You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）AThe tablespace must be locally managed.BThe tablespace must have only one temp file.CThe tablespace must be made nondefault and offline.DThe tablespace can remain as the default but must have no active sort operations.

3.多选题Which two statements regarding the Flashback Table feature are correct？（）AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language （DML） locks.

4.单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）ANew channels for restore and recovery tasksBNew name for the data files of the tablespaceCAuxiliary name for the data files of the tablespaceDAuxiliary destinations for an auxiliary set of data files

更多“What is the default value for the ENABLED attribute of a job”相关问题

  • 第1题：

    单选题
    Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature？（）
    A

     RSTLNE

    B

     NLSRTL

    C

     LISTENER

    D

     NLSSORT

    E

     Linguistic sorts


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

  • 第2题：

    单选题
    Which statement about the enabling of table compression in Oracle Database 11g is true？（）
    A

     Compression can be enabled at the table， tablespace， or partition level for direct loads only.

    B

     Compression can be enabled only at the table level for both direct loads and conventional DML.

    C

     Compression can be enabled at the table， tablespace， or partition level for conventional DML only.

    D

     Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.


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

  • 第3题：

    多选题
    Which three actions are required to configure the Flashback Database？（）
    A

    set Flash Recovery Area

    B

    enable Flashback logging

    C

    create FLASHBACK tablespace

    D

    start the database in the ARCHIVELOG mode

    E

    start the database in the NOARCHIVELOG mode


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

  • 第4题：

    单选题
    The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）
    A

     The materialized view should have a complete refresh performed after the online table redefinition is completed.

    B

     The materialized view should have a fast refresh performed after the online table redefinition is completed.

    C

     The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.

    D

     The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.


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

  • 第5题：

    单选题
    Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR？（）
    A

     All objects in the database

    B

     Tables owned by SYS and SYSTEM

    C

     Data dictionary tables

    D

     NCHAR columns

    E

     CHAR columns


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

  • 第6题：

    单选题
    You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.   Your colleague asks for you to comment on his plan.  Which response would be correct？（）
    A

     The plan will work as is.

    B

     The plan needs to be modified to allow for an archive-log switch after step 3.

    C

     The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.

    D

     The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

    E

     The plan cannot work as presented.


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

  • 第7题：

    单选题
    Which background process coordinates the rebalance activity for disk groups？（）
    A

     ORBn

    B

     OSMB

    C

     RBAL

    D

     ASMn


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

  • 第8题：

    单选题
    Which of the following options describes Segment Shrink？（）
    A

     Reclaims space above and below the high-water mark without using additional space

    B

     Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operation

    C

     Deallocates space above the high-water mark that is currently not in use

    D

     None of the above


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

  • 第9题：

    单选题
    If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）
    A

     Recover the online redo log from backup.

    B

     Delete and re-create the log file.

    C

     Use the alter database clear logfile command to clear the log file.

    D

     Shut down the database and restart it.

    E

     Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.


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

  • 第10题：

    单选题
    You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
    A

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第11题：

    单选题
    What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；
    A

     The entire backup will fail.It will not be usable for recovery.

    B

     The entire backup will failbut any datafile successfully backed up will be usable for recovery.

    C

     If this backup fails，subsequent backups will prioritize datafiles not backed up.

    D

     If this backup fails，an error will be raised and any other commands will not be executed. 

    E

     If this backup fails，no error will be raised and any other commands will be executed.


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

  • 第12题：

    单选题
    Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（）
    A

     V$VALID_NLS_VALUES

    B

     NLS_VALID_VALUES

    C

     NLS_VALUE_OPTIONS

    D

     V$NLS_VALUE_OPTIONS

    E

     V$NLS_VALID_VALUES


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

  • 第13题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）
    A

     SQL statements that are part of the AWR baseline only

    B

     SQL statements based on the AWR top SQL identification

    C

     SQL statements that are part of the available SQL Tuning Set （STS） only

    D

     SQL statements that are available in the cursor cache and executed by a user other than SYS


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

  • 第14题：

    多选题
    If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）
    A

    The next time you back up the database when you are also connected to the recovery catalog and the target database

    B

    The next time you are connected to the target database and the recovery catalog database and issue the resync command

    C

    The next time you connect RMAN to just the recovery catalog

    D

    The next time you connect to the recovery catalog and the target database with RMAN

    E

    Connecting to the recovery catalog and issuing the resync all databases command


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

  • 第15题：

    多选题
    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）
    A

    The audit trail is stored in an operating system file.

    B

    Auditing is disabled for all privileges.

    C

    The audit trail is stored in the database.

    D

    Auditing is enabled for all privileges.

    E

    Auditing is enabled for certain privileges related to database security.


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

  • 第16题：

    单选题
    Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
    A

     The LOB values are automatically compressed.

    B

     The LOB values are cached by default in the buffer cache.

    C

     The LOB values are automatically stored in encrypted mode.

    D

     All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


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

  • 第17题：

    单选题
    You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）
    A

    After two days, a backup will be marked obsolete

    B

    After two days, a backup will be deleted from the media

    C

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

    D

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.


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

  • 第18题：

    多选题
    Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）
    A

    A must contain all of the characters defined in B

    B

    A must be Unicode

    C

    The encoded values in A must match the encoded values in B for all characters defined in B

    D

    A must be a multibyte character set

    E

    The encoded values in A must match the encoded values in B for all numeric and alphabetic character


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

  • 第19题：

    多选题
    Which client requests to the database can be captured as a part of the workload capture？（）
    A

    flashback query

    B

    distributed transactions

    C

    logging in and logging out of sessions

    D

    all DDL statements having bind variables

    E

    direct path load of data from external files


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

  • 第20题：

    多选题
    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第21题：

    多选题
    What recommendations does the SQL Access Advisor provide for optimizing SQL queries？（）
    A

    selection of SQL plan baselines

    B

    partitioning of tables and indexes

    C

    creation of index-organized tables

    D

    creation of bitmap， function-based，and B-tree indexes

    E

    optimization of materialized views for maximum query usage and fast refresh


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

  • 第22题：

    多选题
    What is the purpose of the recover command？（）
    A

    Recover database datafiles from physical disk backup sets.

    B

    Recover required incremental backups from physical disk backup sets.

    C

    Recover required archived redo logs from physical disk backup sets.

    D

    Apply incremental backups to recover the database.

    E

    Apply archived redo logs to recover the database.


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

  • 第23题：

    多选题
    Which three are the valid statements in relation to SQL plan baselines？（）
    A

    The plans can be manually loaded to the SQL plan baseline.

    B

    The plans in the SQL plan baseline are verified and accepted plans.

    C

    The plans generated for every SQL statement are stored in the SQL plan baseline by default.

    D

    The plan baselines are stored temporarily in the memory as long as the database instance is running.

    E

    For the SQL plan baselines to be accessible to the optimizer， the SYSAUX tablespace must be online.


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

  • 第24题：

    多选题
    The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)
    A

    Control files

    B

    Password files

    C

    Inactive online redo log file

    D

    Archived log files required to perform recovery

    E

    Newly created tablespace which is not backed up


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

相关内容