WorksheetsMySQL Grade XII IP
Total questions: 25
Worksheet time: 13mins
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
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
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
Which SQL statement is used to delete an existing row ?
DROP
REMOVE
DELETE
UPDATE
Which of the following is not an aggregate function?
DATE
AVG
COUNT
MAX
Which of the following functions returns the position of a substring in a given string?
MID
INSTR
SUBSTR
CHAR
What will be returned by the given query?
SELECT INSTR("INDIA", "DI");
2
3
-2
-3
What will be returned by the given query?
SELECT concat("It", "was", "ok");
"It was ok"
"Itwasok"
"Itwas ok"
"Tt wasok"
What will be returned by the given query?
SELECT truncate(15.79, -1), truncate(15.79, 0), truncate(15.79, 1);
15 15 15.7
10 15.7 15.9
10 15 15.7
10 10 15.9
What will be returned by the given query?
SELECT month('2020-05-11');
5
11
May
November
What is the full form of SQL?
Structured Query Language
Structured Query List
Simple QueryLanguage
None of these
Which operator performs pattern matching?
Between Operator
Like Operator
Exists Operator
None of these
Which operator test the column for absence of data?
Not operator
and operator
is null operator
None of these
In a table there are 3 rows and 5 columns. what is the degree of the table?
5
3
0
none of these
Which of the following is not a DML command?
Update
Insert into
Delete
Create Table
Which SQL command is used to remove rows from the table customer?
Drop from customer ;
Update from customer;
remove from customer ;
Delete from customer where condition ;
SELECT * FROM sales WHERE amount > 200.
the query will display all the sales records with amounts starting from 200 and above
the query will display all the sales records with amounts less than 200
the query will display all the sales records with amounts greater than 200
the query will output sales records with the amount equal to 200.
SELECT * FROM sales WHERE amount > 200.
the query will display all the sales records with amounts starting from 200 and above
the query will display all the sales records with amounts less than 200
the query will display all the sales records with amounts greater than 200
the query will output sales records with the amount equal to 200.
Which is the default order of sort in ORDER BY clause?
ascending
descending
What could be the correct datatype for 'H.NO. 234, SEC-14' data
Date
int
varchar
decimal
Which operator is used to match column values against a list of values?
between
IN
Like
Is Null
