SQL Practice

How many weeks are there in a year?

• 53

• 52

• 51

• 54

What does SQL stand for?

• Strong Question Language

• Structured Question Language

• Structured Query Language

What is the capital of Canada?

• Toronto

• Ottawa

• Montreal

• Kitchener

What is a primary key?

• A link between 2 tables

• A number that counts records

• A unique identifier for a row

• A small piece of shaped metal with incisions cut to fit the wards of a particular lock, which is inserted into a lock and turned to open or close it.

Which SQL statement is used to extract data from a database?

• SELECT

• GET

• OPEN

• EXTRACT

How many zeros are there in a million?

• 6

• 7

• 8

• 7.5

Which of the following is NOT a function of Application Programs in a database system?

• Execute Application Logic

• Create and Process reports

• Process user queries

• Read Database Data

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

• True

• False

What is the default JOIN type?

• Implicit Join

• Explicit Join

• OUTER JOIN

• INNER JOIN

What word comes to mind when you think of Technology?