...
August 28, 2024

SQL

Question 123 Consider the following query : SELECT E.eno, COUNT(*) FROM Employees E GROUP BY E.eno If an index on eno is available, the query can […]
Do you like it?
0 Read more
August 28, 2024

SQL

Question 120 Consider the following relational schema: Suppliers( sid:integer, sname:string, city:string, street:string ) Parts( pid:integer, pname:string, color:string) Catalog( sid:integer, pid:integer, cost:real) Consider the following relational query […]
Do you like it?
0 Read more
August 28, 2024

Database-Management-System

Question 714 The command used to see the fields of the table along with their datatypes in SQL is A Select fields from dual where table=”MANAGER”; […]
Do you like it?
0 Read more
August 28, 2024

Database-Management-System

Question 882 Consider the schema Sailors(sid, sname, rating, age) with the following data For the query SELECT S.rating, AVG(S.age) AS average FROM Sailors S Where S.age […]
Do you like it?
0 Read more
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162