Multiple Chices Questions: 36. A subquery that executes once for each row in the
ID: 3905522 • Letter: M
Question
Multiple Chices Questions:
36. A subquery that executes once for each row in the outer query is known as a(n) ________.
a. nested subquery
b. correlated subquery
c. defined subquery
d. grouped subquery
37. The ________ returns the number of the day in MS Access.
a. TO_DATE() function
b. SYSDATE() function
c. DATE() function
d. TODAY() function
38. In Oracle, the ________ converts a date to a character string.
a. CONVERT function
b. TO_DATE function
c. TO_CHAR function
d. TO_STRING function
39. In the Oracle TO_DATE function, the code MON denotes the ________.
a. name of the month
b. first day of the week
c. number of months to a date
d. date of the last day of the month
40. The Oracle ________ returns the current date.
a. GETDATE function
b. SYSDATE function
c. CURRENT_DATE function
d. TO_DATE function
41. A relational view ________.
a. can only be used in certain SQL queries
b. cannot be used as a basis for reports
c. is recreated on demand each time it is invoked
d. allows users to see all columns and rows in a table
42. A ________ is a virtual table based on a SELECT query.
a. trigger
b. view
c. dictionary
d. index
43. The Oracle ________ returns the number of characters in a string value.
a. LEN function
b. LENGTH function
c. SUBSTR function
d. MID function
44. The Oracle ________ 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. NVL function
b. TO_CHAR function
c. DECODE function
d. CONVERT function
45. Oracle sequences ________.
a. can be deleted only under certain conditions
b. can be used anywhere a value is expected
c. are a data-type in the database
d. are tied to a table or a column
46. The ________ pseudo column is used to select the next available value from a sequence.
a. CURRVAL
b. NEXTVAL
c. INCREMENT
d. GET_NEXT
47. A(n) ________ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.
a. persistent stored module
b. permanent SQL module
c. SQL nested statement
d. program manipulation command
48. A ________ is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
a. stored procedure
b. stored function
c. index
d. trigger
49. ________ is a term used to describe an environment in which the SQL statement is generated at run time.
a. Embedded SQL
b. Dynamic SQL
c. Procedural SQL
d. Sequential SQL
50. After writing embedded SQL code within the host language instructions, the next step would be to ________.
a. use the embedded SQL statement to retrieve data from the database
b. compile the program using the host language compiler to create an object code module
c. transform the embedded SQL into specialized DBMS-specific procedure calls using a preprocessor
d. create an access plan module to run the embedded code at run time
Explanation / Answer
36. Option B: correlated subquery .
Explanation: Correlated subquery is known as a sub quey that executes once for each row in the outer query.
37. Option C: DATE() function
Explanation: DATE() function returns the number of day in MS Access
38. Option C: TO_CHAR function
Explanation: In Oracle, the TO_CHAR function converts a date to a character string.
39. Option A: Name of the month
Explanation: In the Oracle TO_DATE function, the code MON denotes the name of the month.
40. Option B: SYSDATE function
Explanation: The Oracle SYSDATE function returns the current date.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.