Dump > Sql 1z0-007 > Sql#2

Which of the following correctly describe the LONG columns (choose all that apply): a) None of the choices. b) They have many of the characteristics of VARCHAR2 columns. c) They store variable-length character strings containing up to 2 gigabytes d) You can use them to store long text strings. 2,3,4 Which of the following correctly describe the restrictions on the use of LONG columns (choose all that apply): a) You cannot create an object type with a LONG attribute. b) LONG columns cannot appear in WHERE clauses. c) A table can contain only one LONG column. d) LONG columns cannot be indexed. 1,2,3,4 Oracle accepts all forms of expressions in all parts of all SQL statements. a) true b) true only in release 1 c) None of the choices. d) false D In Oracle, you can use any built-in function as an expression freely, even in a compound expression. a) true b) true as long as the expressions are ANSI SQL complaints c) None of the choices. d) false D You can use SQL expressions in which of the following places (choose all that apply):

a) The select list of the SELECT statement b) A condition of the WHERE clause and HAVING clause c) The VALUES clause of the INSERT statement d) The SET clause of the UPDATE statement 1,2,3,4