SQL QUIZ

Which SQL command is used to create a table?

• SELECT
• CREATE TABLE
• UPDATE TABLE
• MAKE TABLE

Which of these is an example of data?

• Monthly profit percentage
• Customer names in a spreadsheet
• A chart of sales growth
• A business decision

Which SQL command adds a new record?

• ADD
• INSERT INTO
• MAKE RECORD
• NEW ENTRY

A main problem with file system data processing is:

• Limited formats
• Data redundancy and inconsistency
• Too much automation
• Large file sizes

Which SQL clause is used to sort results?

• SORT
• ORDER BY
• GROUP BY
• ARRANGE

In an ER diagram, a rectangle represents:

• Entity
• Attribute
• Relationship
• Primary Key

Which SQL clause is used to filter groups after grouping?

• WHERE
• HAVING
• ORDER BY
• LIMIT

Which of these is not a function of a DBMS?

• Store data
• Secure data
• Retrieve data
• Design websites

Which aggregate function finds the largest value?

• MAX
• SUM
• COUNT
• AVG

Which level of data abstraction deals with how data is stored physically?

• Physical level
• View level
• Logical level
• Conceptual level