Multiple Choices Questions: (Database Design Course). 18. Which of the following
ID: 3905887 • Letter: M
Question
Multiple Choices Questions: (Database Design Course).
18. Which of the following can be classified as an outer join?
a. Old-style join
b. Cross join
c. Full join
d. Natural join
26. ROUND(value, p) is an example of a ________.
a. numeric function
b. string function
c. conversion function
d. date and time 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
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
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
18.Answer is C )full join
Explanation:
There are three types of OUTER joins:
The keyword OUTER is optional in all implementations that follow the standard, so FULL JOIN is the same as FULL OUTER JOIN.
20.Answer is a)numeric function
The ROUND() function returns a number rounded to a certain number of decimal places.
41.Answer is a. can only be used in certain SQL queries
42.Answer is b
In SQL, a view is a virtual table based on the result-set of an SQL statement.
45.Answer is b. can be used anywhere a value is expected
48.Answer is d.trigger
49.Answer is b.Dynamic SQL
An environment where the SQL statement is not known in advance and is generated at run time
50.Answer is C
transform the embedded SQL into specialized DBMS-specific procedure calls using a preprocessor
Hope this will help
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.