MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Introduction To SQL
Quiz 3
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
Which of the following are the five built-in functions provided by SQL?
COUNT, SUM, AVG, MAX, MIN
SUM, AVG, MIN, MAX, MULT
SUM, AVG, MULT, DIV, MIN
SUM, AVG, MIN, MAX, NAME
Q.2
SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML
Q.3
Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
Q.4
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
True
False
Q.5
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
True
False
Q.6
To establish a range of values, < and > can be used.
True
False
Q.7
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
True
False
Q.8
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
True
False
Q.9
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
True
False
Q.10
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
True
False
Q.11
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
True
False
Q.12
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
True
False
Q.13
Indexes may be created or dropped at any time.
True
False
Q.14
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
True
False
Q.15
ORDER BY can be combined with the SELECT statements.
True
False
Q.16
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
True
False
Q.17
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
True
False
Q.18
The result of every SQL query is a table.
True
False
Q.19
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
True
False
Q.20
SUM, AVG, MIN, and MAX can only be used with numeric columns.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page