The BLUEKEY TECHNICAL TEST LEVEL 2 assesses knowledge in SQL database operations. It covers adding and removing rows, using WHERE clauses, understanding views, and utilizing wildcards in queries. This quiz is essential for learners aiming to enhance their SQL skills.
ONLY
UNIQUE
DISTINCT
SINGLE
Rate this question:
For ranges.
To limit the columns displayed.
As a wildcard.
None of the above is correct.
Rate this question:
COUNT, SUM, AVG, MAX, MIN
SUM, AVG, MIN, MAX, MULT
SUM, AVG, MULT, DIV, MIN
SUM, AVG, MIN, MAX, NAME
Rate this question:
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
Rate this question:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
Rate this question:
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
Rate this question:
Braces -- {...}.
CAPITAL LETTERS
Parenthesis -- (...) .
Brackets -- [...].
Rate this question:
SORT BY
ALIGN BY
ORDER BY
GROUP BY
Rate this question:
LIKE only
IN only
NOT IN only
IN and NOT IN
Rate this question:
Use FROM to name the source table(s) and list the columns to be shown after SELECT.
Use USING to name the source table(s) and list the columns to be shown after SELECT.
Use SELECT to name the source table(s) and list the columns to be shown after USING.
Use USING to name the source table(s) and list the columns to be shown after WHERE.
Rate this question:
All columns of the table are to be returned.
All records meeting the full criteria are to be returned.
All records with even partial criteria met are to be returned.
None of the above is correct.
Rate this question:
Data types
Primary keys
Default values
All of the above.
Rate this question:
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Rate this question:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
UPDATE FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
Rate this question:
LIKE only.
IN only.
NOT IN only
Both IN and NOT IN
Rate this question:
DDL
DML
HTML
XML
Rate this question:
DDL
DML
HTML
XML
Rate this question:
Limits the column data that are returned.
Limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.
Rate this question:
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.
Rate this question:
Report
Form
File
Table
Rate this question:
Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.
Rate this question:
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.
Rate this question:
Normalization
Data Integrity
Materialized Views
All of the above.
Rate this question:
A programming language.
An operating system.
A data sublanguage.
A DBMS
Rate this question:
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.
Rate this question:
Asterisk (*); percent sign (%)
Percent sign (%); underscore (_)
Underscore(_); question mark (?)
Question mark (?); asterisk (*)
Rate this question:
Can only be used with two tables.
Can always be duplicated by a join.
Has a distinct form that cannot be duplicated by a join.
Cannot have its results sorted using ORDER BY.
Rate this question:
Asterisk (*); percent sign (%)
Percent sign (%); underscore (_)
Underscore(_); question mark (?)
Question mark (?); asterisk (*)
Rate this question:
ADD
INSERT
CREATE
MAKE
Rate this question:
Quiz Review Timeline (Updated): Mar 14, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
RDBMS And SQL Knowledge Test
Welcome to the RDBMS and SQL Knowledge Test. As you might already know, RDMS is the basis for various modern database systems such as SQL, MySQL, MS SQL Server, IBM DB2. etc. In...
Questions:
10 |
Attempts:
2765 |
Last updated:
Nov 12, 2023
|
The Ultimate SQL Syntax And Functionality Knowledge Test
Since its creation in 1974, SQL has become the most popular programming language for relational database management. With its fine set of functions and easy to learn syntax, it...
Questions:
40 |
Attempts:
429 |
Last updated:
Mar 21, 2023
|
SQL Basic! Ultimate Trivia Quiz
Dive into the basics of SQL with this Ultimate Trivia! Assess your understanding of key SQL functions like COUNT(*), MAX, and DELETE. Perfect for beginners, this quiz enhances...
Questions:
10 |
Attempts:
688 |
Last updated:
Mar 21, 2023
|
SQL Multiple Choice Questions With Answers
Are you looking for some SQL multiple-choice questions with answers to make your preparation level better for the upcoming exam? Try our quiz below and see if you know the basics...
Questions:
20 |
Attempts:
12487 |
Last updated:
Jun 17, 2024
|
Fill In The Blanks On SQL
This SQL quiz assesses key database management skills, focusing on table structure modifications, understanding of relational model constraints, and data manipulation. It's ideal...
Questions:
10 |
Attempts:
1191 |
Last updated:
Mar 21, 2023
|
Introduction To SQL True Or False Quiz
What is SQL? Have you ever used SQL programming language? Here, we have this "Introduction to SQL quiz" in the true or false format to check your knowledge regarding...
Questions:
12 |
Attempts:
2645 |
Last updated:
Aug 24, 2023
|
Wait!
Here's an interesting quiz for you.