Web and Database Development Questions

Question 1
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

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....