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

单项选择题

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?()

    A.It will create the tablespace TEMP1 in group G1
    B.It will create the tablespace TEMP1 in group G3 
    C.It will not add the tablespace TEMP1 to any group
    D.It will create the tablespace TEMP1 in the default group
    E.It will throw an error with message 'specified group is not available
    F.It will create a new group with a system-generated name and add the tablespace TEMP1 to it.

点击查看答案

相关考题

  • 问答题
    简述心理健康自我调节的过程?
  • 多项选择题
    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 than 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 a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

  • 问答题
    乙公司可以向甲公司请求返还多少金额?
微信小程序免费搜题
微信扫一扫,加关注免费搜题

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