Recent questions tagged sql - GATE CSE Doubts

0 votes

0 answers

GATE2005-77, ISRO2016-55 Video Solution
The relation book (title,price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list? select title from book as B where (select count(*) from ... books Title of the fifth most inexpensive book Title of the fifth most expensive book Titles of the five most expensive books

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2012-15 Video Solution
Which of the following statements are TRUE about an SQL query? P : An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q : An SQL query can contain a HAVING clause only if it has a GROUP BY clause R : All attributes used in ... Not all attributes used in the GROUP BY clause need to appear in the SELECT clause P and R P and S Q and R Q and S

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2009-55 Video Solution
Consider the following relational schema: $\text{Suppliers}(\underline{\text{sid:integer}},\text{ sname:string, city:string, street:string})$ $\text{Parts}(\underline{\text{pid:integer}}, \text{ pname:string, color:string})$ ... of all suppliers who have supplied only non-blue part. Find the names of all suppliers who have not supplied only blue parts.

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2007-61 Video Solution
Consider the table employee(empId, name, department, salary) and the two queries $Q_1, \, Q_2$ below. Assuming that department 5 has more than one employee, and we want to find the employees who get higher salary than anyone in the department 5, which one ... $Q_1$ and $Q_2$ produce the same answer Neither $Q_1$ nor $Q_2$ is the correct query

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2009-56 Video Solution
Consider the following relational schema: $\text{Suppliers}(\underline{\text{sid:integer}},\text{ sname:string, city:string, street:string})$ $\text{Parts}(\underline{\text{pid:integer}}, \text{ pname:string, color:string})$ ... $3NF$ but not in $\text{BCNF}$ The schema is in $2NF$ but not in $3NF$ The schema is not in $2NF$

asked Apr 18 in Databases by admin (3.6k points) | 2 views

0 votes

0 answers

GATE2006-67 Video Solution
Consider the relation account (customer, balance) where the customer is a primary key and there are no null values. We would like to rank customers according to decreasing balance. The customer with the largest balance gets rank 1. Ties are not broke but ranks are skipped ... ranks using ODBC. Which two of the above statements are correct? 2 and 5 1 and 3 1 and 4 3 and 5

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2006-IT-85 Video Solution
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are did and cid respectively and the records are stored in ascending order of these primary keys as given in the tables. No indexing is available in the database. ... key, then $n$ lies in the range: $36 - 40$ $44 - 48$ $60 - 64$ $100 - 104$

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2014-1-22 Video Solution
Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table $R(a,b,c)$ where $a$ and $b$ together form the primary key, the following is a valid table definition. CREATE TABLE S ... ? S1 is TRUE and S2 is FALSE Both S1 and S2 are TRUE S1 is FALSE and S2 is TRUE Both S1 and S2 are FALSE

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2006-68 Video Solution
Consider the relation enrolled (student, course) in which (student, course) is the primary key, and the relation paid (student, amount) where student is the primary key. Assume no null values and no foreign keys or integrity ... which Query3 returns strictly fewer rows than Query2 There exist databases for which Query4 will encounter an integrity violation at runtime

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2014-2-54 Video Solution
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested query shown below: select * from R where a in (select S.a from S) select R.* ... distinct a from S) as S1 where R.a=S1.a select R.* from R,S where R.a=S.a and is unique R

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2000-2.26 Video Solution
In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are treated as false. Which of the following pairs is not equivalent? $x = 5 \quad not (not (x = 5))$ $x = 5 \quad x > 4$ and $x < 6,$ where $x$ is an integer $x ≠ 5 \quad not (x = 5)$ none of the above

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2019-51 Video Solution
A relational database contains two tables Student and Performance as shown below: ... S, Performance P WHERE P.Marks >84 GROUP BY S.Student_name; The number of rows returned by the above SQL query is ________

asked Apr 18 in Databases by admin (3.6k points) | 2 views

0 votes

0 answers

GATE2017-2-46 Video Solution
Consider the following database table named $\text{top_scorer}$ ... (SELECT tc.goals FROM top_scorer AS tc WHERE tc.country='Germany') The number of tuples returned by the above SQL query is ______

asked Apr 18 in Databases by admin (3.6k points) | 2 views

0 votes

0 answers

GATE2000-2.25 Video Solution
Given relations r(w, x) and s(y, z) the result of select distinct w, x from r, s is guaranteed to be same as r, provided. r has no duplicates and s is non-empty r and s have no duplicates s has no duplicates and r is non-empty r and s have the same number of tuples

asked Apr 18 in Databases by admin (3.6k points) | 6 views

0 votes

0 answers

GATE1999-2.25 Video Solution
Which of the following is/are correct? An SQL query automatically eliminates duplicates An SQL query will not work if there are no indexes on the relations SQL permits attribute names to be repeated in the same relation None of the above

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2015-1-27 Video Solution
Consider the following relation: ... P WHERE S.Roll_No= P.Roll_No GROUP BY S.STUDENT_Name The numbers of rows that will be returned by the SQL query is_________________.

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2013-35 Video Solution
Consider the following relational schema. Students(rollno: integer, sname: string) Courses(courseno: integer, cname: string) Registration(rollno: integer, courseno: integer, percent: real) Which of the following queries are equivalent to this query in English? Find the distinct names of ... I, II, III and IV I, II and III only I, II and IV only II, III and IV only

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2008-IT-74 Video Solution
Student (school-id, sch-roll-no, sname, saddress) School (school-id, sch-name, sch-address, sch-phone) Enrolment(school-id sch-roll-no, erollno, examname) ExamResult(erollno, examname, marks) What does the following SQL query output? SELECT sch-name, ... of the school and the number of its students scoring 100 in at least one exam nothing; the query has a syntax error

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2017-1-23 Video Solution
Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on it are given below: ... (SELECT DeptName, COUNT(EmpId) AS EC(DeptName, Num) FROM EMP GROUP BY DeptName) The output of executing the SQL query is _____________ .

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2014-3-54 Video Solution
Consider the following relational schema: employee (empId,empName,empDept) customer (custId,custName,salesRepId,rating) salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. ... customers having a 'GOOD' rating. Names of all the employees with all their customers having a 'GOOD' rating.

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2006-69 Video Solution
Consider the relation enrolled (student, course) in which (student, course) is the primary key, and the relation paid (student, amount) where student is the primary key. Assume no null values and no foreign keys or integrity constraints. Assume that ... executes faster than Plan 2 for all databases For x = 9000, Plan I executes slower than Plan 2 for all databases

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2014-1-54 Video Solution
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their respective ... of pairwise comparison. It generates an error because of the GROUP BY clause cannot be used with table joins in a sub-query.

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2005-IT-69 Video Solution
In an inventory management system implemented at a trading corporation, there are several tables designed to hold all the information. Amongst these, the following two tables hold information on which items are supplied by which suppliers, and which warehouse ... who do not supply any item supply exactly one item supply one or more items supply two or more items

asked Apr 18 in Databases by admin (3.6k points) | 2 views

0 votes

0 answers

GATE2016-2-52 Video Solution
Consider the following database table named water_schemes: ... total_avg (capacity) as select avg (capacity) from total select name from total, total_avg where total.capacity ≥ total_avg.capacity

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2003-86 Video Solution
Consider the set of relations shown below and the SQL query that follows. Students: (Roll_number, Name, Date_of_birth) Courses: (Course_number, Course_name, Instructor) Grades: (Roll_number, Course_number, Grade) Select distinct Name from Students, Courses, Grades where ... students who have got an A grade in at least one of the courses taught by Korth None of the above

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2012-51 Video Solution
Consider the following relations $A, B$ and $C:$ ... contain? SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = Arun') $4$ $3$ $0$ $1$

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2005-IT-68 Video Solution
A table 'student' with schema (roll, name, hostel, marks), and another table 'hobby' with schema (roll, hobbyname) contains records as shown below: ... between the number of rows output by the SQL statement and the number of tuples in $S'$ is $6$ $4$ $2$ $0$

asked Apr 18 in Databases by admin (3.6k points) | 2 views

0 votes

0 answers

GATE2015-3-3 Video Solution
Consider the following relation Cinema($\textit{theater, address, capacity}$) Which of the following options will be needed at the end of the SQL query SELECT P1.address FROM Cinema P1 such that it always finds the addresses of theaters with maximum capacity? ... (select max(P2.capacity) from Cinema P2) WHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2001-2.25 Video Solution
Consider a relation geq which represents "greater than or equal to", that is, $(x,y) \in $ geq only if $y \geq x$. create table geq ( ib integer not null, ub integer not null, primary key ib, foreign key (ub) references geq on delete cascade ); Which ... (z,w) with z > x is deleted A tuple (z,w) with w < x is deleted The deletion of (x,y) is prohibited

asked Apr 18 in Databases by admin (3.6k points) | 0 views

0 votes

0 answers

GATE2004-IT-74 Video Solution
A relational database contains two tables student and department in which student table has columns roll_no, name and dept_id and department table has columns dept_id and dept_name. The following insert statements were executed successfully to populate the empty tables: ... department 0 row and 4 columns 3 rows and 4 columns 3 rows and 5 columns 6 rows and 5 columns

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2011-32 Video Solution
Consider a database table T containing two columns $\text{X}$ and $\text{Y}$ each of type $\text{integer}$. After the creation of the table, one record $\text{(X=1, Y=1)}$ is inserted in the table. Let $\text{MX}$ and $\text{MY}$ ... will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7; 127 255 129 257

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2018-12 Video Solution
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock(isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn=S.isbn; Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN ... above is certain to have an output that is a superset of the outputs of the other three queries? Query 1 Query 2 Query 3 Query 4

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2011-46 Video Solution
Database table by name $\text{Loan_Records}$ ... Bank_Manager FROM Loan_Records) AS S NATURAL JOIN (SELECT Bank_Manager, Loan_Amount FROM Loan_Records) AS T ); $3$ $9$ $5$ $6$

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2015-1-7 Video Solution
SELECT operation in SQL is equivalent to The selection operation in relational algebra The selection operation in relational algebra, except that SELECT in SQL retains duplicates The projection operation in relational algebra The projection operation in relational algebra, except that SELECT in SQL retains duplicates

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2010-19 Video Solution
A relational schema for a train reservation database is given below. passenger(pid, pname, age) reservation(pid, class, tid) ... (SELECT * FROM Passenger WHERE age>65 AND Passenger.pid=Reservation.pid) $1, 0$ $1, 2$ $1, 3$ $1, 5$

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2004-IT-78 Video Solution
Consider two tables in a relational database with columns and rows as follows: ... 1 Both i and ii will fail i will fail but ii will succeed i will succeed but ii will fail Both i and ii will succeed

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2004-53 Video Solution
The employee information in a company is stored in the relation Employee (name, sex, salary, deptName) Consider the following SQL query Select deptName From Employee Where sex = M' Group by deptName Having avg(salary) > (select avg ( ... salary of employees in same the department the average salary of male employees is more than the average salary in the company

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE2004-IT-76 Video Solution
A table T1 in a relational database has the following rows and columns: ... set marks = marks + 5 Select avg(marks) from T1 What is the output of the select statement? $18.75$ $20$ $25$ $\text{Null}$

asked Apr 18 in Databases by admin (3.6k points) | 1 view

0 votes

0 answers

GATE1998-7-a Video Solution
Suppose we have a database consisting of the following three relations. $\text{FREQUENTS (student, parlor)}$ giving the parlors each student visits. $\text{SERVES (parlor, ice-cream)}$ ... Express the following in SQL: Print the students that frequent at least one parlor that serves some ice-cream that they like.

asked Apr 18 in Databases by admin (3.6k points) | 3 views

0 votes

0 answers

GATE2002-15 Video Solution
A university placement center maintains a relational database of companies that interview students on campus and make job offers to those successful in the interview. The schema of the database is given below: ... students were offered jobs, the name of the degree and the average offered salary of students in this degree program.

asked Apr 18 in Databases by admin (3.6k points) | 1 view

Page:

7,376 questions

1,741 answers

10,682 comments

90,352 users