True Or False

Question 1 :

The condition in a WHERE clause can refer to only one value.


A). True
B). False
Answer : Option B

Question 2 :

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.


A). True
B). False
Answer : Option B

Question 3 :

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.


A). True
B). False
Answer : Option A

Question 4 :

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.


A). True
B). False
Answer : Option A

Question 5 :

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.


A). True
B). False
Answer : Option B

Question 6 :

The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.


A). True
B). False
Answer : Option B

Question 7 :

There is an equivalent join expression that can be substituted for all subquery expressions.


A). True
B). False
Answer : Option B

Question 8 :

A dynamic view is one whose contents materialize when referenced.


A). True
B). False
Answer : Option A

Question 9 :

SQL is a programming language.


A). True
B). False
Answer : Option B

Question 10 :

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.


A). True
B). False
Answer : Option B

Question 11 :

Indexes can usually be created for both primary and secondary keys.


A). True
B). False
Answer : Option A

Question 12 :

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.


A). True
B). False
Answer : Option A

Question 13 :

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.


A). True
B). False
Answer : Option A

Question 14 :

SQL is a data sublanguage.


A). True
B). False
Answer : Option A

Question 15 :

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.


A). True
B). False
Answer : Option A

Question 16 :

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.


A). True
B). False
Answer : Option B

Question 17 :

The result of every SQL query is a table.


A). True
B). False
Answer : Option A

Question 18 :

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.


A). True
B). False
Answer : Option A

Question 19 :

SUM, AVG, MIN, and MAX can only be used with numeric columns.


A). True
B). False
Answer : Option B

Question 20 :

Most companies keep at least two versions of any database they are using.


A). True
B). False
Answer : Option A

Question 21 :

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.


A). True
B). False
Answer : Option A

Question 22 :

Indexes may be created or dropped at any time.


A). True
B). False
Answer : Option A

Question 23 :

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.


A). True
B). False
Answer : Option A

Question 24 :

ORDER BY can be combined with the SELECT statements.


A). True
B). False
Answer : Option A

Question 25 :

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.


A). True
B). False
Answer : Option B

Question 26 :

Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.


A). True
B). False
Answer : Option B

Question 27 :

The keyword LIKE can be used in a WHERE clause to refer to a range of values.


A). True
B). False
Answer : Option B

Question 28 :

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.


A). True
B). False
Answer : Option B

Question 29 :

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.


A). True
B). False
Answer : Option A

Question 30 :

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."


A). True
B). False
Answer : Option B

Question 31 :

Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.


A). True
B). False
Answer : Option B

Question 32 :

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.


A). True
B). False
Answer : Option A

Question 33 :

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.


A). True
B). False
Answer : Option A

Question 34 :

To establish a range of values, < and > can be used.


A). True
B). False
Answer : Option A

Question 35 :

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.


A). True
B). False
Answer : Option A