Programming II Finals

is the standard language for dealing with Relational Databases.

• Database

• SQL

• Query

• SELECT

statement is used to insert new records in a table.

• Add

• INSERT TO

• INSERT IN

• INSERT INTO

Which of the following is the right query for adding new records?

• INSERT table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...);

• INSERT INTO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...)

• INSERT INTO table_name VALUES (value1, value2, value3, ...);

• INSERT TO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...);

_______ statement is used to select data from a database.

• loaddata

• SELECT *

• SELECT

• VIEW

__________ clause is used to filter records.

• IN

• WHERE

• WHERE 1

• WERE

The _____ clause is not only used in SELECT statements, it is also used in UPDATE, DELETE, etc.!

• WHERE

• IN

• INTO

• IF

___ operator displays a record if the condition(s) is NOT TRUE.

• OR

• NOT

• NULL

• FALSE

operator displays a record if all the conditions separated by ____ are TRUE.

• TRUE

• OR

• AND

• NOT

operator displays a record if any of the conditions separated by ____ is TRUE.

• AND

• TRUE

• NOT

• OR

which of the following is the correct syntax in READ student first name?

• SELECT 'FIRSTNAME' FROM 'tbl_studentinfo' WHERE 'FIRSTNAME' = "Angel"

• SELECT `FIRSTNAME` FROM `tbl_studentinfo` WHERE `FIRSTNAME` = Angel

• SELECT `FIRSTNAME` FROM `tbl_studentinfo` WHERE `FIRSTNAME` = "Angel"

• SELECT FIRSTNAME FROM tbl_studentinfo WHERE FIRSTNAME = Angel