SQL INSERT

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

Tags

CCSS.RI.9-10.4

CCSS.RI.9-10.4

CCSS.RI.11-12.4

CCSS.RI.7.4

CCSS.RI.8.4

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

• Add To

• Update To

• Add Into

• Insert Into

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456')

• INSERT VALUES ('SMI01', 'M Smith', '[e-mail]', 01224123456') INTO Designer

• INSERT ('SMI01', 'M Smith', '[e-mail]', '01224123456') INTO Designer

• INSERT Designer INTO VALUES (''SMI01', 'M Smith', '[e-mail]', '01224123456')

What is a field?

• A collection of information

• A single item of information

• A list of information

• A group of records

Which SQL statement is used to update data in a database?

• MODIFY
•  SAVE AS
• UPDATE
• SAVE

With SQL, how can you insert a new record into the "Persons" table?

•  INSERT INTO Persons VALUES ('Ahmed');
  
•  INSERT VALUES ('Ahmed') INTO Persons;
•  INSERT ('Ahmed') INTO Persons;
  
• INSERT VALUES INTO ('AHMED');

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

Which SQL keyword is used to sort the result-set?

• ORDER

• SORT BY

• SORT

• ORDER BY

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

• INSERT INTO Persons ('Olsen') INTO LastName

• INSERT INTO Persons (LastName) VALUES ('Olsen')

• INSERT ('Olsen') INTO Persons (LastName)

Match the following SQL term with a description - WHERE

• The table used in the query

• The fields to display

• The field and order used to sort the results

• The criteria which must be set