SQL Functions and Joins

What is the specific request for data manipulation issued by the end-user or the application to the DBMS?

• Schema

• Query

What is the syntax for adding a UNIQUE constraint using an ALTER?

• ALTER TABLE table_name ADD UNIQUE(column);

• ALTER column_name ADD UNIQUE(column);

What command should be used for deleting the table’s data only?

• TRUNCATE

• DROP

1What is the syntax for deleting a column?

• ALTER TABLE table_name DROP COLUMN column_name;

• ALTER TABLE table_name DELETE COLUMN column_name;

This is an operator used with WHERE to check whether a value matches any value within a given list.

• IN

• LIKE

What is the operator used with SELECT to determine whether a field is empty or not?

• NULL

• IS NULL

Describe COUNT() function?

• returns the number of rows

• returns the number of columns

What is the correct query in creating a database?

• CREATE DBEXAM DATABASE;

• CREATE DATABASE DBEXAM;

They are used to combine records from only two tables in a database based on any random field.

• Aggregate Functions

• SQL Join Clauses

What is the Join statement that returns rows where there is at least one match in both tables?

• Inner Join

• Union