Which two statements about views are true? （）A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in

题目内容(请给出正确答案)

Which two statements about views are true? （）

A、A view can be created as read only.
B、A view can be created as a join on two or more tables.
C、A view cannot have an ORDER BY clause in the SELECT statement.
D、A view cannot be created with a GROUP BY clause in the SELECT statement.
E、A view must have aliases defined for the column names in the SELECT statement.

参考答案和解析

正确答案:A,B

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

多选题Which two statements are true about WHERE and HAVING clauses? （）AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING clause can be used to restrict groups only.EA WHERE clause CANNOT be used in a query of the query uses a HAVING clause.FA HAVING clause CANNOT be used in subqueries.

点击查看答案
第2题

多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view

点击查看答案
第3题

多选题Which two statements about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

点击查看答案
第4题

多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.

点击查看答案
第5题

多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA 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

点击查看答案
第6题

多选题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？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.

点击查看答案
第7题

多选题Which two statements are true regarding the ORDER BY clause? （）AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a column name followed by an expression in this clauseEYou can specify a combination of numeric positions and column names in this clause

点击查看答案

Which two statements about views are true? （）A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容