Q&A Hero

Q: _____________functions extract a value of a given data type and convert it to the equivalent value in another data type.

Q: Oracle uses the_________ function to extract the various parts of a date.

Q: A(n)_____________ subquery is a subquery that executes once for each row in the outer query.

Q: The use of the__________ operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

Q: The IN subquery uses a(n) ____________operator.

Q: The__________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

Q: When using a subquery, the output of a(n)__________ query is used as the input for the outer query.

Q: The_____________ determines the common attribute or attributes by looking for identically named attributes and compatible data types.

Q: An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2____________ (common-column).

Q: ____________is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.a. %ROWCOUNTb. %NOTFOUNDc. %FOUNDd. %ISOPEN

Q: Oracle recommends______________ for creating audit logs.a. triggersb. stored proceduresc. stored functionsd. tables

Q: The PL/SQL block starts with the_________ section.a. ISb. OPENc. DECLAREd. BEGIN

Q: 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.a. cursor-style processingb. stored proceduresc. embedded SQLd. Procedural Language SQL

Q: A(n)_________ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.a. PSMb. PLSc. SQL Statementd. PMR

Q: The________ pseudo-column is used to select the next value from a sequence.a. CURRVALb. NEXTVALc. NEXTd. GET_NEXT

Q: Which of the following is a feature of oracle sequences?a. Oracle sequences are tied to columns and tables.b. Oracle sequences generate a character string that can be assigned to tables.c. An oracle sequence uses the identity column anytime.d. An oracle sequence can be created and deleted roperty to automatically number rows.

Q: The Oracle equivalent to an MS Access AutoNumber is a(n)___________ .a. auto-numberb. sequencec. TO_NUMBER functiond. trigger

Q: The ______________operator could be used in place of MINUS if the DBMS does not support it.a. INb. NOT INc. ANDd. UNION

Q: The _____________operator could be used in place of INTERSECT if the DBMS does not support it.a. INb. OFc. ANDd. UNION

Q: Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator? a. 0 b. 2 c. 8 d. 10

Q: The________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.a. UNIONb. UNION ALLc. INTERSECTd. MINUS

Q: Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator? a. 0 b. 2 c. 7 d. 10

Q: Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator? a. 7 b. 10 c. 15 d. 17

Q: Assume a designer is using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator? a. 7 b. 10 c. 15 d. 17

Q: The syntax for the UNION query is__________ .a. query + queryb. UNION (query, query)c. UNION: query queryd. query UNION query

Q: The _______________statement combines rows from two queries and excludes duplicates.a. UNIONb. UNION ALLc. INTERSECTd. MINUS

Q: The _____________data type is compatible with NUMBER.a. VARCHAR(15)b. SMALLINTc. DATEd. CHAR(10)

Q: The Oracle_____________ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.a. NVLb. TO_CHARc. DECODEd. CONVERT

Q: The_______________- data type is considered compatible with VARCHAR(35).a. DATEb. INTc. TINYINTd. CHAR(15)

Q: "Unioncompatible" means that the_________________ .a. names of the relation attributes can be different, but the data types must be alikeb. names of the relation attributes must be the same, but the data types can be differentc. names of the relation attributes must be the same and their data types must be aliked. number of attributes must be the same, but the names and data types can be different

Q: _______________is a relational set operator.a. MINUSb. PLUSc. ALLd. EXISTS

Q: When using the Oracle TO_NUMBER function to convert a character string into a number,_______________ represents a digit.a. 0b. 9c. $d. #

Q: _________________is a string function that returns the number of characters in a string value.a. LENGTHb. SUBSTRINGc. CONCATd. UCASE

Q: The Oracle string concatenation function is_______________ .a. CONCATb. +c. ||d. &&

Q: In Oracle, the __________function converts a date to a character string.a. CONVERT()b. TO_DATEc. TO_CHAR()d. TO_STRING()

Q: The Oracle__________ function returns the current date.a. DATEb. SYSDATEc. CURRENT_DATEd. TO_DATE

Q: When using the Oracle TO_DATE function, the code____________ represents a three-letter month name.a. MONb. MM3c. MONTHd. MM

Q: The_____________ function returns the current system date in MS Access.a. TO_DATE()b. SYSDATE()c. DATE()d. TODAY()

Q: In a subquery, the ___________query is executed first.a. leftb. rightc. innerd. outer

Q: Which of the following is a feature of a correlated subquery? a. The inner subquery executes first. b. The outer subquery initiates the process of execution in a subquery. c. The inner subquery initiates the process of d. The outer subquery executes independent execution in a subquery. of the inner subquery.

Q: In subquery terminology, the first query in the SQL statement is known as the____________ query.a. outerb. leftc. innerd. base

Q: A________ is a query inside a query.a. subqueryb. range queryc. joind. set query

Q: In the context of SELECT subquery types, a_______________ is returned when an UPDATE subquery is used.a. NULLb. single valuec. list of valuesd. virtual table

Q: All join conditions are connected through a(n)_____________ logical operator.a. NORb. ORc. ANDd. NOT

Q: A ___________join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.a. naturalb. crossc. full outerd. left outer

Q: The syntax for a left outer join is .a. SELECT column-listFROM table1 OUTER JOIN table2 LEFTWHERE join-conditionb. SELECT column-listFROM table1 LEFT [OUTER] JOIN table2ON join-conditionc. SELECT column-listWHERE LEFT table1 = table 2d. SELECT column-listFROM table1 LEFT table2 [JOIN]WHERE join-condition

Q: 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.a. outerb. innerc. equi-d. cross

Q: The ANSI standard defines____________ type(s) of outer join(s)a. oneb. twoc. threed. four

Q: If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause. a. OF b. USING c. HAS d. JOIN ON

Q: A(n)__________ join will select only the rows with matching values in the common attribute(s).a. naturalb. crossc. fulld. outer

Q: How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18? a. 8 b. 18 c. 26 d. 144

Q: The statement SELECT * FROM T1, T2 produces a(n)___________ join.a. crossb. naturalc. equi-d. full

Q: When using a(n)____________ join, only rows that meet the given criteria are returned.a. fullb. innerc. outerd. set

Q: The following SQL statement uses a(n)____________ .SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;a. set operatorb. natural joinc. "oldstyle" joind. procedural statement

Q: MySQL allows multiple triggering conditions per trigger. a. True b. False

Q: A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.a. Trueb. False

Q: A trigger definition consists of the triggering timing, the triggering event, the triggering level, and the triggering action. a. True b. False

Q: A relational join operation merges rows from two tables. a. True b. False

Q: "Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion. a. True b. False

Q: A stored function is another name for a stored procedure. a. True b. False

Q: Cursor-style processing involves retrieving data from the cursor, one row at a time. a. True b. False

Q: The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables. a. True b. False

Q: An explicit cursor must return two or more rows. a. True b. False

Q: An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value. a. True b. False

Q: Cursors are held in a reserved memory area in the client computer. a. True b. False

Q: Stored procedures are executed using the EXEC command.a. Trueb. False

Q: Variables can be declared inside a stored procedure. a. True b. False

Q: Stored procedures must have at least one argument. a. True b. False

Q: Stored procedures help reduce code duplication by means of code isolation and code sharing. a. True b. False

Q: One of the disadvantages of stored procedures is that they increase network traffic. a. True b. False

Q: One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions. a. True b. False

Q: Just like database triggers, stored procedures are stored in the database. a. True b. False

Q: To test a trigger, one should use the EXECUTE TRIGGER comman d. a. True b. False

Q: Each statement inside the PL/SQL code must end with a period ("."). a. True b. False

Q: A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords. a. True b. False

Q: Triggers can only be used to update table values. a. True b. False

Q: A trigger is executed as part of the transaction that triggered it. a. True b. False

Q: A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. a. True b. False

Q: Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment. a. True b. False

Q: The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS. a. True b. False