Data and Database: SQL

Which is the best example of a primary key?

• Driver's License Number
• Home Runs Hit
• Price
• First and Last Name

Data _____ helps ensure that an incorrect entry isn't made.

• validation
• checks
• accuracy
• integrity

The front-end of a database is known as a _____.

• form
• report
• query
• website

The following are functions of a DBMS except

• Creating database
• Processing data
• Creating and processing forms
• Administrating database

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

A database application can perform which of the following activities?

• Add records
• Display / read records
• Update records
• All of the above

A relational database consists of a collection of

• Field
• Record
• Table
• Keys

The term attribute refers to a ________ of a table

• Record
• Foreign key
• Primary key
• Field

The term _______ is used to refer a row

• Record
• Foreign key
• Primary key
• Field

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

• NAME
• ID
• CITY
• ID, NAME