网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）
A
Sequence
B
Table Function
C
Identity Column
D
INSTEAD OF Trigger
参考答案
参考解析
解析：
暂无解析
更多 “单选题A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A SequenceB Table FunctionC Identity ColumnD INSTEAD OF Trigger” 相关考题
考题
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?()
A. A must contain all of the characters defined in BB. A must be UnicodeC. The encoded values in A must match the encoded values in B for all characters defined in BD. A must be a multibyte character setE. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
考题
Which two statements are true regarding the default behavior of the ORDER BY clause? ()
A.Null values are left out of the sort.B.Character values are displayed from Z to AC.Date values are displayed with the earliest value first.D.Null values are displayed last for descending sequences.E.Numeric values are displayed with the lowest values first.
考题
有如下关系：课程表C，主键为c-id (char (4))。若用如下语句建立成绩表SC： CREATE TABLE SC(s-id char(6)NOT NULL，c-id char(4)NOT NULL，score Inteeer)， 其中s-id为主键，c-id为外键(是C表的主键)。当执行如下语句肘，( )语句不能执行。A．INSERT SC VALUES('990101'，'NULL'，75)B．INSERT SC VALUES('990203'，'C601'，80)C．INSERT SC VALUES(NULL，'C602'，93)D．INSERT SC VALUES('990202'，'C604'，NULL)
考题
阅读下列说明，回答问题1至问题3。【说明】关于一位花商有以下一些事实。(1)销售在不同地区生长的花，这些地区一年的最低气温在一定范围内变化。(2)想用编号来表示发货类型。(3)要出售某些类型的花。假定已经通过SQL语句建立了基本表：CREATE TABLE Zone(ID CHAR(2) PRIMARY KEY，LowerTemp NUMERIC(3)，UpperTemp NUMERIC(3))；CREATE TABLE Delivery(ID CHAR (2) PRIMARY KEY，Category CHAR(5)，DelSize NUMERIC(5，3))；CREATE TABLE FlowerInfo(ID CHAR (3)，ComName CHAR(25)，LatName CHAR(30)，Czone NUMERIC(3)，Hzone NUMERIC(3)，Delivered NUMERIC(3)，SunNeed CHAR(3)，PRIMARY KEY(ID))；地区(ID，最高温度，最低温度)发货(ID，发货类型，发货规格)花的信息(ID，普通名，拉丁名，花能够生长的最冷地区，花能够生长的最热地区，发货类型，日光需求)写出SQL语句，将记录(ID，Category==pot，DelSize=1.5)插入Delivery表中。
考题
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A.SequenceB.Table FunctionC.Identity ColumnD.INSTEAD OF Trigger
考题
有如下关系：课程表C，主键为c-id(char(4))。c-id c-name若用如下语句建立成绩表SC： CREATE TABLE SC(s-id char(6)NOT NULL，c-id char(4)NOT NULL，score Integer)，其中s-id为主键，c-id为外键(是C表的主键)。当执行如下语句时，哪个语句不能执行? ( )。A．INSERT SC VALUES('990101'，'NULL'，75)B．INSERT SC VALUES('990203'，'C601'，80)C．INSERT SC VALUES(NULL，'C602'，93)D．INSERT SC VALUES('990202'，'C604'，NULL)
考题
Which values are NOT permitted to be part of the primary key?A．alpha-numeric charactersB．punctuationC．special charactersD．NULL
考题
Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）A、 A must contain all of the characters defined in BB、 A must be UnicodeC、 The encoded values in A must match the encoded values in B for all characters defined in B D、 A must be a multibyte character setE、 The encoded values in A must match the encoded values in B for all numeric and alphabetic character
考题
现有表book，字段：id（int），title（varchar），price（float）；其中id字段设为标识，使用insert语句向book表中插入数据，以下语句错误的是（）。A、insert into book (id,title,price) values(1,'java',100)B、insert into book (title,price) values('java',100)C、insert into book values ('java',100) 这辆都不可以啊，如果不指定列需要明确的给出空值D、insert book values('java',100)
考题
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）A、database table B、transactional trigger C、stored procedure D、FROM clause query E、client-side procedure
考题
WebSphere Commerce Accelerator will be used to create a product. The product has 6 variations determined by attributes Size， which has three values and Color， which has two values. What is the PREFERRED method to create the product and its SKUs using the Product Management tool？（）A、Create the product. Create each SKU. For each SKU create two descriptive attributes with the correct values.B、Create the product. Create two defining attributes. Create each SKU and during creation assign theattributes to the SKU with the correct values.C、Create the product. Create two defining attributes with the permitted values. Generate the SKUs.D、Create the product. Create two descriptive attributes with the permitted values. Generate the SKUs.
考题
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A、SequenceB、Table FunctionC、Identity ColumnD、INSTEAD OF Trigger
考题
Which WebSphere Commerce catalog management tool replaces symbols in an XML file with the appropriate numeric values for new or existing records in the WebSphere Commerce database？（）A、Data CheckerB、DTD GeneratorC、ID ResolverD、Mass LoaderE、XML Transformer
考题
james needs to sort a list of values in a list of values in fieldA, and when the form in saved ,he wants to sort the list before it is saved. Which one of the following formulas would accomplish this?（）A、 @sort B、 @sort(@thisvalue) C、 @sortAscending(fieldA) D、 @sort(“ascesding”;”fieldA”)
考题
Which two statements are true regarding the default behavior of the ORDER BY clause? （）A、Null values are left out of the sort.B、Character values are displayed from Z to AC、Date values are displayed with the earliest value first.D、Null values are displayed last for descending sequences.E、Numeric values are displayed with the lowest values first.
考题
多选题Which three statements inserts a row into the table?（）AINSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);BINSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);CINSERT INTO employees VALUES (‘1000’,‘John’,NULL);DINSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);EINSERT INTO employees (employee_id) VALUES (1000);FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
考题
单选题For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of fist fifteen to total_inventory and a filter of last 20 for work_in_progress. Which records will the report return?（）A
First 15 dept_no values. B
Last 20 ID_no and quantity values with the first 15 dept_no values for each work_in_progress value. C
First 15 dept_no values with the last 20 ID_number and quantity values for each total_inventory value. D
First 15 dept_no values and the last 20 ID_no and quantity values. E
The last 20 ID_number and quantity values.
考题
单选题The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?（）A
show ip ospf [process - id] interfaceB
show ip ospf neighborC
show ip ospf [process - id]D
show ip ospf [process - id area - id] database
考题
单选题james needs to sort a list of values in a list of values in fieldA, and when the form in saved ,he wants to sort the list before it is saved. Which one of the following formulas would accomplish this?（）A
@sort B
@sort(@thisvalue) C
@sortAscending(fieldA) D
@sort(“ascesding”;”fieldA”)
考题
多选题Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）AA must contain all of the characters defined in BBA must be UnicodeCThe encoded values in A must match the encoded values in B for all characters defined in BDA must be a multibyte character setEThe encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
考题
单选题现有表book，字段：id（int），title（varchar），price（float）；其中id字段设为标识，使用insert语句向book表中插入数据，以下语句错误的是（）。A
insert into book（id，title，price）values（1，’java’，100）B
insert into book（title，price）values（’java’，100）C
insert into book values（’java’，100）D
insert book values（’java’，100）
考题
单选题Which WebSphere Commerce catalog management tool replaces symbols in an XML file with the appropriate numeric values for new or existing records in the WebSphere Commerce database？（）A
Data CheckerB
DTD GeneratorC
ID ResolverD
Mass LoaderE
XML Transformer
考题
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A
INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);B
INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C
INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);D
INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);E
INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);
考题
多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）AINSERT INTO employees VALUES (NULL, 'JOHN','Smith');BINSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');CINSERT INTO employees VALUES ('1000','JOHN','NULL');DINSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');EINSERT INTO employees (employee_id) VALUES (1000);FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);
考题
单选题现有表book，字段：id（int），title（varchar），price（float）；其中id字段设为自增长的标识，使用insert语句向book表中插入数据，以下语句错误的是（）。A
insertintobook（id，title，price）values（1，’java’，100）B
insertintobook（title，price）values（’java’，100）C
insertintobookvalues（’java’，100）D
insertbookvalues（’java’，100）
考题
多选题要在users表中插入一条新记录，下面语句正确的是（）。AInsert Into users（id，user_name） Values（100， luhong）BInsert Into users（real_name，tel） Values（卢红，6545632）CInsert Into users（user_name，Email） Values（luhong， ）DInsert Into users（user_name，Email） Values（luhong， NULL）
考题
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid? （）A
INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);B
INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');C
INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));D
INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01');
热门标签
最新试卷