1.A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.
The correct answer is: outer
2.A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
The correct answer is: SELECT
3.SQL requires the use of the _____ command to enter data into a table.
The correct answer is:
4.How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?
The correct answer is: 144
5.A(n) _____ join will select only the rows with matching values in the common attribute(s).
The correct answer is: natural
6.In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.
The correct answer is: Procedural Language SQL
7.A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.
The correct answer is: cross
8.No matter what language you use, if it contains embedded SQL statements, it is called the _____ language.
The correct answer is: host
9.A(n) _____ is a query that is embedded (or nested) inside another query.
The correct answer is: subquery
10._____ is a relational set operator.
The correct answer is: EXCEPT
11.According to the rules of precedence, which of the following computations should be completed first?
The correct answer is: Operations within parentheses
12.A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.
The correct answer is: persistent storage module (PSM)
13.All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.
The correct answer is: ALTER
14.In Oracle, _____ retrieves the current value of a sequence.
The correct answer is: CURRVAL
15.A(n) _____ cursor is automatically created in procedural SQL when the SQL statement returns only one value.
The correct answer is: implicit
16.A table can be deleted from the database by using the _____ TABLE command.
The correct answer is: DROP
17.Oracle recommends _____ for creating audit logs.
The correct answer is: triggers
18._____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.
The correct answer is: %FOUND
19._____ is a string function that returns the number of characters in a string value.
The correct answer is: LENGTH
20.A(n) _____ is an alternate name given to a column or table in any SQL statement.
The correct answer is: alias
Other Links:
See other websites for quiz:
Check on QUIZLET