quizz

What does SQL stand for?

• Strong Qestion Language
• Selective Query Language
• Structured Query Language
• Structured Question Language

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

• GET
• EXTRACT
• SELECT
• OPEN

Which SQL statement is used to update data in database?

• MODIFY
• UPDATE
• SAVE
• SAVE AS

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

• DROP
• REMOVE
• DELETE
• COLLAPSE

Which SQL statement is used to insert new data in a database?

• INSERT INTO
• ADD NEW
• INSERT NEW
• ADD RECORD

In SQL how do you select a column named "firstname" from a table named "persons"?

• EXTRACT firstname FROM persons;
• SELECT persons FROM firstname;
• SELECT persons.firstname;
• SELECT firstname FROM persons;

In SQL how do you select all columns from a table named "persons"?

• SELECT * FROM persons;
• SELECT all FROM persons;
• SELECT *.persons;
• SELECT persons;

In SQL how do you select all the records from a table named "persons" when the value of the column "firstname" is "Peter"?

• SELECT * FROM persons WHERE firstname == "Peter";
• SELECT * FROM persons WHERE firstname <> "Peter";
• SELECT all FROM persons WHERE firstname = "Peter";
• SELECT * FROM persons WHERE firstname = "Peter";

In SQL how do you select all the records from a table named "persons" when the value of the column "firstname" has the second letter "a" from the beginning?

• SELECT * FROM persons WHERE firstname = "a";
• SELECT * FROM persons WHERE firstname LIKE "%a_";
• SELECT * FROM persons WHERE firstname = "%a";
• SELECT * FROM persons WHERE firstname LIKE "_a%";

Which are true?

• The OR operator displays a record if ALL conditions liste are true.
• The AND operator displays a record if ALL of the conditions listed are true
• The OR operator displays a record if ANY conditions liste are true.
• The AND operator displays a record if ANY of the conditions listed are true