单项选择题

Which best describes an inline view? （）

A. a schema object
B. a subquery that can contain an ORDER BY clause
C. another name for a view that contains group functions
D. a subquery that is part of the FROM clause of another query

<上一题目录下一题>

热门试题

单项选择题The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）

A. no privileges
B. only the SELECT privilege
C. only the CONNECT privilege
D. all the privileges of a default user

多项选择题Which two tasks can you perform using only the TO_CHAR function? （）

A. convert 10 to 'TEN'
B. convert '10' to 10
C. convert 10 to '10'
D. convert 'TEN' to 10
E. convert a date to a character expression
F. convert a character expression to a date

单项选择题A data manipulation language statement （）.

A. completes a transaction on a table
B. modifies the structure and data in a table
C. modifies the data but not the structure of a table
D. modifies the structure but not the data of a table

单项选择题What does the FORCE option for creating a view do? （）

A. creates a view with constraints
B. creates a view even if the underlying parent table has constraints
C. creates a view in another schema even if you don't have privileges
D. creates a view regardless of whether or not the base tables exist

单项选择题Which are iSQL*Plus commands? （）

A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME