Suppose a student column has two columns, name and marks. How to get name and marks of top three students.
Answer / krishna
SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)
Is This Answer Correct ? | 4 Yes | 0 No |
Mention different types of joins?
What is data driven test?
Explain what is data driven test?
How to test data loading in data base testing?
In the database testing process, what do we usually check?
How to test a dts package created for data insert update and delete? What should be considered in the above case while testing it? What conditions are to be checked if the data is inserted, updated or deleted using a text files?
What do we usually check in database testing?
What is the database trigger, how to verify the trigger is fired or not and can you invoke trigger on demand?
What are indexes and mention different types of indexes?
How would you know for database testing, whether trigger is fired or not?
How do you test whether a database in updated when information is entered in the front end?
You don’t have much time or only one day time, you have to execute 100 test cases, how you will execute