多項選擇題

Which two statements are true regarding views?（）

A.A subquery that defines a view cannot include the GROUP BY clause
B.A view that is created with the subquery having the DISTINCT keyword can be updated
C.A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
D.A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

你可能感興趣的試題

單項選擇題

What is the default value for the ENABLED attribute of a job or program when it is created? （）

A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D.PENDING
E. NULL

多項選擇題

Which three statements are true regarding subqueries?（）

A.Subqueries can contain GROUP BY and ORDER BY clauses
B.Main query and subquery can get data from different tables
C.Main query and subquery must get data from the same tables
D.Subqueries can contain ORDER BY but not the GROUP BY clause
E.Only one column or expression can be compared between the main query and subquery
F. Multiple columns or expressions can be compared between the main query and subquery

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

Which two statements are true regarding views?（）

你可能感興趣的試題

What is the default value for the ENABLED attribute of a job or program when it is created? （）

Which three statements are true regarding subqueries?（）

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