You can add a row using SQL in a database with which of the following? ADD MAKE CREATE INSERT TRUE ANSWER : ? YOUR ANSWER : ?
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False TRUE ANSWER : ? YOUR ANSWER : ?
What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') Find the sailor IDs of at least one sailor who have reserved red boats but not green boats None of These Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats 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 : ?
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; TRUE ANSWER : ? YOUR ANSWER : ?
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); TRUE ANSWER : ? YOUR ANSWER : ?
The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 prints 50 prints garbage is illegal TRUE ANSWER : ? YOUR ANSWER : ?
SUM, AVG, MIN, and MAX can only be used with numeric columns. True False TRUE ANSWER : ? YOUR ANSWER : ?
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True TRUE ANSWER : ? YOUR ANSWER : ?
What is a view? None of these A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. A view is a special stored procedure executed when certain event occurs. A view is a database diagram. TRUE ANSWER : ? YOUR ANSWER : ?