What do the parentheses denote? - ...ANSWER...The column
values for two individual rows
What happens in an UPDATE statement if the WHERE
clause is
... [Show More] omitted? - ...ANSWER...Every row in the table is
updated
Which action deletes all rows from a table? -
...ANSWER...Omitting the WHERE clause from a DELETE
statement
What is the purpose of using a SELECT statement? -
...ANSWER...To retrieve data
Which SQL statement retrieves all of the columns from the
Owners table? - ...ANSWER...SELECT * FROM Owners;
Which SQL statement tallies the number of different cities in
which record companies have been founded? -
...ANSWER...SELECT COUNT(DISTINCT city) FROM
recordcompany;
Which task does ORDER BY perform by default? -
...ANSWER...Sorting rows in ascending order
A database administrator of a movie rental company needs to
compile a list of movies released each year for a marketing
campaign.
Which SQL command will accomplish this? -
...ANSWER...SELECT YEAR, TITLE FROM MOVIE
GROUP BY YEAR;
A database manager plans to create a view of a table and has
these two elements:
• The CREATE VIEW privilege for the table
• A level of privilege for every column selected by the
SELECT
What else does the manager need to create this view? -
...ANSWER...The SELECT privilege for every column
referred to elsewhere in the statement
Refer to the given SQL statement.
SELECT product_name, product_number, mfg_city FROM
product;
Which statement, when added before this statement, generates
a view? - ...ANSWER...CREATE VIEW viewprod AS
What is the proper command to change a view? -
...ANSWER...ALTER VIEW
Refer to the given statement.
DROP VIEW EMPLOYEE;
What happens as a result of the execution of this statement to
the HRDB table on which the EMPLOYEE view is based? -
...ANSWER...The view is discarded.
How does Table 2 affect the returned results from Table 1 in a
left join? - ...ANSWER...All Table 1 results are returned,
regardless of whether a match is found in Table 2.
Which command functions as a RIGHT JOIN with the roles
of the tables reversed? - ...ANSWER...LEFT JOIN
Refer to the given SQL statement.
SELECT t1.*, t2.* FROM t1 LEFT JOIN t2 ON t1.i1 = t2.i2
What does the LEFT JOIN statement do? - ...ANSWER...It
selects all of the rows in Table 1 and the matching rows in
Table 2.
What is the difference between COUNT(*) and
COUNT(col_name) for specified column names? -
...ANSWER...COUNT(*) counts every row selected, and
COUNT(col_name) counts only non-null values.
Which function determines the total value for a column? -
...ANSWER...SUM() [Show Less]