Q. Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?

View solution

Q. What is the facility that allows nesting one select statement into another?

View solution

Q. Which of these operators does not perform relative value comparisons?

View solution

Q. To combine multiple retrievals, which keyword is used to write several SELECT statements between them?

View solution

Q. Issuing ‘SELECT’ on a MERGE table is like _____________

View solution

Q. In Perl DBI, functions are called ______________

View solution

Q. Which variable is used as a handle to an open file?

View solution

Q. The variable that is a handle to a database object is ______________

View solution

Q. Which variable returns code from operations that return true or false?

View solution

Q. The statement to remove indexes on tables is ______________

View solution

Q. What allows nesting one select statement into another?

View solution

Q. The operator that does not perform relative-value comparisons is ______________

View solution

Q. The key declares that an index in one table is related to that in another is called _____________

View solution

Q. Foreign keys can handle deletes and updates.

View solution

Q. The generic handle whose meaning depends on context is ______________

View solution

Q. The non handle array representing a row of values is ______________

View solution

Q. The return value from operations returning a row count is ______________

View solution

Q. While using DBI API functions are called and pointers to structures are used.

View solution

Q. Which mode of search is the search string parsed into words and the search looks for rows?

View solution

Q. The indicator of presence/absence of a word in search is used in the mode ______________

View solution