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