1. What is the full form of SQL?
(a) Structured Query Language (b) Structured Query List
(c) Simple Query Language (d) Data Derivation Language
2. What does DML stand for?
(a) Different Mode Level (b) Data Model Language
(c) Data Mode Lane (d) Data Manipulation Language
3. The __________clause of SELECT query allows us to select only those rows in the results that satisfy a
specified condition.
(a) Where (b) from (c) having (d) like
4. Which of the following function is used to FIND the largest value from the given data in MYSQL?
(a) MAX () (b) MAXIMUM () (c) LARGEST () (d) BIG ()
5. The term ___________ is used to refer to a record in a table.
(a) Attribute (b) Tuple (c) Row (d) Instance
6. A relational database consists of a collection of
(a) Tables (b) Fields (c) Records (d) Keys
7. What is the full form of DDL?
(a) Dynamic Data Language (b) Detailed Data Language
(c) Data Definition Language (d) Data Derivation Language
8. Consider the following table namely employee:
Employee_i Nam Salar
d e y
5001 Amit 60000
5009 Sumi 45000
t
5020 Arpit 70000
Which of the names will not be displayed by the below given query?
SELECT name FROM employee WHERE employee_id>5009;
(a) Amit, Sumit (b) Sumit, Arpit (c) Arpit (d) Amit, Arpit
9. What will be the output
>>>d1={‘rohit’:56,”Raina”:99}
>>>print(“Raina” in d1)
i. True ii. False iii. No output iv. Error
10. >>>t=(1,2,3,4)
Write the statement that should be used to print the first three elements 3 times
i. >>>print(t*3) ii. >>>t*3 iii. >>>t[:3]*3 iv. >>>t+t
11. Which of the following will delete key-value pair for key=’red’ form a dictionary D1?
i. Delete D1(“red”) ii. del. D1(“red”) iii. del D1[“red”] iv. del D1
(a) Structured Query Language (b) Structured Query List
(c) Simple Query Language (d) Data Derivation Language
2. What does DML stand for?
(a) Different Mode Level (b) Data Model Language
(c) Data Mode Lane (d) Data Manipulation Language
3. The __________clause of SELECT query allows us to select only those rows in the results that satisfy a
specified condition.
(a) Where (b) from (c) having (d) like
4. Which of the following function is used to FIND the largest value from the given data in MYSQL?
(a) MAX () (b) MAXIMUM () (c) LARGEST () (d) BIG ()
5. The term ___________ is used to refer to a record in a table.
(a) Attribute (b) Tuple (c) Row (d) Instance
6. A relational database consists of a collection of
(a) Tables (b) Fields (c) Records (d) Keys
7. What is the full form of DDL?
(a) Dynamic Data Language (b) Detailed Data Language
(c) Data Definition Language (d) Data Derivation Language
8. Consider the following table namely employee:
Employee_i Nam Salar
d e y
5001 Amit 60000
5009 Sumi 45000
t
5020 Arpit 70000
Which of the names will not be displayed by the below given query?
SELECT name FROM employee WHERE employee_id>5009;
(a) Amit, Sumit (b) Sumit, Arpit (c) Arpit (d) Amit, Arpit
9. What will be the output
>>>d1={‘rohit’:56,”Raina”:99}
>>>print(“Raina” in d1)
i. True ii. False iii. No output iv. Error
10. >>>t=(1,2,3,4)
Write the statement that should be used to print the first three elements 3 times
i. >>>print(t*3) ii. >>>t*3 iii. >>>t[:3]*3 iv. >>>t+t
11. Which of the following will delete key-value pair for key=’red’ form a dictionary D1?
i. Delete D1(“red”) ii. del. D1(“red”) iii. del D1[“red”] iv. del D1
