单选题For which action can you use the TO_DATE function? ()A Convert any date literal to a dateB Convert any numeric literal to a dateC Convert any character literal to a dateD Convert any date to a character literalE Format '10-JAN-99' to 'January 10 1999'

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


相似考题
参考答案和解析
正确答案: E
解析: 暂无解析
更多“单选题For which action can you use the TO_DATE function? ()A Convert any date literal to a dateB Convert any numeric literal to a dateC Convert any character literal to a dateD Convert any date to a character literalE Format '10-JAN-99' to 'January 10 1999'”相关问题
  • 第1题:

    The character mode sales report is stored on the network drive as a .REX. You need to make changes to the report layout. Using the report builder how would you change this file?()

    • A、Open the file using the menu option file->open make the changes and recompile the report. 
    • B、Convert the file into .REP file using the report compiler make the changes and convert the file back to a .REX file. 
    • C、Execute the R30CONV command to convert the file to a .RDF file, make the changes and convert the file back to a .REX file. 
    • D、Choose file -> administration->compile. Convert the file to a .REP file, make the changes and convert the file back to a .REX file. 
    • E、Execute the R30CONV command to convert the file to a .REP file, make the changes and convert the file back to a .REX file.

    正确答案:D

  • 第2题:

    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

  • 第3题:

    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

  • 第4题:

    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

  • 第5题:

    You work as an administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.All servers on the ABC.com network have Windows Server 2012 R2 installed. You have received instructions to convert a basic disk to a GPT disk.Which of the following is TRUE with regards to GPT disks?()

    • A、To convert a basic disk to a GPT disk, the disk must not contain any partitions or volumes
    • B、You can convert a basic disk to a GPT disk, regardless of partitions or volumes
    • C、GPT is required for disks larger than 2 TB
    • D、GPT is required for disks smaller than 2 TB
    • E、The GPT partition style can be used on removable media
    • F、GPT disks make use of the standard BIOS partition table

    正确答案:A,C

  • 第6题:

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

  • 第7题:

    单选题
    Which statement about WSA access logs that are to be processed by sawmill for cisco ironport istrue?()
    A

     the default log format can be used

    B

     the fields%XC%X n must be appended to the default access log format

    C

     any log format can beused , but all WSAs must use the same format

    D

     any log format can be used. And different WSAs may use different formats


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

  • 第8题:

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

  • 第9题:

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

  • 第10题:

    单选题
    You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()
    A

     Data Pump Export and Import

    B

     conventional export and import

    C

     the CONVERT command of RMAN

    D

     the BACKUP AS COPY. command of RMAN


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

  • 第11题:

    单选题
    which one of the following should maria do to display the release date in a text column?()
    A

    used the number and time format options 

    B

    used the @date to text functions to convert time to text 

    C

    concatenated the date types using mathematical operators 

    D

    used the @text functions to convert time and number data to text in text columns 


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

  • 第12题:

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


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

  • 第13题:

    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

  • 第14题:

    You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()  

    • A、 Data Pump Export and Import
    • B、 conventional export and import
    • C、 the CONVERT command of RMAN
    • D、 the BACKUP AS COPY. command of RMAN

    正确答案:D

  • 第15题:

    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

  • 第16题:

    What does the Character Set Scanner command line utility do?()

    • A、Reports only on any Unicode character conversions required.
    • B、Performs character set conversions to the new specified character set.
    • C、Scans on any character set conversion required, then converts the data.
    • D、Checks for any character definitions that will fail conversion to the new character set.

    正确答案:D

  • 第17题:

    You work as an Exchange Administrator for Xxx .The company has a Windows 2008 Active  Directorybased network.You have just finished deploying an Exchange 2010 server and migrating all mailboxes including resource mailboxes from Exchange Server 2003. After the migration from the Exchange 2003 server was complete, you noticed that the resource mailboxes were showing up as a shared mailbox and not a resource mailbox.You realize that you need to convert them to Exchange 2010 resource mailboxes.While logged into the Exchange Management Console, you do not see any option to convert a mailbox. What should you use to convert this Exchange 2010 shared mailbox to an Exchange 2010 resource mailbox?()

    • A、Exchange Troubleshooting Assistant
    • B、Exchange System Manager
    • C、Exchange Management Shell
    • D、Command prompt

    正确答案:C

  • 第18题:

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

  • 第19题:

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

  • 第20题:

    单选题
    You work as an Exchange Administrator for Xxx .The company has a Windows 2008 Active  Directorybased network.You have just finished deploying an Exchange 2010 server and migrating all mailboxes including resource mailboxes from Exchange Server 2003. After the migration from the Exchange 2003 server was complete, you noticed that the resource mailboxes were showing up as a shared mailbox and not a resource mailbox.You realize that you need to convert them to Exchange 2010 resource mailboxes.While logged into the Exchange Management Console, you do not see any option to convert a mailbox. What should you use to convert this Exchange 2010 shared mailbox to an Exchange 2010 resource mailbox?()
    A

    Exchange Troubleshooting Assistant

    B

    Exchange System Manager

    C

    Exchange Management Shell

    D

    Command prompt


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

  • 第21题:

    多选题
    You work as an administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.All servers on the ABC.com network have Windows Server 2012 R2 installed. You have received instructions to convert a basic disk to a GPT disk.Which of the following is TRUE with regards to GPT disks?()
    A

    To convert a basic disk to a GPT disk, the disk must not contain any partitions or volumes

    B

    You can convert a basic disk to a GPT disk, regardless of partitions or volumes

    C

    GPT is required for disks larger than 2 TB

    D

    GPT is required for disks smaller than 2 TB

    E

    The GPT partition style can be used on removable media

    F

    GPT disks make use of the standard BIOS partition table


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

  • 第22题:

    单选题
    What does the Character Set Scanner command line utility do?()
    A

    Reports only on any Unicode character conversions required.

    B

    Performs character set conversions to the new specified character set.

    C

    Scans on any character set conversion required, then converts the data.

    D

    Checks for any character definitions that will fail conversion to the new character set.


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

  • 第23题:

    单选题
    The character mode sales report is stored on the network drive as a .REX. You need to make changes to the report layout. Using the report builder how would you change this file?()
    A

    Open the file using the menu option file->open make the changes and recompile the report. 

    B

    Convert the file into .REP file using the report compiler make the changes and convert the file back to a .REX file. 

    C

    Execute the R30CONV command to convert the file to a .RDF file, make the changes and convert the file back to a .REX file. 

    D

    Choose file -> administration->compile. Convert the file to a .REP file, make the changes and convert the file back to a .REX file. 

    E

    Execute the R30CONV command to convert the file to a .REP file, make the changes and convert the file back to a .REX file.


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

  • 第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
    解析: 暂无解析