SQL Flashcards
The command to eliminate a table from a database is:
Correct Answer: DROP TABLE CUSTOMER;
The SQL keyword(s) ________ is used with wildcards.
Correct Answer: LIKE only
A view is ……….?
A virtual table that can be accessed via SQL commands
The wildcard in a WHERE clause is useful when?
An exact match is not possible in a SELECT statement.
Name five built-in functions provided by SQL?
COUNT, SUM, AVG, MAX, MIN
A subquery in an SQL SELECT statement is enclosed in:
parenthesis – (…) .
The result of a SQL SELECT statement is a(n) form/table/row/array
table
Which of the following is NOT a SQL keyword or SQL clause?
insert/update/invert/limit
invert
Which SQL function is used to count the number of rows in a SQL query?
COUNT()
Which of the following is valid SQL for an Index?
Add index/Create index/let index
CREATE INDEX ID;
When three or more AND and OR conditions are combined, it is
easier to use the SQL keyword(s):
Both IN and NOT IN.
A subquery in an SQL SELECT statement:
a) has a table having query
b) has a distinct form that cannot be duplicated by a join.
c) has a view
has a distinct form that cannot be duplicated by a join.
SQL query and modification commands make up a(n) ________ .
DML
The HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than rows.
When the SQL keyword BETWEEN is used?
for ranges.
SELECT 12 * 2 + 24;
48
Do the following statements return the same or different output?
SELECT * FROM EMPLOYEES;
Select * from employees;
select * FROM employees;
Same output
Which of the following is not a SQL transaction statement?
insert/rollback/commit
insert
Question: 8 Which of the following is a valid way to add comments to a SQL statement?
a) – this is comment
b) //this is comment
c) –> this is comment
a)– this is comment
What does the ALTER TABLE statement do?
Use to change the structure of an existing table.
