This Quiz contains totally 25 Questions each carry 1 point for you.
- What does SQL stand for?
Simple Query Language
Structured Query Language
Structured Question Language
Simple Question Language
Correct!
Wrong!
2. Which SQL command is used to retrieve data from a database?
SELECT
INSERT
DELETE
ALTER
Correct!
Wrong!
3. Which SQL command is used to insert data into a database?
INSERT
SELECT
DELETE
UPDATE
Correct!
Wrong!
4. Which SQL keyword is used to sort the result-set?
SORT BY
ORDER BY
GROUP BY
ARRANGE BY
Correct!
Wrong!
5. DDL stands for _____
Data Definition Language
Data Detail Language
Data Design Language
Database Development Language
Correct!
Wrong!
6. Which SQL command is part of DDL?
SELECT
UPDATE
DELETE
CREATE
Correct!
Wrong!
7. What does DML stand for?
Data Modification Language
Data Management Language
Data Manipulation Language
Database Management Language
Correct!
Wrong!
8. What does DCL stand for?
Data Control Language
Data Command Language
Database Control Language
d) Data Configuration Language
Correct!
Wrong!
9. What does TCL stand for?
Transaction Control Language
Table Control Language
Transactional Command Language
Table Command Language
Correct!
Wrong!
10. What command would you use to make permanent changes in the database?
SAVE
UPDATE
COMMIT
DELETE
Correct!
Wrong!
11. Which command is used to undo changes that have not yet been saved to the database?
UNDO
ROLLBACK
RETRACT
REVERT
Correct!
Wrong!
12. Which of the following is NOT a data type in SQL?
FLOAT
CHAR
REAL
ARRAY
Correct!
Wrong!
13. Which SQL data type is used to store a date?
DATE
TIME
DATETIME
Both 1) and 3)
Correct!
Wrong!
14. Which data type is used for a fixed-length character string?
VARCHAR
CHAR
STRING
TEXT
Correct!
Wrong!
15. Which of the following is a valid SQL command for creating a new table?
ADD TABLE new_table;
MAKE TABLE new_table;
CREATE TABLE new_table;
INSERT TABLE new_table;
Correct!
Wrong!
16. Which of the following SQL commands can be used to modify an existing table?
CHANGE TABLE
ALTER TABLE
MODIFY TABLE
ADJUST TABLE
Correct!
Wrong!
17. Which SQL command is used to remove a table from the database?
DELETE TABLE
REMOVE TABLE
DROP TABLE
ERASE TABLE
Correct!
Wrong!
18. Which command is used to remove all records from a table, but not the table itself?
REMOVE
DROP
DELETE
TRUNCATE
Correct!
Wrong!
19. Which SQL command is used to provide user access privileges?
GRANT
ENABLE
PERMISSION
ALLOW
Correct!
Wrong!
20. Which SQL command is used to revoke user access privileges?
REVOKE
DISABLE
FORBID
DENY
Correct!
Wrong!
21. Which SQL statement is used to update data in a database?
SAVE
MODIFY
UPDATE
CHANGE
Correct!
Wrong!
22. Which of the following commands is used to delete only rows from a table?
DELETE
DROP
REMOVE
TRUNCATE
Correct!
Wrong!
23. What is a primary key in SQL?
An identifier for a database
A unique identifier for a record in a table
A common identifier for all records in a table
A foreign key in another table
Correct!
Wrong!
24.Which SQL statement is used to extract data from a database?
EXTRACT
GET
SELECT
PULL
Correct!
Wrong!
25. Which SQL operator is used to combine two or more conditions in a WHERE clause?
AND
ALSO
ADD
PLUS
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
MYSQL Basics – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...