多项选择题

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’,‘’);

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
CITY_ADDRESS VARCHAR2(50)
STATE_ADDRESS VARCHAR2(50)
PROVINCE_ADDRESS VARCHAR2(50)
COUNTRY_ADDRESS VARCHAR2(50)
POSTAL_CODE VARCHAR2(12)
CUSTOMER_PHONE VARCHAR2(20)
A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?（）

A.WHERE lower(country_address) = "france"
B.WHERE lower(country_address) = 'france'
C.WHERE lower(country_address) IS 'france'
D.WHERE lower(country_address) = '%france%'
E.WHERE lower(country_address) LIKE %france%

单项选择题

In which scenario would an index be most useful?（）

A.The indexed column is declared as NOT NULL.
B.The indexed columns are used in the FROM clause.
C.The indexed columns are part of an expression.
D.The indexed column contains a wide range of values.

单项选择题

What is true regarding subqueries?（）

A.The inner query always sorts the results of the outer query.
B.The outer query always sorts the results of the inner query.
C.The outer query must return a value to the inner query.
D.The inner query returns a value to the outer query.
E.The inner query must always return a value or the outer query will give an error.