Show List

Quiz - SQL - 4

50%

Public Average Score
Select the right answer for below questions:

What is a GROUP BY clause in SQL?
A clause used to limit the results of a query
A clause used to sort the results of a query
A clause used to group the results of a query based on one or more columns
A clause used to combine the results of multiple queries
A clause used to group the results of a query based on one or more columns

What does DDL stand for in SQL?
Data Definition Language
Data Description Language
Data Description Logic
Data Definition Logic
Data Definition Language

What does DML stand for in SQL?
Data Manipulation Language
Data Management Logic
Data Manipulation Logic
Data Management Language
Data Manipulation Language

What is the purpose of the CREATE TABLE statement in SQL?
To create a new table in a database
To modify an existing table in a database
To delete a table from a database
To retrieve data from a table in a database
To create a new table in a database

What is the purpose of the ALTER TABLE statement in SQL?
To create a new table in a database
To modify an existing table in a database
To delete a table from a database
To retrieve data from a table in a database
To modify an existing table in a database

What is the purpose of the DROP TABLE statement in SQL?
To create a new table in a database
To modify an existing table in a database
To delete a table from a database
To retrieve data from a table in a database
To delete a table from a database

What is the purpose of the INSERT INTO statement in SQL?
To insert new data into a table in a database
To update existing data in a table in a database
To delete data from a table in a database
To retrieve data from a table in a database
To insert new data into a table in a database

What is the purpose of the UPDATE statement in SQL?
To insert new data into a table in a database
To update existing data in a table in a database
To delete data from a table in a database
To retrieve data from a table in a database
To update existing data in a table in a database

What is the purpose of the DELETE statement in SQL?
To insert new data into a table in a database
To update existing data in a table in a database
To delete data from a table in a database
To retrieve data from a table in a database
To delete data from a table in a database

What is the purpose of the SELECT statement in SQL?
To insert new data into a table in a database
To update existing data in a table in a database
To delete data from a table in a database
To retrieve data from a table in a database
To retrieve data from a table in a database

Submit
Retry
{"qz1-812999":"A clause used to group the results of a query based on one or more columns","qz1-813000":"Data Definition Language","qz1-813001":"Data Manipulation Language","qz1-813002":"To create a new table in a database","qz1-813003":"To modify an existing table in a database","qz1-813004":"To delete a table from a database","qz1-813005":"To insert new data into a table in a database","qz1-813006":"To update existing data in a table in a database","qz1-813007":"To delete data from a table in a database","qz1-813008":"To retrieve data from a table in a database"}

    Leave a Comment


  • captcha text