niusouti.com

多选题For which two actions can you use the TO_DATE function? ()Aconvert any date literal to a dateBconvert any numeric literal to a dateCconvert any date to a character literalDformat 'January 10 1999' for inputEformat '10-JAN-99' to 'January 10 1999'

题目
多选题
For which two actions can you use the TO_DATE function? ()
A

convert any date literal to a date

B

convert any numeric literal to a date

C

convert any date to a character literal

D

format 'January 10 1999' for input

E

format '10-JAN-99' to 'January 10 1999'


相似考题
参考答案和解析
正确答案: A,B
解析: 暂无解析
更多“多选题For which two actions can you use the TO_DATE function? ()Aconvert any date literal to a dateBconvert any numeric literal to a dateCconvert any date to a character literalDformat 'January 10 1999' for inputEformat '10-JAN-99' to 'January 10 1999'”相关问题
  • 第1题:

    You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?()

    A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files

    B.Execute the PURGE BINARY LOGE NOT USED command

    C.Remove all of the binary log files that have a modification date earlier than today

    D.Edit the .index file to remove the files you want to delete

    E.Ensure that none of the attached slaves are using any of the binary logs you want to delete


    参考答案:A, E

  • 第2题:

    Questions 55-56 refer to the following e-mail.
    To: Marketing Department
    From: Federico Botella
    Date: January9
    Subject: Sales Meeting.
    We need to postpone the sales meeting that I had arranged for January 15. I have a meeting
    with a client in Cancun on January 14, and I was not able to get a flight back to Houston until January 16. I'm sorry for any inconvenience this may cause you. The meeting is now tentatively rescheduled for 9 A.M. on January 18 in the conference room.


    When Mr. Botella can be in Houston?

    A. January 15
    B. January 14
    C. January 16
    D. January 18

    答案:C
    解析:

  • 第3题:

    Which statement about access lists that are applied to an interface is true?()

    • A、you can apply multiple access lists with the same protocol or in different…
    • B、you can config one access list,per direction,per layer 3 protocol
    • C、you can placeasmanyaccess lists as you want on any interface
    • D、you can apply ony one access list on any interface

    正确答案:D

  • 第4题:

    Which statement about access lists that are applied to an interface is true?()

    • A、you can apply multiple access lists with the same protocol or in different…
    • B、you can config one access list,per direction,per layer 3 protocol
    • C、you can place as many access lists as you want on any interface
    • D、you can apply ony one access list on any interface

    正确答案:D

  • 第5题:

    Which two are true about aggregate functions? ()

    • A、You can use aggregate functions in any clause of a SELECT statement.
    • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
    • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
    • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
    • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
    • F、You cannot group the rows of a table by more than one column while using aggregate functions.

    正确答案:A,D

  • 第6题:

    You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?()

    • A、Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
    • B、Execute the PURGE BINARY LOGE NOT USED command
    • C、Remove all of the binary log files that have a modification date earlier than today
    • D、Edit the .index file to remove the files you want to delete
    • E、Ensure that none of the attached slaves are using any of the binary logs you want to delete

    正确答案:A,E

  • 第7题:

    You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?()

    • A、SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
    • B、SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
    • C、SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
    • D、SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
    • E、SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

    正确答案:C

  • 第8题:

    Which two statements are true regarding working with dates?()

    • A、The default internal storage of dates is in the numeric format 
    • B、The default internal storage of dates is in the character format 
    • C、The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century 
    • D、The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

    正确答案:A,D

  • 第9题:

    多选题
    Which two tasks can you perform using only the TO_CHAR function? ()
    A

    convert 10 to 'TEN'

    B

    convert '10' to 10

    C

    convert 10 to '10'

    D

    convert 'TEN' to 10

    E

    convert a date to a character expression

    F

    convert a character expression to a date


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

  • 第10题:

    多选题
    Which three methods can you use for route discovery on a WX platform? ()(Choose three.)
    A

    Enable RIP

    B

    Enable OSPF

    C

    Periodically poll any router

    D

    Import routes from a TFTP server


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

  • 第11题:

    多选题
    Which two statements are true regarding working with dates?()
    A

    The default internal storage of dates is in the numeric format

    B

    The default internal storage of dates is in the character format

    C

    The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century

    D

    The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required


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

  • 第12题:

    问答题
    Directions: In this part of the test, you will write ONE sentence that is based on a picture. With each picture, you will be given TWO words or phrases that you must use in your sentence. You can change the forms of the words and you can use the words in any order. Your sentences will be scored on:•the appropriate use of grammar and•the relevance of the sentence to the pictureYou will have 8 minutes to complete this part of the test.Practice 1Directions: Write ONE sentence based on the picture, using the TWO words or phrases beneath it. You may change the forms of the words and you may use them, in any order.

    正确答案: (1) In the picture, two airplanes are by the field.
    (2) The airplane is by another plane.
    (3) I see a field by the airplane.
    (4) Many trees are by the airplanes and the buildings.
    (5) There are two airplanes parked by the field
    解析: 暂无解析

  • 第13题:

    Questions 55-56 refer to the following e-mail.
    To: Marketing Department
    From: Federico Botella
    Date: January9
    Subject: Sales Meeting.
    We need to postpone the sales meeting that I had arranged for January 15. I have a meeting
    with a client in Cancun on January 14, and I was not able to get a flight back to Houston until January 16. I'm sorry for any inconvenience this may cause you. The meeting is now tentatively rescheduled for 9 A.M. on January 18 in the conference room.


    What is the purpose of this e-mail?

    A. To schedule a conference.
    B. To reschedule a meeting.
    C. To introduce a new client.
    D. To announce vacation plans.

    答案:B
    解析:
    根据第一句We need to postpone the sales meeting that I had arranged for January 15 和最后一句The meeting is now tentatively rescheduled for 9 A.M. on January 18 in the conference room 可知,该邮件的目的是重新安排会议日程,故选B。

  • 第14题:

    If you have any questions, please feel free to interrupt at any time. This sentence means if you have something that you don’t understand, you can make a break in at any time.


    正确答案:正确

  • 第15题:

    Which three methods can you use for route discovery on a WX platform? ()(Choose three.)

    • A、Enable RIP
    • B、Enable OSPF
    • C、Periodically poll any router
    • D、Import routes from a TFTP server

    正确答案:A,B,D

  • 第16题:

    Which two tasks can your perform by using the TO_CHAR function? ()

    • A、Convert 10 to 'TEN'
    • B、Convert '10' to 10
    • C、Convert '10' to '10'
    • D、Convert 'TEN' to 10
    • E、Convert a date to a character expression
    • F、Convert a character expression to a date

    正确答案:C,E

  • 第17题:

    Which two tasks can you perform using only the TO_CHAR function? ()

    • A、convert 10 to 'TEN'
    • B、convert '10' to 10
    • C、convert 10 to '10'
    • D、convert 'TEN' to 10
    • E、convert a date to a character expression
    • F、convert a character expression to a date

    正确答案:C,E

  • 第18题:

    For which action can you use the TO_DATE function? ()

    • A、Convert any date literal to a date
    • B、Convert any numeric literal to a date
    • C、Convert any character literal to a date
    • D、Convert any date to a character literal
    • E、Format '10-JAN-99' to 'January 10 1999'

    正确答案:C

  • 第19题:

    Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ‘safe literals only’?() 

    • A、No literal value is substituted for a shared cursor. 
    • B、Different execution plans are generated for substituted literal values. 
    • C、The substitution of a literal value will produce different execution plans. 
    • D、The substitution of any literal value will produce exactly the same execution plan.

    正确答案:D

  • 第20题:

    多选题
    For which two actions can you use the TO_DATE function? ()
    A

    convert any date literal to a date

    B

    convert any numeric literal to a date

    C

    convert any date to a character literal

    D

    format 'January 10 1999' for input

    E

    format '10-JAN-99' to 'January 10 1999'


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

  • 第21题:

    单选题
    For which action can you use the TO_DATE function?()
    A

    Convert any date literal to a date

    B

    Convert any numeric literal to a date

    C

    Convert any character literal to a date

    D

    Convert any date to a character literal

    E

    Format '10-JAN-99' to 'January 10 1999'


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

  • 第22题:

    多选题
    Which two tasks can your perform by using the TO_CHAR function? ()
    A

    Convert 10 to 'TEN'

    B

    Convert '10' to 10

    C

    Convert '10' to '10'

    D

    Convert 'TEN' to 10

    E

    Convert a date to a character expression

    F

    Convert a character expression to a date


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

  • 第23题:

    多选题
    You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?()
    A

    Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files

    B

    Execute the PURGE BINARY LOGE NOT USED command

    C

    Remove all of the binary log files that have a modification date earlier than today

    D

    Edit the .index file to remove the files you want to delete

    E

    Ensure that none of the attached slaves are using any of the binary logs you want to delete


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

  • 第24题:

    单选题
    Any Works completion date quoted by the Repairer is an estimate only and the Repairer shall not be()liable for any failure to complete the Works by that date.
    A

    liable for any repair

    B

    liable for any failure

    C

    responsible for any repair

    D

    responsible for any fulfilling


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