Comprehension
Consider the following table and answer the questions that follow :
Teacher
Teacher
| No | Name | Age | Department | Dob | Salary | Sex |
| 1 | Jagan | 34 | Comp | 10/1/97 | 12000 | M |
| 2 | Shona | 31 | Hist | 24/3/98 | NULL | F |
| 3 | Sandeep | 32 | Maths | 12/12/98 | 30000 | M |
| 4 | Sangita | 35 | Hist | 01/07/99 | 40000 | F |
| 5 | Rohit | 42 | Maths | 05/09/97 | 25000 | M |
| 6 | Sharma | 50 | Hist | 27/06/98 | 30000 | M |
| 7 | Amit | 44 | Comp | 25/02/97 | 21000 | M |
| 8 | Girisha | NULL | Maths | 31/07/97 | 20000 | F |
Question: 1
Choose the correct output of the following SQL query
Select min(Dob) from Teacher;
Choose the correct output of the following SQL query
Select min(Dob) from Teacher;
Select min(Dob) from Teacher;
Updated On: Feb 21, 2026
- 01/07/99
- 25/02/97
- 31/07/97
- 10/1/97
Show Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The correct option is (D) :10/1/97.
Was this answer helpful?
0
0
Question: 2
Choose the correct output of the following query
select count(Age) from Teacher;
Choose the correct output of the following query
select count(Age) from Teacher;
select count(Age) from Teacher;
Updated On: Feb 21, 2026
- 9
- 7
- 8
- NULL
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :7.
Was this answer helpful?
0
0
Question: 3
Choose the correct query to display Names of Teachers along with Salary of those Teachers who are in History department ?
Choose the correct query to display Names of Teachers along with Salary of those Teachers who are in History department ?
Updated On: Feb 21, 2026
- Select Name from Teacher where Department - 'History';
- Select Name, Salary from Teacher where Department = 'Hist';
- Select Name, Salary from Teacher where Department - 'History';
- Select Salary from Teacher where Department = 'Hist';
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :Select Name, Salary from Teacher where Department = 'Hist';
Was this answer helpful?
0
0
Question: 4
Suppose the teacher with No - 7 left the school, suggest the correct query to delete that record from the teacher table :
Suppose the teacher with No - 7 left the school, suggest the correct query to delete that record from the teacher table :
Updated On: Feb 21, 2026
- Delete from Teacher;
- Delete from Teacher where No = 7;
- Delete from Teacher, where No = '7';
- Delete * from Teacher where No = 7;
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :Delete from Teacher where No = 7;
Was this answer helpful?
0
0
Question: 5
Choose the correct statement with reference to SQL table Teacher
A. Alter table Teacher is used to make changes in the structure of the table
B. Update Teacher is used to modify existing data in the table
C. Desc Teacher will display the tuples in sorted order
D. Select * from Teacher will display all the attributes along with their data types
Choose the correct answer from the options given below :
Choose the correct statement with reference to SQL table Teacher
A. Alter table Teacher is used to make changes in the structure of the table
B. Update Teacher is used to modify existing data in the table
C. Desc Teacher will display the tuples in sorted order
D. Select * from Teacher will display all the attributes along with their data types
Choose the correct answer from the options given below :
A. Alter table Teacher is used to make changes in the structure of the table
B. Update Teacher is used to modify existing data in the table
C. Desc Teacher will display the tuples in sorted order
D. Select * from Teacher will display all the attributes along with their data types
Choose the correct answer from the options given below :
Updated On: Feb 21, 2026
- A, B and D only
- C and D only
- A and D only
- B, C and D only
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :C and D only.
Was this answer helpful?
0
0
Top CUET Questions
Select the statements that are CORRECT regarding patterns of biodiversity.
(A) Species diversity increases as we move away from the equator towards the poles(B) The tropical Amazon rain forest in South America has the greatest biodiversity on earth.(C) There is more solar energy available in the temperate region than tropics.(D) Tropical environments are less seasonal relatively more constant and predictableWhich of the following hormone is not produced by placenta ?
- Individuals with karyotype of 44+XXY having overall masculine development with few feminine development like Gynaecomastia has _______ chromosomal disorder.
- Match List - I with List - II.Choose the correct answer from the options given below :
List - I
List - II
A Streptokinase I Blood-Cholestrol lowering agents B Cyclosporin II Clot Buster C Statins III Propionibacterium sharmanii D Swiss Cheese IV Immuno suppressive agent Which of the following option determines percolation and water holding capacity of soils ?
View More Questions