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: Sep 23, 2024
- 01/07/99
- 25/02/97
- 31/07/97
- 10/1/97
Hide 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: Sep 23, 2024
- 9
- 7
- 8
- NULL
Hide 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: Sep 23, 2024
- 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';
Hide 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: Sep 23, 2024
- Delete from Teacher;
- Delete from Teacher where No = 7;
- Delete from Teacher, where No = '7';
- Delete * from Teacher where No = 7;
Hide 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: Sep 23, 2024
- A, B and D only
- C and D only
- A and D only
- B, C and D only
Hide 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 Questions on Reading Comprehension
Read the sentence and infer the writer's tone: "The politician's speech was filled with lofty promises and little substance, a performance repeated every election season."
- CUET (UG) - 2025
- English
- Reading Comprehension
- Read the sentence and answer the question: ``Not only did he forget my birthday, but he also ignored my calls the next day." Which of the following best describes the tone?
- CUET (UG) - 2025
- English
- Reading Comprehension
- Read the passage and answer the The Reserve Bank of India was established in the year 1935. The Central office of RBI is in Mumbai. The main function of the Reserve Bank of India is to regulate the issue of Bank Notes and keeping of reserves with a view to securing monetary stability in India. It generally operates the currency and credit system of the country to its advantage. In this passage, ‘Bank Notes’ refers to
- KMAT KERALA - 2025
- English
- Reading Comprehension
- Read the passage and answer the Animals are the most adorable and loving creatures existing on Earth. They may not be able to speak but they can understand. Domestic animals mostly move with humans. Wild animals generally live in forests. Animals play a vital role in maintaining nature’s balance. This passage primarily focused on the importance of
- KMAT KERALA - 2025
- English
- Reading Comprehension
- Read the passage and answer the A psychotropic drug is a chemical substance that changes the function of the nervous system. If the charges under the Narcotics Drugs and Psychotropic substances Act are proved, the accused will get a deterrent punishment. Police will take in drug addicts and admit them in centres for rehabilitation. This passage primarily focused on
- KMAT KERALA - 2025
- English
- Reading Comprehension
View More Questions
Questions Asked in CUET exam
- Which region was known as the ‘nursery of the Bengal Army’ as many sepoys were recruited from there?
- CUET (UG) - 2025
- British Empire
- A shopkeeper increases the price of an article by 25% and then offers a discount of 20%. What is the net percentage change in the price?
- CUET (UG) - 2025
- Percentage
- In a certain code, WATER is written as YCVGT. How is HOUSE written?
- CUET (UG) - 2025
- Coding Decoding
- A person walks 10 m North, then turns right and walks 5 m, then turns right again and walks 10 m. What direction is he facing now?
- CUET (UG) - 2025
- Direction sense
- A and B can complete a task in the ratio 3:2. If together they complete the task in 20 days, how long will A alone take?
- CUET (UG) - 2025
- Time and Work
View More Questions