They can accept only one argument.
They can be nested up to only two levels.
They can return multiple values of more than one data type.
They can be used in SELECT, WHERE, and ORDER BY clauses.
They can modify the data type of the argument that is referenced.
They can accept a column name, expression, variable name, or a user-supplied constant as arguments.
第1题:
Which two statements about subqueries are true? ()
第2题:
Which three statements about subqueries are true?()
第3题:
Which two statements are true regarding subqueries? ()
第4题:
Which two statements are true about simple views?()
第5题:
Which two statements are true about a job chain?()
第6题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第7题:
Which four are attributes of single row functions? ()
第8题:
A job chain can contain a nested chain of jobs
The jobs in a job chain cannot have more than one dependency
A job of the CHAIN type can be run using event-based or time-based schedules
The jobs in a job chain can be executed only by using the events generated by the Scheduler
第9题:
A subquery can retrieve zero or more rows
Only two subqueries can be placed atone level
A subquery can be used only in SQL query statements
A subquery can appear on either side of a comparison operator
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
第10题:
You can use aggregate functions in any clause of a SELECT statement.
You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
You can use aggregate functions on a table, only by grouping the whole table as one single group.
You cannot group the rows of a table by more than one column while using aggregate functions.
第11题:
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
A subquery can be used only in SQL query statements.
Subqueries CANNOT be nested by more than two levels.
A subquery CANNOT be used in an SQL query statement that uses group functions.
When 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.
第12题:
They accept only a single argument
They can be nested only to two levels
Arguments can only be column values or constants
They always return a single result row for every row of a queried table
They can return a data type value different from the one that is referenced
第13题:
Which three statements about subqueries are true? ()
第14题:
Which two are true about aggregate functions? ()
第15题:
Which two statements about subqueries are true?()
第16题:
Which three statements are true regarding single-row functions?()
第17题:
Which three statements are true regarding the data types in Oracle Database 10g/11g?()
第18题:
Which two statements are true regarding listeners()
第19题:
Which two statements are true regarding single row functions?()
第20题:
A single row subquery can retrieve only one column and one row.
A single row subquery can retrieve only one row but many columns.
A multiple row subquery can retrieve multiple rows and multiple columns.
A multiple row subquery can be compared by using the “>” operator.
A single row subquery can use the IN operator.
A multiple row subquery can use the “=” operator.
第21题:
Both USING and ON clauses can be used for equijoins and nonequijoins
Amaximum of one pair of columns can be joined between two tables using the ON clause
The ON clause can be used to join tables on columns that have different names but compatible data types
The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
第22题:
a server instance can be associated with multiple machines
a machine can be associated with multiple server instance
a server instance can be associated with only a single machine
a machine can be associated with only one server instance
第23题:
Views can be created as read only.
Views are data segments like tables.
Views can be created on the basis of more than one table.
Data manipulation language (DML) operations cannot be performed on views.