Question
Average marks scored by Vineet in five subjects are 85.
The average marks scored by him (excluding his highest and lowest marks) are 65 and lowest marks scored by him are 50. Find the highest marks scored by him.Solution
Sum of marks scored by him in five subjects = 5 x 85 = 425 Sum of marks scored by him (excluding his highest and lowest marks) = 3 x 65 = 195 Therefore, sum of highest and lowest marks = 425 β 195 = 230 So, highest marks scored by him = 230 β 50 = 180
Which command is used to remove all records from a table without deleting the table structure?
A primary key in a table:
Which of the following is used to eliminate redundancy and anomalies in a database?
Which of the following is true about a view in SQL?
What is early binding in the context of OOP?
The result of a Cartesian product of two relations R and S will have:
Which of the following is a valid constraint in SQL?
Which SQL keyword is used to sort the result set?