Which operator performs pattern matching? EXISTS operator BETWEEN operator None of these LIKE operator TRUE ANSWER : ? YOUR ANSWER : ?
You can add a row using SQL in a database with which of the following? MAKE ADD INSERT CREATE TRUE ANSWER : ? YOUR ANSWER : ?
Which SQL keyword is used to retrieve a maximum value? MOST MAX UPPER TOP TRUE ANSWER : ? YOUR ANSWER : ?
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False TRUE ANSWER : ? YOUR ANSWER : ?
A dynamic view is one whose contents materialize when referenced. False True TRUE ANSWER : ? YOUR ANSWER : ?
Find the name of cities with all entries whose temperature is in the range of 71 and 89 SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; SELECT * FROM weather WHERE temperature NOT IN (71 to 89); SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature NOT IN (71 and 89); TRUE ANSWER : ? YOUR ANSWER : ?
The result of a SQL SELECT statement is a ________ . report form table file TRUE ANSWER : ? YOUR ANSWER : ?
The Microsoft Access wildcards are ____ and ____ . asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) TRUE ANSWER : ? YOUR ANSWER : ?