WorksheetsDatabase Concepts and Functions
Total questions: 35
Worksheet time: 29mins
During a database management workshop, Ananya asked the instructor about the different components of database systems. She specifically wanted to know what DDL stands for in database management.
Data Distribution Layer
Data Design Language
Data Delivery Logic
Data Definition Language
Divya is working on a new project and needs to set up a database. Which SQL command should she use to create a new table for storing project data?
ADD TABLE
INSERT TABLE
MODIFY TABLE
CREATE TABLE
Saisha is working on a project that involves managing a large database for her company. She needs to ensure that her team can effectively manipulate and manage the data stored in the database tables. What is the purpose of DML in SQL?
The purpose of DML in SQL is to manage and manipulate data in database tables.
To define the structure of a database schema.
To optimize database performance.
To create and delete database tables.
During a database management workshop, Kabir asked the participants to name one common DML command used for modifying data in a database.
DELETE
UPDATE
SELECT
INSERT
In a library, each book is assigned a unique identification number to ensure that no two books have the same ID. What is this unique identification number called?
A primary key constraint is a database rule that enforces uniqueness and non-null values for a column or set of columns.
A primary key constraint is used to define foreign keys in other tables.
A primary key constraint can be null in a database table.
A primary key constraint allows duplicate values in a column.
Ananya is managing a database for a library and needs to ensure that each book's ISBN number is unique. How does she enforce uniqueness in the ISBN column?
Use a UNIQUE constraint or create a unique index on the column.
Use a PRIMARY KEY constraint on the column.
Set the column to allow duplicate values.
Create a foreign key reference to another table.
Aanya is designing a database for her new online store. She wants to ensure that every product has a name and cannot be left blank. What is the function of the NOT NULL constraint?
The NOT NULL constraint prevents NULL values in a database column.
The NOT NULL constraint is used to create foreign key relationships.
The NOT NULL constraint allows NULL values in a database column.
The NOT NULL constraint automatically fills NULL values with default values.
Aditi is managing a database of customer information for her online store. She needs to change the address of a customer who has moved. What SQL command would she use to update existing records?
DELETE
UPDATE
INSERT
SELECT
Arnav is learning SQL and is curious about the difference between a function and a procedure. He asks his friend Aashi to explain it to him.
Procedures return a value, while functions do not.
Functions are always faster than procedures in execution.
Functions can only be used in SELECT statements, while procedures can be used anywhere.
The main difference is that functions return a value and can be used in expressions, whereas procedures do not return a value and are executed as standalone statements.
Vanya is analyzing the sales data for her online store and wants to find out the average sales amount for a specific product. How does she calculate the average of a numeric column in SQL?
SELECT MAX(column_name) FROM table_name;
SELECT COUNT(column_name) FROM table_name;
SELECT SUM(column_name) FROM table_name;
SELECT AVG(column_name) FROM table_name;
Riyaan is analyzing a database of customer orders. He wants to know how many orders were placed in total. What SQL function should he use to achieve this?
To calculate the average value of a column.
To retrieve unique values from a dataset.
To sort the rows in a table.
To count the number of rows in a dataset.
Aarav is working on a database project and needs to combine two strings to create a full name from a first name and a last name. How can he concatenate these two strings in SQL?
Use JOIN(string1, string2)
Use MERGE(string1, string2)
Use APPEND(string1, string2)
Use CONCAT(string1, string2) or string1 || string2 (PostgreSQL) or string1 + string2 (SQL Server).
Krish is designing a database for his new application. He needs to choose between CHAR and VARCHAR data types for storing user information. What is the difference between CHAR and VARCHAR data types?
CHAR is variable-length; VARCHAR is fixed-length.
CHAR can store more data than VARCHAR.
Both CHAR and VARCHAR are fixed-length.
CHAR is fixed-length; VARCHAR is variable-length.
Naira is working on a database project and needs to convert a string representation of a number into an integer for her calculations. How does she convert a string to an integer in SQL?
STRING_TO_INT(string_value)
INTEGER(string_value)
TO_INTEGER(string_value)
CAST(string_value AS INT) or CONVERT(INT, string_value)
Viaan is working on a project where he needs to analyze customer feedback. He wants to determine the length of each feedback string to categorize them. What SQL function would he use to find the length of a string?
STRING_LENGTH()
GET_LENGTH()
CHAR_COUNT()
LENGTH()
In a library system, there are two tables: Books and Borrowers. The Borrowers table has a foreign key constraint that links to the Books table. What does this foreign key constraint ensure?
A foreign key constraint is a type of index that speeds up queries.
A foreign key constraint is a rule that allows duplicate values in a table.
A foreign key constraint is a method to delete records from a table.
A foreign key constraint is a rule that enforces a link between two tables, ensuring that values in the child table correspond to values in the parent table.
Arnav is managing a database for his online bookstore. He needs to remove some outdated records of books that are no longer available. How does he delete records from a table in SQL?
DELETE table_name SET condition;
DROP table_name WHERE condition;
REMOVE FROM table_name WHERE condition;
DELETE FROM table_name WHERE condition;
In a school, the teacher wants to analyze the students' scores in different subjects. She decides to use the GROUP BY clause to organize the data. What is the purpose of the GROUP BY clause?
To sort rows in ascending order.
To join multiple tables together.
To filter rows based on a condition.
To group rows that have the same values in specified columns.
Aarav is analyzing a dataset of sales transactions and wants to present the results in a specific order. How can he sort the results of his query?
Filter results with the WHERE clause.
Use the GROUP BY clause in your query.
Use the ORDER BY clause in your query.
Sort results by using the SELECT statement.
In a restaurant, there are two tables: one for customers who ordered appetizers and another for customers who ordered main courses. What is the difference between INNER JOIN and LEFT JOIN when combining these two tables?
INNER JOIN returns customers who ordered both appetizers and main courses; LEFT JOIN returns all customers who ordered appetizers with their corresponding main course orders, if available.
INNER JOIN includes customers who only ordered appetizers.
LEFT JOIN only returns customers who ordered main courses.
INNER JOIN returns all customers from both tables.
In a company, Divya is tasked with organizing the employee database. She notices that many employees have duplicate records and inconsistent information. To address this issue, she decides to implement a process to reduce data redundancy and improve data integrity. What is this process called?
A technique to encrypt sensitive data.
A way to create backups of a database.
A method to increase the size of a database.
A process to reduce data redundancy and improve data integrity.
Aarush is managing a database for a library. He needs to ensure that each book in the library has a unique identifier. Which of the following is a characteristic of a primary key?
A primary key can contain NULL values.
A primary key must be unique for each record in a table.
A primary key can be duplicated across different tables.
A primary key is optional for a database table.
Mira is designing a new library system. What is the purpose of a database schema in her project?
To define the structure and organization of data in a database.
To store actual data records.
To optimize query performance.
To manage user permissions and access.
Riya is tasked with creating a new view in her database to simplify data access for her team. Which SQL command should she use to create a view?
CREATE VIEW
NEW VIEW
ADD VIEW
INSERT VIEW
In a database, what is the purpose of an index?
To enforce data integrity by preventing duplicate entries.
To define relationships between tables.
To speed up the retrieval of rows from a table.
To store large amounts of data efficiently.
During a database optimization session, Sam wants to know how to remove duplicate records from a table. What SQL command should he use?
DELETE DISTINCT FROM table_name;
SELECT DISTINCT column_name FROM table_name;
REMOVE DUPLICATES FROM table_name;
DELETE FROM table_name WHERE condition;
Rohan is studying database design and wants to understand the purpose of normalization. What is the primary goal of normalization in a database?
To increase data redundancy and improve performance.
To eliminate data anomalies and ensure data integrity.
To create more tables for better organization.
To simplify the database structure without any constraints.
Meera is tasked with ensuring that the email addresses in her database are unique. Which constraint should she apply to the email column to achieve this?
PRIMARY KEY
UNIQUE
CHECK
FOREIGN KEY
During a database review, Arjun learns about different types of constraints. What is the purpose of a CHECK constraint in SQL?
To automatically generate unique values for a column.
To create a relationship between two tables.
To ensure that a column cannot contain NULL values.
To enforce a specific condition on a column's values.
Riya is tasked with ensuring that the phone numbers in her customer database follow a specific format. What SQL constraint can she use to enforce this format?
FOREIGN KEY
CHECK
UNIQUE
DEFAULT
During a data analysis session, Sam wants to find the total revenue generated from sales. Which SQL function should he use to sum up the sales amounts?
MAX()
AVG()
COUNT()
SUM()
Aditi is creating a report that requires data from multiple tables in her database. What SQL operation should she use to combine rows from these tables based on a related column?
INTERSECT
JOIN
UNION
GROUP BY
Ravi is learning about database transactions and wants to understand the concept of ACID properties. What does the 'I' in ACID stand for?
Independence
Integrity
Isolation
Inconsistency
During a database design meeting, Priya is asked to explain the purpose of a foreign key. What is the role of a foreign key in a relational database?
To enforce data integrity by preventing NULL values.
To store large amounts of data efficiently.
To establish a link between two tables.
To uniquely identify a record in a table.
In a data analysis project, Aman needs to filter records based on specific criteria. Which SQL clause should he use to specify the conditions for filtering?
ORDER BY
HAVING
GROUP BY
WHERE
