MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 67 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
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» B. False | |
| 2. |
To establish a range of values, < and > can be used.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
Indexes can usually be created for both primary and secondary keys.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 13. |
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» C. | |
| 14. |
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 15. |
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 16. |
Most companies keep at least two versions of any database they are using.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 17. |
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» B. False | |
| 18. |
SQL is a programming language.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 19. |
ORDER BY can be combined with the SELECT statements.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 20. |
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» B. False | |
| 21. |
SQL is a data sublanguage.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 22. |
SUM, AVG, MIN, and MAX can only be used with numeric columns.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 23. |
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» B. False | |
| 24. |
A dynamic view is one whose contents materialize when referenced.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 25. |
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» B. False | |
| 26. |
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» C. | |
| 27. |
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 28. |
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 29. |
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» C. | |
| 30. |
There is an equivalent join expression that can be substituted for all subquery expressions.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 31. |
Indexes may be created or dropped at any time.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 32. |
The keyword LIKE can be used in a WHERE clause to refer to a range of values.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 33. |
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 34. |
The result of every SQL query is a table.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 35. |
The condition in a WHERE clause can refer to only one value.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 36. |
SQL is:%! |
| A. | a programming language. |
| B. | an operating system. |
| C. | a data sublanguage. |
| D. | a DBMS. |
| Answer» D. a DBMS. | |
| 37. |
________ was adopted as a national standard by ANSI in 1992.%! |
| A. | Oracle |
| B. | SQL |
| C. | Microsoft Access |
| D. | DBase |
| Answer» C. Microsoft Access | |
| 38. |
A subquery in an SQL SELECT statement:%! |
| A. | can only be used with two tables. |
| B. | can always be duplicated by a join. |
| C. | has a distinct form that cannot be duplicated by a join. |
| D. | cannot have its results sorted using ORDER BY. |
| Answer» D. cannot have its results sorted using ORDER BY. | |
| 39. |
The SQL keyword BETWEEN is used:%! |
| A. | for ranges. |
| B. | to limit the columns displayed. |
| C. | as a wildcard. |
| D. | None of the above is correct. |
| Answer» B. to limit the columns displayed. | |
| 40. |
*$_Which of the following is valid SQL for an Index?? |
| A. | CREATE INDEX ID; |
| B. | CHANGE INDEX ID; |
| C. | ADD INDEX ID; |
| D. | REMOVE INDEX ID; |
| Answer» B. CHANGE INDEX ID; | |
| 41. |
*$_The benefits of a standard relational language include which of the following?? |
| A. | Reduced training costs |
| B. | Increased dependence on a single vendor |
| C. | Applications are not needed |
| D. | All of the above |
| Answer» B. Increased dependence on a single vendor | |
| 42. |
*$_Which of the following are the five built-in functions provided by SQL?? |
| A. | COUNT, SUM, AVG, MAX, MIN |
| B. | SUM, AVG, MIN, MAX, MULT |
| C. | SUM, AVG, MULT, DIV, MIN |
| D. | SUM, AVG, MIN, MAX, NAME |
| Answer» B. SUM, AVG, MIN, MAX, MULT | |
| 43. |
*$_The SQL statement that queries or reads data from a table is ________ .? |
| A. | SELECT |
| B. | READ |
| C. | QUERY |
| D. | None of the above is correct |
| Answer» B. READ | |
| 44. |
*$_Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';? |
| A. | SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); |
| B. | SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; |
| C. | SELECT NAME IN CUSTOMER WHERE STATE = 'V'; |
| D. | SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); |
| Answer» E. | |
| 45. |
*/*_The wildcard in a WHERE clause is useful when?? |
| A. | An exact match is necessary in a SELECT statement. |
| B. | An exact match is not possible in a SELECT statement. |
| C. | An exact match is necessary in a CREATE statement. |
| D. | An exact match is not possible in a CREATE statement. |
| Answer» C. An exact match is necessary in a CREATE statement. | |
| 46. |
%_SQL data definition commands make up a(n) ________ ._% |
| A. | DDL |
| B. | DML |
| C. | HTML |
| D. | XML |
| Answer» B. DML | |
| 47. |
%_To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included._% |
| A. | ONLY |
| B. | UNIQUE |
| C. | DISTINCT |
| D. | SINGLE |
| Answer» D. SINGLE | |
| 48. |
%_The result of a SQL SELECT statement is a(n) ________ ._% |
| A. | report |
| B. | form |
| C. | file |
| D. | table |
| Answer» E. | |
| 49. |
%_SQL can be used to:_% |
| A. | create database structures only. |
| B. | query database data only. |
| C. | modify database data only. |
| D. | All of the above can be done by SQL. |
| Answer» E. | |
| 50. |
%_The Microsoft Access wildcards are ____ and ____ ._% |
| A. | asterisk (*); percent sign (%) |
| B. | percent sign (%); underscore (_) |
| C. | underscore(_); question mark (?) |
| D. | question mark (?); asterisk (*) |
| Answer» E. | |