單項選擇題

Which statement is true regarding the INTERSECT operator?（）

A.It ignores NULL values
B.Reversing the order of the intersected tables alters the result
C.The names of columns in all SELECT statements must be identical
D.The number of columns and data types must be identical for all SELECT statements in the query

你可能感興趣的試題

單項選擇題

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）

A.CREATE SYNONYM ord FOR orders; This command is issued by OE
B.CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
C.CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
D.CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator

多項選擇題

When does a transaction complete?（）

A.when a DELETE statement is executed
B.when a ROLLBACK command is executed
C.when a PL/SQL anonymous block is executed
D.when a data definition language (DDL) statement is executed
E.when a TRUNCATE statement is executed after the pending transact ion

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

Which statement is true regarding the INTERSECT operator?（）

你可能感興趣的試題

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）

When does a transaction complete?（）

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