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

多项选择题

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 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.

  • 多项选择题
    Which three statements about subqueries are true?()

    A. A single row subquery can retrieve only one column and one row.
    B. A single row subquery can retrieve only one row but many columns.
    C. A multiple row subquery can retrieve multiple rows and multiple columns.
    D. A multiple row subquery can be compared by using the ">" operator.
    E. A single row subquery can use the IN operator.
    F. A multiple row subquery can use the "=" operator.

  • 多项选择题
    When should you create a role? ()

    A. To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
    B. To grant a group of related privileges to a user.
    C. When the number of people using the database is very high.
    D. To simplify the process of granting and revoking privileges.
    E. To simplify profile maintenance for a user who is constantly traveling.

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

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