多选题Which three are DATETIME data types that can be used when specifying column definitions? （）ATIMESTAMPBINTERVAL MONTH TO DAYCINTERVAL DAY TO SECONDDINTERVAL YEAR TO MONTHETIMESTAMP WITH DATABASE TIMEZONE

题目
多选题
Which three are DATETIME data types that can be used when specifying column definitions? （）
A

TIMESTAMP

B

INTERVAL MONTH TO DAY

C

INTERVAL DAY TO SECOND

D

INTERVAL YEAR TO MONTH

E

TIMESTAMP WITH DATABASE TIMEZONE

相似考题

1.Which three are DATETIME data types that can be used when specifying column definitions? ()A. TIMESTAMPB. INTERVAL MONTH TO DAYC. INTERVAL DAY TO SECONDD. INTERVAL YEAR TO MONTHE. TIMESTAMP WITH DATABASE TIMEZONE

2.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

3.Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）A、UniqueB、CheckC、ReferentialD、Informational

4.Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()A.UniqueB.CheckC.ReferentialD.Informational

更多“多选题Which three are DATETIME data types that can be used when specifying column definitions? （）ATIMESTAMPBINTERVAL MONTH TO DAYCINTERVAL DAY TO SECONDDINTERVAL YEAR TO MONTHETIMESTAMP WITH DATABASE TIMEZONE”相关问题

  • 第1题：

    The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）

    • A、data files
    • B、backup sets
    • C、control files
    • D、archived redo log files

    正确答案:A,B,D

  • 第2题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

    • A、A backup of the target database when it is mounted
    • B、A backup of online redo log files when the database is open
    • C、A backup of only used data blocks in the file beingbeingbackup up
    • D、A backup of online， read/write data files when the database is open
    • E、A backup of only those data blocks that have changed since a previous backup
    • F、A backup of online， read/write data files when the database is in the NOMOUNT state.

    正确答案:A,C,D,E

  • 第3题：

    You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

    • A、BFILE 
    • B、REF column 
    • C、Object table 
    • D、Column object 
    • E、INSTEAD-OF trigger

    正确答案:B,C,D

  • 第4题：

    Which three statements are true about Flashback Database?（）

    • A、Flashback logs are written sequentially, and are archived.
    • B、Flashback Database uses a restored control file to recover a database.
    • C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
    • D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
    • E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
    • F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

    正确答案:B,C,F

  • 第5题：

    Examine the list of variables and their data types：  AME DATA Type  TS， TS1 TIMESTAMP  TSZ TIMESTAMP WITH TIME ZONE  TLZ TIMESTAMP WITH LOCAL TIME ZONE  IYM INTERVAL YEAR TO MONTH  IDS， IDSI INTERVAL YEAR To SECOND   Which three expressions using the new data and time data types are valid？（）

    • A、IDS* 2
    • B、TS + IYM
    • C、TS –TSI
    • D、IDS – TS
    • E、IDS + IYM

    正确答案:A,B,E

  • 第6题：

    多选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
    A

    A backup of the target database when it is mounted

    B

    A backup of online redo log files when the database is open

    C

    A backup of only used data blocks in the file beingbeingbackup up

    D

    A backup of online， read/write data files when the database is open

    E

    A backup of only those data blocks that have changed since a previous backup

    F

    A backup of online， read/write data files when the database is in the NOMOUNT state.


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

  • 第7题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

  • 第8题：

    多选题
    Which three tasks can be performed using regular expression support in Oracle Database 10g？（）
    A

    it can be used to concatenate two strings.

    B

    it can be used to find out the total length of the string.

    C

    it can be used for string manipulation and searching operations.

    D

    it can be used to format the output for a column or expression having string data.

    E

    it can be used to find and replace operations for a column or expression having string data.


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

  • 第9题：

    多选题
    The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）
    A

    data files

    B

    backup sets

    C

    control files

    D

    archived redo log files


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

  • 第10题：

    多选题
    Which two statements regarding external authentication servers for firewall user authentication are true?（） (Choose two.)
    A

    Up to three external authentication server types can be used simultaneously.

    B

    Only one external authentication server type can be used simultaneously.

    C

    If the local password database is not configured in the authentication order, and the configured authentication server  bypassed.

    D

    If the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.


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

  • 第11题：

    多选题
    Which three statements are true about database recovery operations？（）
    A

    Damaged or lost data files are restored from backups.

    B

    Redo log file entries are used to roll forward the database.

    C

    Undo segments are used to roll back any uncommitted transactions.

    D

    Transactions that were active when the failure occurred are restarted.

    E

    Transactions that were active when the failure occurred are automatically committed during the recover procedure.


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

  • 第12题：

    多选题
    For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）
    A

    RMAN image copies

    B

    RMAN database backups

    C

    RMAN tablespace backups

    D

    user­managed backups placed in the flash recovery area

    E

    user­managed backups that have been cataloged with RMAN

    F

    user­managed data file backups for which the full path name is specified


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

  • 第13题：

    For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）

    • A、RMAN image copies
    • B、RMAN database backups
    • C、RMAN tablespace backups
    • D、user­managed backups placed in the flash recovery area
    • E、user­managed backups that have been cataloged with RMAN
    • F、user­managed data file backups for which the full path name is specified

    正确答案:A,B,C,E

  • 第14题：

    Which three tasks can be performed using regular expression support in Oracle Database 10g？（）

    • A、 it can be used to concatenate two strings.
    • B、 it can be used to find out the total length of the string.
    • C、 it can be used for string manipulation and searching operations.
    • D、 it can be used to format the output for a column or expression having string data.
    • E、 it can be used to find and replace operations for a column or expression having string data.

    正确答案:C,D,E

  • 第15题：

    Which three are DATETIME data types that can be used when specifying column definitions?（）

    • A、TIMESTAMP
    • B、INTERVAL MONTH TO DAY
    • C、INTERVAL DAY TO SECOND
    • D、INTERVAL YEAR TO MONTH
    • E、TIMESTAMP WITH DATABASE TIMEZONE

    正确答案:A,C,D

  • 第16题：

    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

    • A、Only one LONG column can be used per table 
    • B、A TIMESTAMP data type column stores only time values with fractional seconds 
    • C、The BLOB data type column is used to store binary data in an operating system file 
    • D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
    • E、The value for a CHAR data type column is blank-padded to the maximum defined column width

    正确答案:A,D,E

  • 第17题：

    多选题
    Which three statements are true about Flashback Database?（）
    A

    Flashback logs are written sequentially, and are archived.

    B

    Flashback Database uses a restored control file to recover a database.

    C

    The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

    D

    Flashback Database can recover a database to the state that it was in before a reset logs operation.

    E

    Flashback Database can recover a data file that was dropped during the span of time of the flashback.

    F

    Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.


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

  • 第18题：

    多选题
    Which three are DATETIME data types that can be used when specifying column definitions? （）
    A

    TIMESTAMP

    B

    INTERVAL MONTH TO DAY

    C

    INTERVAL DAY TO SECOND

    D

    INTERVAL YEAR TO MONTH

    E

    TIMESTAMP WITH DATABASE TIMEZONE


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

  • 第19题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第20题：

    多选题
    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）
    A

    Only one LONG column can be used per table

    B

    A TIMESTAMP data type column stores only time values with fractional seconds

    C

    The BLOB data type column is used to store binary data in an operating system file

    D

    The minimum column width that can be specified for a VARCHAR2 data type column is one

    E

    The value for a CHAR data type column is blank-padded to the maximum defined column width


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

  • 第21题：

    多选题
    On a 3550 EMI switch，  which three types of interfaces can be used to configure HSRP？ （）
    A

    Loopback interface

    B

    SVI interfac

    C

    Routed port

    D

    Access port

    E

    EtherChannel port channel

    F

    BVI interface


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

  • 第22题：

    多选题
    Cisco IOS NetFlow gathers data that can be used in which three of these？ （）
    A

    accounting

    B

    authentication

    C

    authorization

    D

    network monitoring

    E

    network planning


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

  • 第23题：

    多选题
    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）
    A

    create

    B

    import

    C

    load

    D

    sqlimport

    E

    update


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

  • 第24题：

    多选题
    Examine the list of variables and their data types：  AME DATA Type  TS， TS1 TIMESTAMP  TSZ TIMESTAMP WITH TIME ZONE  TLZ TIMESTAMP WITH LOCAL TIME ZONE  IYM INTERVAL YEAR TO MONTH  IDS， IDSI INTERVAL YEAR To SECOND   Which three expressions using the new data and time data types are valid？（）
    A

    IDS* 2

    B

    TS + IYM

    C

    TS –TSI

    D

    IDS – TS

    E

    IDS + IYM


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

相关内容