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


相似考题
更多“Which three are DATETIME data types that can be used when sp”相关问题
  • 第1题:

    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,D,E

  • 第2题:

    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

  • 第3题:

    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

    正确答案:B,C,E

  • 第4题:

    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

  • 第5题:

    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

  • 第6题:

    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

  • 第7题:

    多选题
    In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?()
    A

    Syntax when writing queries involving JOINS

    B

    Memory usage when working with the data 

    C

    Character set mapping index hash size

    D

    Disk usage when storing data


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

  • 第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题:

    多选题
    Private VLANS can be configured as which three of these port types?()
    A

    isolated

    B

    protected

    C

    private

    D

    associated

    E

    promiscuous

    F

    munity


    正确答案: E,D
    解析: 暂无解析

  • 第10题:

    多选题
    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
    解析: 暂无解析

  • 第11题:

    多选题
    Which three are true?()
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


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

  • 第12题:

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


    正确答案: E,B
    解析: 暂无解析

  • 第13题:

    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

  • 第14题:

    Private VLANS can be configured as which three of these port types?()

    • A、isolated
    • B、protected
    • C、private
    • D、associated
    • E、promiscuous
    • F、munity

    正确答案:A,E,F

  • 第15题:

    Which three types of optimization does the WX 60 device perform when Exchange 2000 and Outlook 2000 are used in the network? ()(Choose three.)

    • A、Fast Connection Setup
    • B、TCP Acceleration (AFP)
    • C、Network Sequence Caching
    • D、AppFlow's MAPI acceleration
    • E、Molecular Sequence Reduction

    正确答案:B,D,E

  • 第16题:

    Which three are true?()

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第17题:

    Which two statements are true regarding the USING and ON clauses in table joins?()

    • A、Both USING and ON clauses can be used for equijoins and nonequijoins 
    • B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
    • C、The ON clause can be used to join tables on columns that have different names but compatible data types 
    • D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

    正确答案:C,D

  • 第18题:

    多选题
    Which three types of optimization does the WX 60 device perform when Exchange 2000 and Outlook 2000 are used in the network? ()(Choose three.)
    A

    Fast Connection Setup

    B

    TCP Acceleration (AFP)

    C

    Network Sequence Caching

    D

    AppFlow's MAPI acceleration

    E

    Molecular Sequence Reduction


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

  • 第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


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

  • 第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题:

    多选题
    Which three Layer 2 encapsulation types would be used on a WAN rather than a LAN? (Choose three.)()
    A

    HDLC

    B

    Ethernet

    C

    Token Ring

    D

    PPP

    E

    FDDI

    F

    Frame Relay


    正确答案: B,E
    解析: 暂无解析

  • 第22题:

    多选题
    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
    解析: 暂无解析

  • 第23题:

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


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

  • 第24题:

    多选题
    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
    解析: 暂无解析