Test your SQL
Test Your SQL Knowledge
Are you ready to challenge your understanding of SQL? This quiz will put your skills to the test with 10 engaging questions that cover key SQL concepts.
- Assess your knowledge of SQL commands
- Learn more about SQL syntax and fun
ctions - Perfect for beginners and intermediate learners
You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE
The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...
The SQL WHERE clause:
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.
The wildcard in a WHERE clause is useful when?
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.
To define what columns should be displayed in an SQL SELECT statement:
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.
SQL can be used to:
Create database structures only.
Query database data only.
Modify database data only.
All of the above can be done by SQL.
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
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.
The SQL -92 wildcards are ____ and ____ .
Asterisk (*); percent sign (%)
Percent sign (%); underscore (_)
Percent sign (%); underscore (_)
Question mark (?); asterisk (*)
The HAVING clause does which of the following?
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.
The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.
{"name":"Test your SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Are you ready to challenge your understanding of SQL? This quiz will put your skills to the test with 10 engaging questions that cover key SQL concepts. Assess your knowledge of SQL commands Learn more about SQL syntax and functions Perfect for beginners and intermediate learners","img":"https:/images/course1.png"}