可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the structure of the EMPLOYEE


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? ()

  • 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', ' ')
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NA...

2、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhich UPDATE stat...

3、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOY...

4、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()ABCD

5、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) DEFAULT 'SA_REP'SAL NUMBERCOMM...

6、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements inserts...