CMS专题
单选题A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR
题目
20
25
50
55
相似问题和答案
第1题：
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
第2题：
A towing light is ______.
A.shown below the stern light
B.white in color
C.displayed at the masthead
D.a yellow light having the same characteristics as the stern light
第3题：
You have recently created a serializable class named Vehicle.The class is shown below:[Serializable]public class Vehicle{public string VIN;public string Make;public string Model;public string Year;}You are planning to create a custom formatter class to control the formatting of Vehicle objects when they are serialized.You need to ensure that is achieved with as little development effort as possible.What should you do?（）
A.
B.
C.
D.
第4题：
以下哪项属于DDL操作（）。
- A、delete
- B、update
- C、create
- D、insert
正确答案:C
第5题：
When does a transaction complete?（）
- A、when a DELETE statement is executed
- B、when a ROLLBACK command is executed
- C、when a PL/SQL anonymous block is executed
- D、when a data definition language (DDL) statement is executed
- E、when a TRUNCATE statement is executed after the pending transact ion
正确答案:B,D,E
第6题：
What operation on relations R and S produces the relation shown below?
A．Union
B．Difference
C．Intersection
D．Division
第7题：
Which two statements about views are true? （）
- A、A view can be created as read only.
- B、A view can be created as a join on two or more tables.
- C、A view cannot have an ORDER BY clause in the SELECT statement.
- D、A view cannot be created with a GROUP BY clause in the SELECT statement.
- E、A view must have aliases defined for the column names in the SELECT statement.
正确答案:A,B
第8题：
A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B. All DDL commands are logged in the alert log file.
C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D. Only DDL commands that resulted in the creation of new segments are logged.
E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
第9题：
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.
正确答案:A
第10题：
Router R1 is configured as shown below: router eigrp 100 network 10.0.0.0 eigrp stub Based on the information shown above, which two types of routes will be advertised？（）
- A、Receive - only
- B、Stub
- C、Static
- D、Summary
- E、Connected
- F、Dynamic
正确答案:D,E