A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.
第1题:
Which two statements are true about WHERE and HAVING clauses? ()
第2题:
Which two statements are true regarding the ORDER BY clause? ()
第3题:
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
第4题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第5题:
Which two statements about views are true?()
第6题:
Which two statements about subqueries are true? ()
第7题:
Which best describes an inline view?()
第8题:
Which two statements are true regarding views?()
第9题:
Which two statements are true about simple views?()
第10题:
View this parameter setting in your database: DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command: CREATE TABLESPACE USERS; Which two statements are true about the USERS tablespace?()