This Quiz contains totally 25 Questions each carry 1 point for you.
1.What does SQL stand for?
Structured Query Language
Simple Query Language
Secure Query Language
Standard Query Language
Correct!
Wrong!
2.Which of the following is not a type of SQL statement?
DDL
DML
DRL
DCL
Correct!
Wrong!
3.Which SQL statement is used to create a new table?
CREATE TABLE
INSERT INTO
ALTER TABLE
UPDATE
Correct!
Wrong!
4.Which of the following is not a constraint in SQL?
PRIMARY KEY
FOREIGN KEY
NULL KEY
UNIQUE
Correct!
Wrong!
5.What is the purpose of the DROP statement in SQL?
To delete a row from a table
To delete a table from a database
To modify the structure of an existing table
To delete a column from a table
Correct!
Wrong!
6.What is the purpose of the ALTER statement in SQL?
To modify the structure of an existing table
To delete a row from a table
To delete a table from a database
To delete a column from a table
Correct!
Wrong!
7.Which SQL statement is used to retrieve data from a table?
SELECT
INSERT
UPDATE
DELETE
Correct!
Wrong!
8.What is the purpose of an index in a SQL database?
To improve query performance
To enforce data integrity
To organize data in a hierarchical structure
To store metadata about a table
Correct!
Wrong!
9.Which of the following is not a type of join in SQL?
INNER JOIN
OUTER JOIN
CROSS JOIN
VERTICAL JOIN
Correct!
Wrong!
10.What is a transaction in SQL?
A single SQL statement
A sequence of SQL statements treated as a single unit of work
A set of related tables in a database
A connection between a client application and a database server
Correct!
Wrong!
11.Which of the following SQL clauses is used to filter the results of a query based on a condition?
WHERE
HAVING
GROUP BY
ORDER BY
Correct!
Wrong!
12.What is the purpose of the SQL COUNT() function?
To return the average of a column's values
To return the sum of a column's values
To return the number of rows that match a specified condition
To return the highest value of a column
Correct!
Wrong!
13.Which SQL statement is used to add new rows to a table?
INSERT INTO
SELECT
UPDATE
DELETE
Correct!
Wrong!
14.Which of the following is not a SQL database performance optimization technique?
Indexing
Query optimization
Data normalization
Data encryption
Correct!
Wrong!
15.What is the purpose of the SQL GROUP BY clause?
To group rows that have the same values in specified columns
To filter the results of a query based on a condition
To sort the results of a query
To combine rows from two or more tables based on a related column
Correct!
Wrong!
16.What is the purpose of a stored procedure in a SQL database?
To execute a sequence of SQL statements as a single unit
To define a relationship between tables
To enforce data integrity constraints
To optimize the performance of a database
Correct!
Wrong!
17.What is the purpose of a trigger in a SQL database?
To automatically execute a sequence of SQL statements in response to an event
To define a relationship between tables
To enforce data integrity constraints
To optimize the performance of a database
Correct!
Wrong!
18.Which of the following is not a component of a SQL database security strategy?
Authentication
Authorization
Data normalization
Encryption
Correct!
Wrong!
19.What is the purpose of database auditing in a SQL database?
To monitor and record database activities
To optimize the performance of a database
To define a relationship between tables
To enforce data integrity constraints
Correct!
Wrong!
20.Which of the following is a best practice for SQL database design?
Using a single large table to store all data
Using a single index for all columns
Normalizing data to reduce redundancy
Storing sensitive data in plain text
Correct!
Wrong!
21.What is the purpose of a view in a SQL database?
To present a virtual table based on the result of a SELECT statement
To define a relationship between tables
To enforce data integrity constraints
To optimize the performance of a database
Correct!
Wrong!
22.Which SQL statement is used to grant privileges on a database object to a user?
GRANT
REVOKE
CREATE USER
ALTER USER
Correct!
Wrong!
23.What is the primary purpose of database sharding in a SQL database?
To improve query performance
To distribute data across multiple servers
To enforce data integrity constraints
To optimize storage requirements
Correct!
Wrong!
24.Which of the following is not a SQL database use case?
Storing structured data
Performing complex queries and data analysis
Real-time processing of streaming data
Managing relationships between data entities
Correct!
Wrong!
25.In the context of SQL databases, what is a schema?
A set of tables and other database objects in a database
A set of rules that govern how data is stored and manipulated in a database
A graphical representation of a database's structure
A backup of a database's data and structure
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
Azure Data Engineering SQL Database – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...