Bluekey Technical Test Level 2
.
- 1.You can add a row using SQL in a database with which of the following?
- A.
ADD
- B.
INSERT
- C.
CREATE
- D.
MAKE
- 2.The command to remove rows from a table 'CUSTOMER' is:
- A.
REMOVE FROM CUSTOMER ...
- B.
DROP FROM CUSTOMER ...
- C.
UPDATE FROM CUSTOMER ...
- D.
DELETE FROM CUSTOMER WHERE ...
- 3.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.
- 4.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.
- 5.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.
- 6.A view is which of the following?
- A.
A virtual table that can be accessed via SQL commands
- B.
A virtual table that cannot be accessed via SQL commands
- C.
A base table that can be accessed via SQL commands
- D.
A base table that cannot be accessed via SQL commands
- 7.The command to eliminate a table from a database is:
- A.
REMOVE TABLE CUSTOMER;
- B.
DROP TABLE CUSTOMER;
- C.
DELETE TABLE CUSTOMER;
- D.
UPDATE TABLE CUSTOMER;
- 8.ON UPDATE CASCADE ensures which of the following?
- A.
Normalization
- B.
Data Integrity
- C.
Materialized Views
- D.
All of the above.
- 9.SQL data definition commands make up a(n) ________ .
- A.
DDL
- B.
DML
- C.
HTML
- D.
XML
- 10.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;
- 11.The SQL keyword(s) ________ is used with wildcards.
- A.
LIKE only
- B.
IN only
- C.
NOT IN only
- D.
IN and NOT IN
- 12.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
- 13.A subquery in an SQL SELECT statement is enclosed in:
- A.
Braces -- {...}.
- B.
CAPITAL LETTERS
- C.
Parenthesis -- (...) .
- D.
Brackets -- [...].
- 14.The result of a SQL SELECT statement is a(n) ________ .
- A.
Report
- B.
Form
- C.
File
- D.
Table
- 15.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
- 16.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.
- 17.The HAVING clause does which of the following?
- A.
Acts like a WHERE clause but is used for groups rather than rows.
- B.
Acts like a WHERE clause but is used for rows rather than columns.
- C.
Acts like a WHERE clause but is used for columns rather than groups.
- D.
Acts EXACTLY like a WHERE clause.
- 18.The SQL -92 wildcards are ____ and ____ .
- A.
Asterisk (*); percent sign (%)
- B.
Percent sign (%); underscore (_)
- C.
Underscore(_); question mark (?)
- D.
Question mark (?); asterisk (*)
- 19.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
- 20.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.
- 21.Which of the following do you need to consider when you make a table in SQL?
- A.
Data types
- B.
Primary keys
- C.
Default values
- D.
All of the above.
- 22.SQL query and modification commands make up a(n) ________ .
- A.
DDL
- B.
DML
- C.
HTML
- D.
XML
- 23.When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
- A.
LIKE only.
- B.
IN only.
- C.
NOT IN only
- D.
Both IN and NOT IN
- 24.The Microsoft Access wildcards are ____ and ____ .
- A.
Asterisk (*); percent sign (%)
- B.
Percent sign (%); underscore (_)
- C.
Underscore(_); question mark (?)
- D.
Question mark (?); asterisk (*)
- 25.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');
Questions: 19 | Attempts: 209 | Last updated: Mar 22, 2022
-
Sample QuestionJim, an instructor, has reviewed and adjusted his course material. Despite this, a small number of learners are having difficulty keeping up with the rest of the group. Which of the following describes how Jim should best proceed in this situation?
Questions: 18 | Attempts: 511 | Last updated: Mar 22, 2022
-
Sample QuestionYou want to see the accumulated assets and liabilities for the financial year to date. Which report can you use?
Questions: 85 | Attempts: 215 | Last updated: Mar 21, 2022
-
Sample QuestionIt is the first day of a three-day computer course. One half of the learners are there on an involuntary basis and are irritated. Which of the following describes what the instructor should do at the beginning of the course?
Back to top