SQL set 1

Query to select all records with "bar" in their name?

• a)SELECT * FROM people WHERE name LIKE "%bar%";

• b)SELECT * FROM people WHERE name = "%bar%";

• c)SELECT * FROM people WHERE name = "_bar_"

• d)SELECT * FROM people WHERE name IN ("bar");

SQL query used to fetch unique values from a field?

• a)SELECT column_name FROM table_name WHERE COUNT(column_name) = 1;

• b)SELECT UNIQUE column_name FROM table_name WHERE COUNT(column_name) = 1;

• c)SELECT UNIQUE column_name FROM table_name;

• d)SELECT DISTINCT column_name FROM table_name;

An SQL query to delete a data from the table and memory while keeping the structure of the table intact?

• a)TRUNCATE TABLE table_name;

• b)DELETE FROM TABLE table_name;

• c)DROP TABLE table_name;

• d)DROP FROM TABLE table_name;

The SQL WHERE clause:

• a)limits the column data that are returned.

• b)limits the row data are returned.

• c)Both A and B are correct.

• d)Neither A nor B are correct.

Which of the following is the original purpose of SQL?

• a)To specify the syntax and semantics of SQL data definition language

• b)To specify the syntax and semantics of SQL manipulation language

• c)To define the data structures

• d)All of the above.

The command to eliminate a customer table from a database is:

• a)REMOVE TABLE CUSTOMER;

• b)DROP TABLE CUSTOMER;

• c)DELETE TABLE CUSTOMER;

• d)UPDATE TABLE CUSTOMER;

Which of the following is the correct order of keywords for SQL SELECT statements?

• a)SELECT, FROM, WHERE

• b)FROM, WHERE, SELECT

• c)WHERE, FROM,SELECT

• d)SELECT,WHERE,FROM

The result of a SQL SELECT statement is a(n) ________ .

• a)report

• b)form

• c)file

• d)table

Which of the following are the five built-in aggerate functions provided by SQL?

• a)SUM, AVG, MIN, MAX, MULT

• b)COUNT, SUM, AVG, MAX, MIN

• c)SUM, AVG, MULT, DIV, MIN

• d)SUM, AVG, MIN, MAX, NAME

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

• a)all columns of the table are to be returned.

• b)all records meeting the full criteria are to be returned.

• c)all records with even partial criteria met are to be returned.

• d)None of the above is correct.