SQL BASIC

To remove a record from a table, which SQL statement would you use?

• REMOVE

• DELETE

• CANCEL

• ERADICATE

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 varchar(10), age INT);

• CREATE actors WITH COLUMNS (name, age);

• CREATE DATABASE actors WITH COLUMNS (name string(10), age INT);

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

I want to select all columns in my "actors" table for all actors. 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 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;

In a database for an online shopping company, all the information about a single customer would be stored as a ...

• Field

• Record

• Relationship

• Table

In a database for an online shopping company, all the customer information would be stored as a ...

• Field

• Record

• Relationship

• Table

In the table shown, which field is likely to be the primary key?

(a)  

What does “SQL” stand for?

• Standard Query Language.
• Structured Query Language.
• Structured Quick-access Language.
• Standard Questioning Language.

What is data redundancy?

• Data that is repeated multiple times.
• Data that is safe from SQL attacks.
• Data that is weak to SQL attacks.
• Data that has no use anymore.

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

• Add To

• Update To

• Add Into

• Insert Into