网友您好，请在下方输入框内输入要搜索的题目：

搜题

题目内容（请给出正确答案）

提问人：网友lyh511 发布时间：2022-01-07

[主观题]

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_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‘,");

简答题官方参考答案（由简答题聘请的专业题库老师提供的解答）

查看官方参考答案

更多“Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2（25)LA…”相关的问题

第1题

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_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‘, ‘ ‘);

点击查看答案

第2题

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_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‘,‘‘);

点击查看答案

第3题

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2（25)LAST_NAME VARCHAR2（25)HIRE_DATE DATEWhich 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;

点击查看答案

第4题

Examine the data in the EMPLOYEES table:Which three subqueries work？（）

点击查看答案

第5题

Examine the structure of the EMPLOYEES table:You need to create an index called NAME_IDX o

n 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);

点击查看答案

第6题

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2（

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20)SAL NUMBERMGR_ID NUMBERDEPARTMENT_ID NUMBERYou 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 sequenceEMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variablesSAL: 2000MGR_ID: No valueDEPARTMENT_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);

点击查看答案

第7题

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（）

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

点击查看答案

第8题

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2（25)LAST_NAME VARCHAR2（25)HIRE_DATE DATEWhich 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‘);

点击查看答案

第9题

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2 （25)LAST_NAME VARCHAR2 （25)HIRE_DATE DATEWhich 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;

点击查看答案

账号：尚未登录

登录没有账号？去注册

搜题记录

联系客服

购买搜题卡

考试指南全部 >

全国2024自考10月考试科目及考试时间一览表 2024年10月全国各地自学考试时间及科目一览表 2024下半年自学考试本科报考时间和考试时间安排 2024下半年自学考试什么时候开始报名截止时间在几月 2024年10月全国各地自考本科科目一览表高升专自考是个怎么样的报名流程报名时间在几月江苏2024自考报名费收费标准费用大约是多少自考本科报名时间2024具体时间已公布自考本科报名时间是什么时候具体日期几月几日 2024年10月新生自考报名截止时间几号开始注册

购买搜题卡查看答案

购买前请仔细阅读《购买须知》

请选择支付方式

微信支付

支付宝支付

点击支付即表示你同意并接受《服务协议》和《购买须知》

立即支付已付款，但不能查看答案，请点这里登录即可>>

搜题卡使用说明

1. 搜题次数扣减规则：

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次