SQL Basics

What does the "S" in SQL stand for?

• Several

• Structured

• Syntax

• Semi-precise

The "R" of CRUD is best represented by the SQL command:

• SELECT

• DROP

• ALTER

• AS

What is the MAXIMUM number of false inputs an AND will accept and still give a positive output?

• 3

• 2

• 1

• 0

How could we choose only unique values in a query?

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT SPECIAL

• SELECT WITH NO DUPLICATE

What is the syntax to enter a new record into the "Sales" table?

• INSERT INTO Sales VALUES

• ALTER SALES NEW VALUES

• SALES = SALES + NEW VALUES

• SALES.ALTER.EDIT.CHANGE

Which two constraints apply to PRIMARY KEY?

• Unique

• Non-null

• Alphanumeric

• ASCII

What is the syntax to create a new table?

• CREATE TABLE

• MAKE TABLE

• GENERATE TABLE

• NEW TABLE

Which of the below is NOT an SQL distribution?

• Microsoft SQL Server

• PostgreSQL

• MySQL

• Invidio SQL

The most common join is:

• INNER

• OUTER

• PARTIAL

• RIGHT

Databases are more fully-featured than files because they are

• Relational

• Compiler-optimized

• Novel

• Artistic