Information Management Pre-Fi Quiz

1. What is a query?

• A type of computer virus

• A specific request for data manipulation

• A type of computer hardware

• A type of computer software

Answer explanation

A query is a specific request for data manipulation.

2. What does SQL stand for?

• Simple Query Language

• Structured Query Language

• System Query Language

• Sequential Query Language

Answer explanation

SQL stands for Structured Query Language

3. What are some commands in SQL?

• Create database and table structures

• Play music

• Cook dinner

• Write a book

Answer explanation

Commands in SQL include creating database and table structures.

4. What are some popular Database Management Tools?

• Microsoft Excel

• Microsoft Word

• Microsoft SQL Server

• Microsoft PowerPoint

Answer explanation

Popular Database Management Tools include Microsoft SQL Server

5. What are some SQL data types?

• Exact numeric, approximate numeric, and date and time

• Exact numeric, approximate numeric, and character strings

• Exact numeric, binary strings, and other data types

• Approximate numeric, date and time, and binary strings

Answer explanation

SQL data types include exact numeric, approximate numeric, and date and time.

6. What are some SQL operators?

• Arithmetic and comparison

• Arithmetic and logic

• Comparison and logic

• Arithmetic, comparison, and logic

Answer explanation

SQL operators include arithmetic and comparison.

7. What is the purpose of SQL?

• To create viruses

• To manipulate data

• To play games

• To send emails

Answer explanation

The purpose of SQL is to manipulate data.

8. What is Microsoft SQL Server?

• A type of computer virus

• A popular Database Management Tool

• A type of computer hardware

• A type of computer software

Answer explanation

Microsoft SQL Server is a popular Database Management Tool.

9. What are some character string data types in SQL?

• Char, text, and varchar

• Char, text, and binary

• Char, binary, and image

• Text, varchar, and image

Answer explanation

Character string data types in SQL include char, text, and varchar.

10. What is the purpose of a query in SQL?

• To create a database

• To manipulate data

• To play games

• To write a book

Answer explanation

The purpose of a query in SQL is to manipulate data.