SQL Test Review

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

Which statement allows us to add a record to a table?

• Add To

• Update To

• Add Into

• Insert Into

SQL injection input of a TRUE statement will turn the query into:

SELECT * FROM SportData WHERE Team = 'Mustangs' or 1 = 1;

• True

• False

I want to select EVERY column and entry in my "actors" table. How can I do that?

• SELECT * FROM actors;

• SELECT age FROM actors;

• SELECT * FROM actors WHERE age > 30;

• SELECT name, age FROM actors WHERE age < 30;

I want to select all columns in my "actors" table for all actors older than 30. How can I do that?

• SELECT * FROM actors;

• SELECT age FROM actors;

• SELECT * FROM actors WHERE age > 30;

• SELECT name, age FROM actors WHERE age < 30;

I want to create a table in my table named "actors" with two columns: "name" and "age." What statement will do this?

• CREATE TABLE actors (name TEXT, age INTEGER);

• CREATE actors WITH COLUMNS (name, age);

• CREATE DATABASE actors WITH COLUMNS (name TEXT, age INTEGER);

• CREATE actors (name, age): TABLE, TEXT, INTEGER;

I want to add the actor "Brad Pitt" (aged 56) to my table "actors." Which statement will do this?

• INSERT INTO actors VALUES ("Brad Pitt", 56);

• INSERT "Brad Pitt" AND 56 INTO actors;

• UPDATE age = 56 WHERE name = "Brad Pitt";

• CREATE ENTRY ("Brad Pitt", 56) IN TABLE actors;

A column name is otherwise known as a _____.

• field
• table
• row
• record

A row in a database is better known as

• Record

• Query

• Field

• Form

A software program that contains information organized into categories for easy retrieval

• Filter

• Cell

• Database

• Form