單項(xiàng)選擇題

The CUSTOMERS table has these columns:

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

A. SELECT customer_id, customer_name   FROM customers   WHERE postal_code CONTAINS NULL;
B. SELECT customer_id, customer_name   FROM customers   WHERE postal_code = '________';
C. SELECT customer_id, customer_name   FROM customers   WHERE postal_code IS NULL;
D. SELECT customer_id, customer_name   FROM customers   WHERE postal code IS NVL;
E. SELECT customer_id, customer_name   FROM customers   WHERE postal_code = NULL;

你可能感興趣的試題

單項(xiàng)選擇題

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.

多項(xiàng)選擇題

Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement?（）

A. You cannot roll back this statement.
B. All pending transactions are committed.
C. All views based on the DEPT table are deleted.
D. All indexes based on the DEPT table are dropped.
E. All data in the table is deleted, and the table structure is also deleted.
F. All data in the table is deleted, but the structure of the table is retained.
G. All synonyms based on the DEPT table are deleted.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

The CUSTOMERS table has these columns: Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

你可能感興趣的試題

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

The CUSTOMERS table has these columns:

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement?（）