多选题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 empl

题目

多选题

Which three statements inserts a row into the table?（）

INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);

INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);

INSERT INTO employees VALUES (‘1000’,‘John’,NULL);

INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);

INSERT INTO employees (employee_id) VALUES (1000);

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);

相似考题

1.Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）A. CREATE INDEX NAME _IDX (first_name, last_name);B. CREATE INDEX NAME _IDX (first_name, AND last_name)C. CREATE INDEX NAME_IDX ON (First_name, last_name);D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

2.设有Teachers表，该表的定义如下： CREATE TABLE Teachers（ Tno CHAR（8） PRIMARY KEY， Tname VARCHAR（10） NOT NULL， Age TINYINT CHECK（Age BETWEEN 25 AND 65））下列插入语句中，不能正确执行的是（）。AINSERT INTO Teachers VALUES（’T100’，’张宏’，NULL）BINSERT INTO Teachers（Tno，Tname，Age） VALUES（’T100’，’张宏’，30）CINSERT INTO Teachers（Tno，Tname） VALUES（’T100’，’张宏’）DINSERT INTO Teachers VALUES（’T100’，’张宏’）

3. A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) ); Which of the following INSERT statements will fail?（）A、INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)B、INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)C、INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)D、INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)

4.A table was created using the following DDL:CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100),job CHAR(10) CHECK (job IN (‘Sales‘,‘Mgr‘,‘Clerk‘)), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) );Which of the following INSERT statements will fail?（）A.INSERT INTO employee VALUES (2, ‘Smith‘, 80, ‘Mgr‘, ‘09/03/2006‘, 80000, NULL)B.INSERT INTO employee VALUES (4, ‘Smith‘, 86, ‘Mgr‘, ‘07/14/2003‘, 90000, NULL)C.INSERT INTO employee VALUES (1, ‘Smith‘, 55, ‘Sales‘, ‘07/14/2003‘, NULL, NULL)D.INSERT INTO employee VALUES (3, ‘Smith‘, 33, ‘Analyst‘, ‘11/26/2006‘, 90000, NULL)

更多“多选题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(”相关问题

第1题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）
- A、INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
- B、INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
- C、INSERT INTO employees VALUES ( '1000', 'John', NULL);
- D、INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
- E、INSERT INTO employees (employee_id) VALUES (1000);
- F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
正确答案:C,E,F
第2题：

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? （）
- A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
- B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
- C、INSERT INTO employees VALUES ('1000','JOHN','NULL');
- D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
- E、INSERT INTO employees (employee_id) VALUES (1000);
- F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");
正确答案:C,E,F
第3题：

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）
- A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';
- B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
- C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
- D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
- E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
正确答案:D
第4题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）
- A、INSERT INTO employees VALUES (NULL, 'John', 'smith');
- B、INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');
- C、INSERT INTO employees VALUES ('1000, 'John', 'smith');
- D、INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');
- E、INSERT INTO employees (employee_id) VALUES (1000);
- F、INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');
正确答案:C,E,F
第5题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）
- A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
- B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
- C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
- D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;
正确答案:D
第6题：

The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement?（）
- A、Column definitions cannot be altered to add DEFAULT values.
- B、A change to the DEFAULT value affects only subsequent insertions to the table.
- C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
- D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
正确答案:B
第7题：

单选题
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_SEQEMP_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);

正确答案： C
解析：暂无解析
第8题：

单选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）
A
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

正确答案： D
解析：暂无解析
第9题：

单选题
Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to '555-8888' for John Doe?（）
A
INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')
B
UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'
C
DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)
D
UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1

正确答案： B
解析：暂无解析
第10题：

多选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）
A
INSERT INTO employees VALUES (NULL, 'John', 'smith');
B
INSERT INTO employees (first_name, last_name) VALUES ('John', 'smith');
C
INSERT INTO employees VALUES ('1000, 'John', 'smith');
D
INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, 'John', 'smith');
E
INSERT INTO employees (employee_id) VALUES (1000);
F
INSERT INTO employees ( employee_id, first_name, last_name, ) VALUES (1000, 'John','');

正确答案： E,C
解析：暂无解析
第11题：

多选题
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? （）
A
INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B
INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C
INSERT INTO employees VALUES ('1000','JOHN','NULL');
D
INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E
INSERT INTO employees (employee_id) VALUES (1000);
F
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);

正确答案： E,C
解析：暂无解析
第12题：

多选题
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? （）
A
INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B
INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C
INSERT INTO employees VALUES ('1000','JOHN','NULL');
D
INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E
INSERT INTO employees (employee_id) VALUES (1000);
F
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);

正确答案： E,D
解析：暂无解析
第13题：

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');
正确答案:A
第14题：

Which three statements inserts a row into the table?（）
- A、INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);
- B、INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);
- C、INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
- D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
- E、INSERT INTO employees (employee_id) VALUES (1000);
- F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
正确答案:C,E,F
第15题：

Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）
- A、CREATE INDEX NAME _IDX (first_name, last_name);
- B、CREATE INDEX NAME _IDX (first_name, AND last_name)
- C、CREATE INDEX NAME_IDX ON (First_name, last_name);
- D、CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
- E、CREATE INDEX NAME_IDX ON employees (First_name, last_name);
- F、CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
正确答案:E
第16题：

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, throughsubstitution 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);
正确答案:D
第17题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）
- A、UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
- B、UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
- C、UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
- D、UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
正确答案:D
第18题：

多选题
要在tbAddress表中插入记录，下面（）语句是正确的。
A
Insert Into tbAddress（strName，strTel）Values（萌萌，6545632）
B
Insert Into tbAddress（strName，strEmail）Values（萌萌，）
C
Insert Into tbAddress（strName，strEmail）Values（萌萌，NULL）
D
Insert Into tbAddress（strName，intAge）Values（萌萌，22）

正确答案： D,C
解析：暂无解析
第19题：

多选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）
A
INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
B
INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
C
INSERT INTO employees VALUES ( '1000', 'John', NULL);
D
INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
E
INSERT INTO employees (employee_id) VALUES (1000);
F
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');

正确答案： C,E
解析：暂无解析
第20题：

多选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）
A
INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
B
INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
C
INSERT INTO employees VALUES ( '1000', 'John', NULL);
D
INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
E
INSERT INTO employees (employee_id) VALUES (1000);
F
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');

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

多选题
要在users表中插入一条新记录，下面语句正确的是（）。
A
Insert Into users（id，user_name） Values（100， luhong）
B
Insert Into users（real_name，tel） Values（卢红，6545632）
C
Insert Into users（user_name，Email） Values（luhong，）
D
Insert Into users（user_name，Email） Values（luhong， NULL）

正确答案： B,C
解析：暂无解析
第22题：

单选题
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');

正确答案： A
解析：暂无解析
第23题：

单选题
A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) ); Which of the following INSERT statements will fail?（）
A
INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)
B
INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)
C
INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)
D
INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)

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

多选题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 empl

题目

相似考题

相关内容