MIDTERM BLIS-RE EXAM

Which of the following databases use SQL as the standard query language?

• SQLite

• MySQL

• MongoDB

• Redis

What is SQL used for?

• Creating graphics

• Managing data in Relational DBMS

• Playing music

• Editing videos

Which SQL command is used to create a new table in a database?

• CREATE INDEX

• ALTER TABLE

• CREATE TABLE

• DROP TABLE

What does the SQL command SELECT do?

• Insert records in a database

• Retrieve data from a database

• Set permissions on tables

• Create new databases

Which of the following uniquely identifies each record in a database table?

• Secondary key

• Foreign key

• Primary key

• Unique key

What does the SQL LIKE operator do?

• Update existing records

• Search for a specified pattern in a column

• Insert new rows

• Delete rows from a table

Which of the following queries may you use if you want to create a new table?

• UPDATE TABLE

• INSERT TABLE

• CREATE TABLE

• ADD TABLE

Which SQL command is used to delete records from a database?

• CREATE

• UPDATE

• ADD

• DELETE

Which of the following statement is used to select data from the database?

• DELETE

• SELECT

• UPDATE

• INSERT

How can you give a table or column another name in SQL?

• Use a label

• Use a pseudonym

• Use an alias

• Use a nickname