单选题What is true about sequences?（）A Once created, a sequence belongs to a specific schema.B Once created, a sequence is linked to a specific table.C Once created, a sequence is automatically available to all users.D Only the DBA can control which sequence

题目
单选题
What is true about sequences?（）
A

Once created, a sequence belongs to a specific schema.

B

Once created, a sequence is linked to a specific table.

C

Once created, a sequence is automatically available to all users.

D

Only the DBA can control which sequence is used by a certain table.

E

Once created, a sequence is automatically used in all INSERT and UPDATE statements.

相似考题

1.You are granted the CREATE VIEW privilege. What does this allow you to do? ()A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.

2.Which of the following is a characteristic of a sequence?()A.A sequence will never generate duplicate valuesB.The MAXVALUE of a sequence can be equal to the MINVALUEC.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD.When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

3.You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）A、It is created as a nondisplay item. B、The Lock Record property is set to Yes. C、It cannot be referenced in item level triggers. D、It is placed on the canvas with the highest sequence number.

4.A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）A.2B.3C.11D.30

更多“单选题What is true about sequences?（）A Once created, a sequence belongs to a specific schema.B Once created, a sequence is linked to a specific table.C Once created, a sequence is automatically available to all users.D Only the DBA can control which sequence”相关问题

  • 第1题：

    Which of the following is a characteristic of a sequence?（）

    • A、A sequence will never generate duplicate values
    • B、The MAXVALUE of a sequence can be equal to the MINVALUE
    • C、It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
    • D、When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

    正确答案:B

  • 第2题：

    Which two patented or patent-pending compression and caching technologies are used for WX/WXC devices?（）(Choose two.)

    • A、Network Sequence Caching (NSC)
    • B、Molecular Sequence Caching (MSC)
    • C、Network Sequence Reduction (NSR)
    • D、Molecular Sequence Reduction (MSR)

    正确答案:A,D

  • 第3题：

    What is true about sequences? （）

    • A、Once created, a sequence belongs to a specific schema.
    • B、Once created, a sequence is linked to a specific table.
    • C、Once created, a sequence is automatically available to all users.
    • D、Only the DBA can control which sequence is used by a certain table.
    • E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.

    正确答案:A

  • 第4题：

    Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）

    • A、 A range of SCN values
    • B、 A list of SCN values
    • C、 A starting and ending timestamp
    • D、 Minimum and maximum sequence values
    • E、 A list of sequence values

    正确答案:A,C

  • 第5题：

    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

    • A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
    • B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
    • C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
    • D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
    • E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
    • F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

    正确答案:C,D

  • 第6题：

    What is true about sequences? （）

    • A、The start value of the sequence is always 1.
    • B、A sequence always increments by 1.
    • C、The minimum value of an ascending sequence defaults to 1.
    • D、The maximum value of descending sequence defaults to 1.

    正确答案:A

  • 第7题：

    Which two statements are true about standard database auditing（）

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案:A,B

  • 第8题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level.
    • C、Constraints can be created after the table is created.
    • D、Constraints can be created at the same time the table is created.
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

    正确答案:C,D

  • 第9题：

    单选题
    What is true about sequences?（）
    A

    The start value of the sequence is always 1.

    B

    A sequence always increments by 1.

    C

    The minimum value of an ascending sequence defaults to 1.

    D

    The maximum value of descending sequence defaults to 1.


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

  • 第10题：

    单选题
    You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）
    A

    It is created as a nondisplay item. 

    B

    The Lock Record property is set to Yes. 

    C

    It cannot be referenced in item level triggers. 

    D

    It is placed on the canvas with the highest sequence number.


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

  • 第11题：

    单选题
    You are granted the CREATE VIEW privilege. What does this allow you to do?（）
    A

    Create a table view.

    B

    Create a view in any schema.

    C

    Create a view in your schema.

    D

    Create a sequence view in any schema.

    E

    Create a view that is accessible by everyone.

    F

    Create a view only of it is based on tables that you created.


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

  • 第12题：

    A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）

    • A、2
    • B、3
    • C、11
    • D、30

    正确答案:B

  • 第13题：

    Which three scenarios are true about Domains?（）

    • A、Domains can be created using the Configuration Wizard.
    • B、Domains can be created using WLST.  
    • C、Domain configuration files are located in the WebLogic home directory.
    • D、Domains can be created based on a domain template.

    正确答案:A,B,D

  • 第14题：

    When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）

    • A、Thread number.
    • B、Log Sequence number.
    • C、Control file sequence number.
    • D、Name of the last archived log.

    正确答案:A,C

  • 第15题：

    Which two statements are true with respect to the maintenance window？（） .

    • A、 A DBA can enable or disable an individual task in all maintenance windows.
    • B、 A DBA cannot change the duration of the maintenance window after it is created.
    • C、 In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
    • D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

    正确答案:A,D

  • 第16题：

    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.

    正确答案:B,C

  • 第17题：

    You are granted the CREATE VIEW privilege. What does this allow you to do?（）

    • A、Create a table view.
    • B、Create a view in any schema.
    • C、Create a view in your schema.
    • D、Create a sequence view in any schema.
    • E、Create a view that is accessible by everyone.
    • F、Create a view only of it is based on tables that you created.

    正确答案:C

  • 第18题：

    Which two statements about creating constraints are true? （）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level
    • C、Constraints can be created after the table is created
    • D、Constraints can be created at the same time the table is created
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

    正确答案:C,D

  • 第19题：

    多选题
    Which two statements are true about standard database auditing（）
    A

    DDL statements can be audited.

    B

    Statements that refer to stand-alone procedure can be audited.

    C

    Operations by the users logged on as SYSDBA cannot be audited.

    D

    Only one audit record is ever created for a session per audited statement even though it is executedmore than once.


    正确答案： A,D
    解析： 暂无解析

  • 第20题：

    单选题
    What is true about sequences? （）
    A

    Once created, a sequence belongs to a specific schema.

    B

    Once created, a sequence is linked to a specific table.

    C

    Once created, a sequence is automatically available to all users.

    D

    Only the DBA can control which sequence is used by a certain table.

    E

    Once created, a sequence is automatically used in all INSERT and UPDATE statements.


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

  • 第21题：

    单选题
    A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）
    A

    2

    B

    3

    C

    11

    D

    30


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

  • 第22题：

    单选题
    Which of the following is a characteristic of a sequence?（）
    A

    A sequence will never generate duplicate values

    B

    The MAXVALUE of a sequence can be equal to the MINVALUE

    C

    It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

    D

    When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries


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

相关内容