Question
State the purpose of the following SQL keywords: VALUES
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables.
Question 2
Sun's branded version of Apache Derby, a pure Java database, is called ________.
a. JSQLb. JavaBase
c. DBJ
d. Java DB
Question 3
The SQL keywords ASC and DESC are used when ________ rows.
a. sorting
b. deleting
c. updating
d. creating
Question 4
Which of the following is not a primary namespace in ADO.NET.
a. System.Data
b. System.Data.OleDb
c. System.Data.CF
d. System.Data.SqlClient
Question 5
State the purpose of the following SQL keywords: UPDATE
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables
Question 6
State the purpose of the following SQL keywords: DESC
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables
Question 7
State the purpose of the following SQL keywords: SET
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables.
Question 8
A relational database table consists of rows and ________.
a. rows
b. primary keys.
c. columns
d. result sets
Question 9
The ________ is a logical representation of the data that allows the relationships between the data to be considered without concerning oneself with the physical implementation of the data structures.
a. relational database model
b. rational database model
c. SQL Server diagram
d. Common Gateway Interface
Question 10
SQL is a ________.
a. relational database
b. non-relational database
c. language for creating database queries and manipulating data
d. personal relational database
Question 11
State the purpose of the following SQL keywords: LIKE
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables
Question 12
There is a(n) ________ relationship between a primary key and its corresponding foreign key.
a. one-to-one
b. one-to-many
c. many-to-one
d. inverse
Question 13
State the purpose of the following SQL keywords: ON
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables
Question 14
The ________ SQL keyword is used to change existing data in a table.
a. EDIT
b. UPDATE
c. CHANGE
d. MODIFY
Question 15
State the purpose of the following SQL keyword: ASC
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is usedin the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables
Question 16
State the purpose of the following SQL keywords: FROM
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables.
Question 17
MySQL functions on the following platform:
a. Windows
b. Linux
c. UNIX
d. All of the above
Question 18
The following SQL query:
SELECT * FROM TableName
a. generates an error.
b. selects all rows from the table TableName.
c. selects all columns from the table TableName.
d. selects all rows and columns from the table TableName
Question 19
State the purpose of the following SQL keywords: INSERT
a. Specifies that data should be sorted in ascending (lowest to highest) order. It is used in the ORDER BY clause.
b. Specifies which tables should be used in a SQL statement.
c. Specifies that data should be sorted in descending (highest to lowest) order. It is used in the ORDER BY clause.
d. Adds a new row into a database table.
e. Used for pattern matching with wildcard characters (*, ?, % and _). Selects data that satisfies the pattern string.
f. Modifies data in a table.
g. Specifies the columns to change when updating a row or set of rows in a table.
h. Specifies the values to change when updating a row or set of rows in a table.
i. Specifies the columns that will be used to join tables.
Question 20
A(n) ________ provides mechanisms for storing and organizing data in a manner that facilitates sophisticated queries.
a. database
b. database management system
c. Structured Query Language
d. ADO.NET
1. What does SQL stand for?
Structured Question Language
Structured Query Language
Strong Question Language
2. Which SQL statement is used to extract data from a database?
SELECT
OPEN
GET
EXTRACT
3. Which SQL statement is used to update data in a database?
SAVE
SAVE AS
MODIFY
UPDATE
4. Which SQL statement is used to delete data from a database?
DELETE
REMOVE
COLLAPSE
5. Which SQL statement is used to insert new data in a database?
INSERT INTO
ADD RECORD
ADD NEW
INSERT NEW
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
EXTRACT FirstName FROM Persons
SELECT Persons.FirstName
SELECT FirstName FROM Persons
7. With SQL, how do you select all the columns from a table named "Persons"?
SELECT [all] FROM Persons
SELECT Persons
SELECT * FROM Persons
SELECT *.Persons
8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName<>'Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
9. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName='%a%'
10. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
False
True
11. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT FirstName='Peter', LastName='Jackson' FROM Persons
12. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
13. Which SQL statement is used to return only different values?
SELECT DIFFERENT
SELECT UNIQUE
SELECT DISTINCT
14. Which SQL keyword is used to sort the result-set?
SORT BY
ORDER BY
SORT
ORDER
15. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons ORDER FirstName DESC
16. With SQL, how can you insert a new record into the "Persons" table?
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT ('Jimmy', 'Jackson') INTO Persons
17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
INSERT INTO Persons (LastName) VALUES ('Olsen')
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName
18. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
19. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE ROW FirstName='Peter' FROM Persons
DELETE FirstName='Peter' FROM Persons
20. With SQL, how can you return the number of records in the "Persons" table?
SELECT COLUMNS(*) FROM Persons
SELECT COUNT(*) FROM Persons
SELECT COLUMNS() FROM Persons
SELECT COUNT() FROM Persons
Solution Preview
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
Question 1: The answer is option D.Question 2: The answer is option D.
Question 3: The answer is option A.
Question 4: The answer is option C.
Question 5: The answer is option F.
Question 6: The answer is option C.
Question 7: The answer is option H....