欢迎来到建筑考试题库网 建筑考试题库官网
全部科目 > Oracle认证考试 > 1Z0-007

单项选择题

The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()

    A. no privileges
    B. only the SELECT privilege
    C. only the CONNECT privilege
    D. all the privileges of a default user

点击查看答案

相关考题

  • 多项选择题
    Which four are correct guidelines for naming database tables?()

    A. Must begin with either a number or a letter.
    B. Must be 1-30 characters long.
    C. Should not be an Oracle Server reserved word.
    D. Must contain only A-Z, a-z, 0-+, _, *, and #.
    E. Must contain only A-Z, a-z, 0-9, _, $, and #.
    F. Must begin with a letter.

  • 多项选择题
    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

  • 多项选择题
    Which two statements about sequences are true?()

    A. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
    B. You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
    C. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
    D. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
    E. If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
    F. You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题