违法和不良信息举报 联系客服
免费注册 登录

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

题目
多选题
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',);

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? （）

  • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
  • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
  • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
  • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'

正确答案:C

第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 data in the EMPLOYEES and DEPARTMENTS tables:

EMPLOYEES

EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY

EMPLOYEE_ID

101 Smith 20 120 SA_REP 4000

102 Martin 10 105 CLERK 2500

103 Chris 20 120 IT_ADMIN 4200

104 John 30 108 HR_CLERK 2500

105 Diana 30 108 IT_ADMIN 5000

106 Smith 40 110 AD_ASST 3000

108 Jennifer 30 110 HR_DIR 6500

110 Bob 40 EX_DIR 8000

120 Ravi 20 110 SA*DIR 6500

DEPARTMENTS

DEPARTMENT_ID DEPARTMENT_NAME

10 Admin

20 Education

30 IT

40 Human Resources

Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:

CREATE TABLE departments

(department_id NUMBER PRIMARY KEY,

department _ name VARCHAR2(30));

CREATE TABLE employees

(EMPLOYEE_ID NUMBER PRIMARY KEY,

EMP_NAME VARCHAR2(20),

DEPT_ID NUMBER REFERENCES

departments(department_id),

MGR_ID NUMBER REFERENCES

employees(employee id),

MGR_ID NUMBER REFERENCES

employees(employee id),

JOB_ID VARCHAR2(15).

SALARY NUMBER);

ON the EMPLOYEES,

On the EMPLOYEES table, EMPLOYEE_ID is the primary key.

MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.

Examine this DELETE statement:

DELETE

FROM departments

WHERE department id = 40;

What happens when you execute the DELETE statement?（）


参考答案：B

第4题：

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）

  • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
  • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
  • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
  • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

正确答案:C

第5题：

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

第6题：

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

第7题：

You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）

  • A、You get an error because of a primary key violation.
  • B、The data and structure of the EMPLOYEES table are deleted.
  • C、The data in the EMPLOYEES table is deleted but not the structure.
  • D、You get an error because the statement is not syntactically correct.

正确答案:C

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容