Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
|
At minimum, what must you specify when creating a database in SQL Server Management Studio?
a. Database name b. Database size c. File Locations |
a. Database name
|
|
|
A column's data type determines the kind of data the column can store and the storage size requirements.
a. True b. False |
a. True
|
|
|
SQL Server Enterprise Manager is limited to providing access to a single database.
a. True b. False |
b. False
|
|
|
What should you expect as a result when you execute the following query?
SELECT* a. All columns and rows from all tables in the database. b. All columns and rows from the first table in the database. c. A list of tables in the database d. An error message |
d. An error message
|
|
|
You execute a query to return three specified columns from a table. What determines the order in which columns are returned by a SELECT query?
a. The order the columns are specified in the SELECT clause. b. The order in which the columns appear in the table c. Alphabetical order, by column name. d. The order specified in the ORDER BY clause. |
a. The order the columns are specified in the SELECT clause.
|
|
|
How must you modify this query to sort customers by City?
SELECT CustName, City, State FROM Customer ORDER BY CustID a. Add a WHERE clause to the query b. Specify either ASC or DESC in the SELECT clause after City. c. List City first in the SELECT list. d. Add an ORDER BY clause. |
d. Add an ORDER BY clause.
|
|
|
The AnnualBonus table includes the following columns...
-EmpID -Year -Amount EmpID and Year are character type columns. You want to run a query that returns EmpID and the bonus amount for the year 2001. The largest bonuses should be listed first. Which query should you use? a. SELECT EmpID, Amount FROM AnnualBonus Where Year='2001' b. SELECT Amount, EmpID FROM AnnualBonus WHERE Year='2001' c. SELECT EmpID, Amount FROM AnnualBonus WHERE Year='2001' ORDER BY AnnualBonus DESC d. SELECT EmpID, Amount FROM AnnualBonus WHERE Year='2001' ORDER BY AnnualBonus ASC |
c. SELECT EmpID, Amount FROM AnnualBonus WHERE Year='2001' ORDER BY AnnualBonus DESC
|
|
|
You want to run a query that returns employee first name, last name, and city from the Employee table. The result must be sorted by city and then, within the city, by last name. Which query should you use?
a. SELECT city, firstname, lastname FROM Employee b. SELECT city, lastname, firstname FROM Employee c. SELECT city, firstname, lastname FROM Employee ORDER BY city ORDER BY lastname d. SELECT city, firstname, lastname FROM Employee ORDER BY city, lastname |
d. SELECT city, firstname, lastname FROM Employee ORDER BY city, lastname
|
|
|
Unless otherwise specified, columns listed in an ORDER BY clause sort in ascending order.
a. True b. False |
a. True
|
|
|
The CurrentContact table contains the following data:
ID ConID TakenBy 1 1334 FM22 2 2343 JS10 3 1001 MS01 4 1454 MS01 5 0989 JS10 6 0989 MS01 You execute the following query.... SELECT * FROM CurrentContact where ID <=2 OR ID>=5 How many rows should the result return? a. 0 b. 2 c. 4 d. 6 |
c. 4
|
