CIW CIW Database Design & SQL 2

Question 1

Which SQL statement is used to add a new record to a database table?

Accepted Answer

INSERT INTO

Answer

INSERT INTO specifies the target table and the values to insert, creating a new row in the database.

Question 2

What does the SQL GROUP BY clause do?

Accepted Answer

Groups rows sharing a common value so aggregate functions can be applied to each group

Answer

GROUP BY arranges identical data into groups, enabling functions like COUNT, SUM, and AVG to operate on each group independently.

Question 3

Which data type is most appropriate for storing a web URL in a database column?

Accepted Answer

VARCHAR

Answer

VARCHAR (variable-length character string) is used for text data like URLs, allowing flexible storage up to a defined maximum length.

Question 4

What is an SQL transaction used for?

Accepted Answer

To group multiple SQL statements so they execute as a single atomic unit

Answer

A transaction ensures that a series of SQL operations either all succeed (COMMIT) or all fail (ROLLBACK), maintaining data consistency.

Question 5

Which SQL command removes all rows from a table without deleting the table structure?

Accepted Answer

TRUNCATE

Answer

TRUNCATE quickly removes all rows from a table and resets auto-increment counters, but preserves the table's schema for future use.

CIW Certified Internet Web Professional Practice Practice Test