Font size
WorksheetsSQL basics MBA
Total questions: 51
Worksheet time: 27mins
select all DDL commands are:-
UPDATE
ALTER
DROP
DELETE
Which join would you use to create a query that returns ALL data from Table B and only those on Table A that match?
Inner Join
Left Join
Right Join
Full Outer Join
What does the acronym "RDBMS" stand for, and how does it differ from a regular database?
Relational Database Management System, stores data in tables with relationships
Random Database Management System, organizes data without any specific structure
Redundant Database Management System, duplicates data for backup purposes
Resourceful Database Management System, efficiently manages system resources
The “AS” keyword is optional while specifying an alias for a field name in a select statement
True
False
Which of the following is not a type of SQL statement?
Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Control Language (DCL)
Data Communication Language (DCL)
A_____ is a query that retrieves rows from more than one table or view
Start
End
Join
All of the above
If you were wanting to filter data, which clause would you use?
Where
Order by
From
Select
Which statement is used to extract data from a database?
Extract
Get
Open
Select
Relational Database
NoSQL
SQL
Which of the following is not a NoSQL database?
Cassandra
MongoDB
SQL Server
None of the above
Which join will exclude rows that don’t match in either table?
LEFT
RIGHT
INNER
ALL OF THEM
Which join type will include all rows from the left table, even if there’s no match in the right table?
LEFT
RIGHT
INNER
ALL OF THEM
Which type of join can show NULL values for rows without a match?
LEFT
RIGHT
INNER
ALL OF THEM
If we use a LEFT JOIN, which data will we see in the result?
Only data that matches in both tables
All data from the left table and matching data from the right table
Only data from the right table
All data from both tables
Which type of join will only show data that is matched in both tables?
LEFT
RIGHT
INNER
OUTER
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
What does the "S" in SQL stand for?
Several
Structured
Syntax
Semi-precise
SELECT DISTINCT Country FROM Customers;
The above statement provides the list of countries in the table 'Customers'.
True
False
Select the statement to display all data from a table that contains the columns index_number, customer_name, customer_address and phone_number
SELECT index_number FROM table;
SELECT index_number, customer_name, customer_address, phone_number FROM table;
SELECT * FROM table;
None of the above
Which of the following is used to delete a table?
SELECT
DELETE
DROP
ALTER
SELECT statement is used to ..
Write data to table
Update data to table
Read data from table
Delete from table
Semicolon (;) is the standard way to separate each SQL statement in database systems.
True
False
Semicolon (;) is the standard way to separate each SQL statement in database systems.
True
False
RDBMS stands for?
Relational Database Management System
Rational Database Management System
Relational Data Management System
Relational Database Management Society
What does DML stand for in SQL?
Data Manipulation Language
Database Modification Language
Data Modeling Language
Data Management Language
Data Merge Language
In SQL, which of the following is used to retrieve the lowest value in a column?
MIN()
MAX()
SUM()
COUNT()
AVG()
Which SQL command is used to modify the structure of an existing table?
ALTER TABLE
UPDATE TABLE
MODIFY TABLE
CHANGE TABLE
RENAME TABLE
In SQL, which clause specifies the source tables for the query?
FROM
WHERE
SELECT
JOIN
WITH
What is the purpose of the INNER JOIN in SQL?
To combine rows from two or more tables based on a related column
To remove duplicates from a result-set
To return rows that do not have matching values in both tables
To select columns from a single table
To modify the structure of a table
Which SQL statement is used to update data in a database?
UPDATE
MODIFY
ALTER
CHANGE
RENAME
In a SELECT query, what does DISTINCT do?
Returns only unique values
Filters rows based on a condition
Groups rows based on a column
Deletes duplicate rows
Sorts the result-set in descending order
Which clause is used to sort the result-set in SQL?
ORDER BY
GROUP BY
SORT
LIMIT
FILTER
Which of the following SQL aggregate functions returns the number of selected rows?
COUNT(*)
SUM()
AVG()
MIN()
MAX()
What does the WHERE clause do in SQL?
Specifies the selection condition for rows
Specifies the order of the output
Specifies the table from which to retrieve data
Joins two tables together
Sorts the output
Which SQL command is used to delete a table?
DROP TABLE
DELETE TABLE
REMOVE TABLE
TRUNCATE TABLE
ERASE TABLE
What is the main purpose of the SELECT clause in SQL?
To specify the attributes to be shown in the result table
To specify the source tables to access
To define the condition for row selection
To delete data from the table
To count the number of rows
What keyword is used to select all columns from a table in SQL?
*
ALL
#
%
$
Which SQL statement is used to insert new data into a database?
INSERT INTO
ADD NEW
PUT
CREATE
UPDATE
In SQL, which clause is used to filter records?
WHERE
SELECT
FROM
ORDER BY
LIMIT
Which SQL statement is used to select data from a database?
SELECT
UPDATE
DELETE
INSERT
MODIFY
What does SQL stand for?
Structured Query Language
Simple Query Language
Structured Question Language
Standard Query Language
Semantic Query Language
from the following option select the wrong one.
AND
OR
NOT
greater than equal to
_____ is used to filter out the data by applying condition on grouped data.
where
from
having
order by
____ is the clause which we use to choose the required data in the OUTPUT from the original table.
select
where
group by
drop, truncate, create are the commands of DDL?
True
False
Which option is not the command of DML ?
insert
update
alter
delete
_____ is the logical skeleton of the database
Views
Tables
database
schema
A _____ is a place where we can used to store huge amounts of structured data from different databases in a one place.
database
data lake
cloud
data warehouse
Is images and videos being the example of the Structured data?
Yes
No
What kind of database we and SQL will be mostly deal with ?
Hierarchical Database
Network Database
Relational Database
Object oriented database
Which is not the sub language of SQL?
DDL
DML
DCL
PCL
