Font size
WorksheetsMYSQL
Total questions: 25
Worksheet time: 9mins
Which SQL statement is used to delete an existing row ?
DROP
REMOVE
DELETE
UPDATE
What does DML stand for?
Data Migration Language
Data Markup Language
Data Modelling Language
Data Manipulation Language
Which statement will return different values?
SELECT UNIQUE
SELECT DISTINCT
SELECT DIFFERENT
SELECT ALL
What is the default sort order in ORDER BY clause?
Ascending
Descending
_________ statement is used to delete a table
DELETE TABLE
REMOVE TABLE
DROP TABLE
MODIFY TABLE
Which of the following is not an aggregate function?
DATE
AVG
COUNT
MAX
Which clause is used to filter out unwanted data?
SELECT
FROM
WHERE
ORDER BY
In LIKE clause, you can search for 4 letter word by saying
LIKE ' .... ' (4 dots)
LIKE '????' (4 question marks)
LIKE ' {6}'
LIKE ' _ _ _ _' (4 underscores)
Which SQL statement is used to modify data in a database table?
MODIFY
CHANGE
ALTER
UPDATE
What will be the output for SELECT LENGTH("HELLO")
5
7
HELLO
ERROR
The total number of rows in a table is called as
integer
degree
cardinality
tuples
INSERT INTO EMP VALUES(1221, 'ABC', 'MANAGER',12323); What kind of statement is this ?
DDL
DML
DCL
TCL
A relational database may have
Primary Key
Candidate Key
Foreign Key
All of these
SELECT is a DDL / DML statement ?
DDL
DML
Both
None
(a) is used to select a database
(Type in upper case)
A relational database can have how many types of keys in a table ?
Candidate key
Primary key
Foreign key
All of these
Which one of the following uniquely identifies the tuples/tows in a relation ?
Secondary key
Primary key
Composite key
Foreign key
What is the full form of DDL ?
Dynamic data language
Detailed data language
Data definition language
Data derivation language
SELECT is a DDL/DML command ....
DDL
DML
None of these
Both
Which of the following keywords will you use to display unique values of the column dept_name ?
SELECT ______ dept_name from COMPANY;
All
distinct
from
name
Which of the following SQL commands retrieves data from table(s)?
update
select
insert
delete
INSERT INTO EMP VALUES(101,'SUMAN','MANAGER');
Which kind of statement is this ?
DDL
DML
Value
Python statement
What will be the output for :-
SELECT LENGTH("EMPLOYEE");
10
8
EMPLOYEE
1
What will be the output for :-
SELECT ROUND(153.669,2);
153.6
153.7
153.67
153.66
Total number of rows/records/horizontal arrangement in a table is called:
Degree
Records
Integer
Cardinality
