SQL Final Assessment

Front

Can this query be executed and is it useful (according to the table and column definitions)?
SELECT CTITLE, CID
FROM COURSES
WHERE CID='7820'

Back

Query can be executed and makes sense (according to the table and column definitions).

Front

Which question corresponds best to the following query?
SELECT *
FROM COURSES
WHERE CTITLE LIKE '%SQL%'
AND CID NOT IN ('7800','7820')
Options:
1. Give the first row from the course table for which the column CTITLE equals *SQL* and for which the value in the column CID is neither 7800, nor 7820.
2. Give all rows from the course table for which the column CTITLE equals *SQL* and for which the value in the column CID is neither 7800, nor 7820.
3. Give the first row from the course table for which the column CTITLE contains the character sequence SQL and for which the value in the column CID is neither 7800, nor 7820.
4. Give all rows from the course table for which the column CTITLE contains the character sequence SQL and for which the value in the column CID is neither 7800, nor 7820.
5. Give the first row from the course table for which the column CTITLE equals *SQL* and for which the value in the column CID does not lie between 7800 and 7820.

Back

Give all rows from the course table for which the column CTITLE contains the character sequence SQL and for which the value in the column CID is neither 7800, nor 7820.

Front

Which question corresponds best to the following query?
SELECT CID, CDUR ‐1,' =PRICE' FROM
COURSES
ORDER BY2
Options:
Select three columns from the COURSES table, of which the third one has a constant value, i.e.
“= PRICE”. Leave an empty line after every second line.
,
Select two columns from the COURSES table, the second one gets as title “= PRICE”. Sort the
data according to the second column, in ascending order.
,
Select three columns from the COURSES table, of which the third one has a constant value, i.e.
“= PRICE”. Sort the data according to the second column, in ascending order.
,
Select two columns from the COURSES table, of which the second one has a constant value, i.e.
“= PRICE”. Sort the data according to the second column, in ascending

Back

Select three columns from the COURSES table, of which the third one has a constant value, i.e.
“= PRICE”. Sort the data according to the second column, in ascending order.

Front

Which table will be the result of the query? SELECT S_CID, MAX (SNO) FROM SESSIONS GROUP BY S_CID ORDER BY 2

Back

Front

Which table will be the result of the query?
SELECT SNO, SDATE
FROM SESSIONS
WHERE DAYNAME(SDATE) =‘Monday’
AND DAYNAME(SDATE) =‘Tuesday’

Back

Front

Which table will be the result of the query?
SELECT MAX(S_CID) ASS_CID FROM
SESSIONS
GROUP BY SINSTRUCTOR
HAVING COUNT(SDATE) > 1

Back

Front

Which table will be the result of the query? SELECT DISTINCT S_CID FROM SESSIONS WHERE SCANCEL ISNULL

Back

Front

You can add a row using SQL in a database with which of the following? ADD, CREATE, INSERT, MADE

Back

INSERT

Front

The command to remove rows from a table 'CUSTOMER' is:

Back

DELETE FROM CUSTOMER WHERE

Front

The SQL WHERE clause:

Back

limits the row data are returned