Completed
Revision: Class 11 SQL recap
Questions From This Challenge
Q1mcq1 mark
What is a key advantage of using a DBMS (Database Management System) over a traditional file-based system?
It eliminates the need for any data storage
It reduces data redundancy and allows controlled, shared access to data ✓
It only allows one user to access data at a time, which is faster
It removes the need for a primary key in any table
Q2mcq1 mark
In the relational data model, the term "domain" refers to:
The name of the database server
The set of all possible/permissible values that an attribute (column) can take ✓
A single row of a table
The primary key of a table
Q3mcq1 mark
In relational database terminology, a "tuple" refers to:
A column of a table
A single row of a relation (table) ✓
The complete table itself
A constraint applied to a table
Q4mcq1 mark
A "candidate key" of a relation is:
Any attribute that contains only numeric values
An attribute or a set of attributes that can uniquely identify each tuple in the relation ✓
The last column defined in the CREATE TABLE statement
A key that is always made up of exactly two attributes
Q5mcq1 mark
A table has two candidate keys: AdmissionNo and AadhaarNo. If AdmissionNo is chosen as the primary key, AadhaarNo is then called the:
Foreign key
Alternate key ✓
Composite key
Domain key
Q6mcq1 mark
Which SQL command permanently removes an entire table, including its structure and all data, from the database?
DELETE
ALTER
DROP ✓
UPDATE
Q7mcq1 mark
Which SQL command is used to add a new column to an already existing table?
ALTER TABLE ... ADD ✓
CREATE TABLE
DROP TABLE
INSERT INTO
Q8mcq1 mark
Which of the following is a DML (Data Manipulation Language) command used to add new rows of data into an existing table?
CREATE TABLE
INSERT ✓
ALTER
DROP
Q9mcq1 mark
In a SQL WHERE clause, which of the following correctly checks whether the value of Marks lies within the inclusive range 40 to 80?
WHERE Marks BETWEEN 40 AND 80 ✓
WHERE Marks > 40 < 80
WHERE Marks = 40 OR 80
WHERE Marks BETWEEN 40, 80
Q10output1 mark
Table Student(RollNo INT, Name VARCHAR(20), Marks INT) is created. The following statements are then executed in order. What is the final content of the table? (format: RollNo | Name | Marks, one row per line)
CREATE TABLE Student(RollNo INT, Name VARCHAR(20), Marks INT); INSERT INTO Student VALUES (1,'Aman',78),(2,'Riya',65); INSERT INTO Student VALUES (3,'Karan',82); SELECT RollNo, Name, Marks FROM Student;
Correct output:
1 | Aman | 78
2 | Riya | 65
3 | Karan | 82Q11output1 mark
Table Employee(EmpId INT, EName VARCHAR(20), Salary INT) has rows (1,'Rohit',30000), (2,'Anita',35000), (3,'Vikas',28000). The following statements are executed. What is the output? (format: EmpId | EName | Salary)
UPDATE Employee SET Salary = Salary + 2000 WHERE EmpId = 3; SELECT EmpId, EName, Salary FROM Employee WHERE EmpId = 3;
Correct output:
3 | Vikas | 30000Q12output1 mark
Table Book(BookId INT, Title VARCHAR(20), Price INT) has rows (1,'Maths',300), (2,'Science',220), (3,'English',250), (4,'Hindi',180). The following statements are executed. What is the output? (format: BookId | Title, one row per line)
DELETE FROM Book WHERE Price < 200; SELECT BookId, Title FROM Book;
Correct output:
1 | Maths
2 | Science
3 | EnglishQ13output1 mark
Table Product(PId INT, PName VARCHAR(20), Price INT) has rows (1,'Pen',10), (2,'Bag',450), (3,'Pencil',5), (4,'Bottle',180), (5,'Notebook',60). What is the result of: SELECT PName, Price FROM Product WHERE Price BETWEEN 50 AND 200; (format: PName | Price, one row per line)
SELECT PName, Price FROM Product WHERE Price BETWEEN 50 AND 200;
Correct output:
Bottle | 180
Notebook | 60Q14output1 mark
Table Teacher(TId INT, TName VARCHAR(20), Dept VARCHAR(20), Experience INT) has rows (1,'Mehta','Science',12), (2,'Iyer','Arts',5), (3,'Sharma','Science',15), (4,'Rao','Commerce',8). What is the result of: SELECT TName FROM Teacher WHERE Dept = 'Science' AND Experience > 10;
SELECT TName FROM Teacher WHERE Dept = 'Science' AND Experience > 10;
Correct output:
Mehta
SharmaQ15output1 mark
Table Student2(RollNo INT, Name VARCHAR(20), Phone VARCHAR(15)) has rows (1,'Priya','9876543210'), (2,'Aakash',NULL), (3,'Meena','9123456780'), (4,'Suresh',NULL). What is the result of: SELECT RollNo, Name FROM Student2 WHERE Phone IS NULL; (format: RollNo | Name, one row per line)
SELECT RollNo, Name FROM Student2 WHERE Phone IS NULL;
Correct output:
2 | Aakash
4 | Suresh