Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Recent questions tagged sql
2
votes
1
answer
61
Write SQL query
Write SQL query to show all employees hired on June 4,1984 (non-default format) emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
Subhrangsu
asked
in
Databases
Jun 18, 2022
by
Subhrangsu
446
views
sql
databases
query
0
votes
1
answer
62
SQL Query Question
Consider the relational database given below. Give an expression in SQL for each of the following queries. employee (person-name, street, city) works (person-name, company-name, salary) company (company-name, city) manages (person-name, manager-name) a. ... such cases, give only a 3 percent raise e. Delete all tuples in the works relation for employees of Small Bank Corporation.
varun29
asked
in
Databases
Apr 28, 2022
by
varun29
4.4k
views
databases
sql
1
vote
1
answer
63
Self Doubt
I want to join the two tables of movies and actors and then output only those results that have gender =”F”, can you tell me where I am going wrong?
tusharb
asked
in
Databases
Mar 27, 2022
by
tusharb
695
views
sql
databases
joins
25
votes
5
answers
64
GATE CSE 2022 | Question: 46
Consider the relational database with the following four schemas and their respective instances. Student(sNo, sName, dNo) Dept(dNo, dName) Course(cNo, cName, dNo) Register(sNo, cNo) ... SELECT cNo FROM Register WHERE sNo = S.sNo) The number of rows returned by the above $\text{SQL}$ query is ____________.
Arjun
asked
in
Databases
Feb 15, 2022
by
Arjun
12.4k
views
gatecse-2022
numerical-answers
databases
sql
2-marks
0
votes
2
answers
65
What would be the result of this query
Source Made Easy Test Serires Can anyone please tell me the answer for this, with explaination. According to me it will give the customer who buy from atleast one store, but the answer given is customer who buy from all stores.
print
asked
in
Databases
Jan 21, 2022
by
print
463
views
databases
sql
0
votes
2
answers
66
SQL - databases
Consider the following relations: How many number of records will be returned by the following query?
atulcse
asked
in
Databases
Jan 16, 2022
by
atulcse
810
views
databases
sql
made-easy-test-series
0
votes
2
answers
67
MADE EASY TEST SERIES
Consider the following relations and query given below: Emp( Id, Name, Sex, Salary) Proj(No, Name, Dno) and Works_on(No, IDs) contains atleast one tuples. Consider the following query: Select Name From Emp Where NOT Exists ((Select No From Proj where Dno = 106) EXCEPT (select No from works_on where Id = IDs)); What does this query return?
learner 2102
asked
in
Databases
Jan 5, 2022
by
learner 2102
531
views
databases
made-easy-test-series
sql
3
votes
2
answers
68
Applied Test Series
Consider the following schema: Create table A(a1 int not null primary key, a2 int); Create table B(b1 int not null primary key, b2 int references A(a1) on delete cascade on update no action); Create table C(c1 int not null primary key, c2 int references ... number of tuples present in the relation B, and C after running the query Delete from A where a1 = 1; will be __________
LRU
asked
in
Databases
Nov 5, 2021
by
LRU
684
views
test-series
databases
referential-integrity
sql
1
vote
1
answer
69
SQL - outer join - ACE workbook
An outer join can be done between: a. only two tables b. only three tables c. any number of tables
atulcse
asked
in
Databases
Oct 31, 2021
by
atulcse
437
views
sql
databases
1
vote
3
answers
70
UGC NET CSE | December 2019 | Part 2 | Question: 22
Given two tables EMPLOYEE (EID, ENAME, DEPTNO) DEPARTMENT (DEPTNO, DEPTNAME) Find the most appropriate statement of the given query: Select count (*) total' from EMPLOYEE where DEPTNO IN (D1,D2) group by DEPTNO having count (*) > ... total number of employees in both departments $D1$ and $D2$ The output of the query must have at least two rows
soujanyareddy13
asked
in
Databases
May 12, 2021
by
soujanyareddy13
1.5k
views
ugcnetcse-dec2019-paper2
sql
16
votes
2
answers
71
GATE CSE 2021 Set 2 | Question: 31
The relation scheme given below is used to store information about the employees of a company, where $\textsf{empId}$ is the key and $\textsf{deptId}$ indicates the department to which the employee is assigned. Each employee ... average salary of employees in the department employees in the company female employees in the department female employees in the company
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
6.0k
views
gatecse-2021-set2
databases
sql
easy
2-marks
32
votes
2
answers
72
GATE CSE 2021 Set 1 | Question: 23
A relation $r(A, B)$ in a relational database has $1200$ tuples. The attribute $A$ has integer values ranging from $6$ to $20$, and the attribute $B$ has integer values ranging from $1$ to $20$. Assume that the attributes $A$ and $B$ are independently distributed. The estimated number of tuples in the output of $\sigma _{(A>10)\vee(B=18)}(r)$ is ____________.
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
12.8k
views
gatecse-2021-set1
databases
sql
numerical-answers
1-mark
1
vote
1
answer
73
NIELIT Scientific Assistant A 2020 November: 45
$(<\text{ALL})$ comparison operator means: more than the maximum value in the subquery less than the minimum value in the subquery is equivalent to $\text{IN}$ none of the options
gatecse
asked
in
Databases
Dec 9, 2020
by
gatecse
538
views
nielit-sta-2020
databases
sql
1
vote
1
answer
74
NIELIT Scientific Assistant A 2020 November: 91
With the following syntax INSERT INTO table[(column[,column...])] VALUES (value[, value...]); you can: Insert one row at a time Insert multiple rows at a time Insert one column at a time Insert multiple columns at a time
gatecse
asked
in
Databases
Dec 9, 2020
by
gatecse
496
views
nielit-sta-2020
databases
sql
1
vote
1
answer
75
NIELIT Scientific Assistant A 2020 November: 98
When retrieving data in particular table in PostgreSQL, we use the ______ statement. \dt ORDER BY SELECT FROM \i
gatecse
asked
in
Databases
Dec 9, 2020
by
gatecse
426
views
nielit-sta-2020
databases
sql
1
vote
1
answer
76
UGC NET CSE | October 2020 | Part 2 | Question: 96
Consider the following table structures related to a university for the below question. EMPLOYEE NAME VARCHAR (30) NOT NULL, EID VARCHAR (10) NOT NULL, DEPTNO INT (5) NOT NULL, HODEID VARCHAR (10), SALARY INT (10), PRIMARY ... DISTINCT EMPID FROM PROJECTWORK WHERE PROJNO IN(20,30,40); SELECT DISTINCT EMPID FROM PROJECTWORK WHERE PROJNO=20,30,40;
go_editor
asked
in
Databases
Nov 20, 2020
by
go_editor
1.1k
views
ugcnetcse-oct2020-paper2
databases
sql
1
vote
1
answer
77
UGC NET CSE | October 2020 | Part 2 | Question: 97
Consider the following table structures related to a university for the below question. EMPLOYEE NAME VARCHAR (30) NOT NULL, EID VARCHAR (10) NOT NULL, DEPTNO INT (5) NOT NULL, HODEID VARCHAR (10), SALARY INT (10), PRIMARY KEY (EID) ... false Statement $I$ is correct but Statement $II$ is false Statement $I$ is incorrect but Statement $II$ is true
go_editor
asked
in
Databases
Nov 20, 2020
by
go_editor
1.2k
views
ugcnetcse-oct2020-paper2
databases
sql
2
votes
2
answers
78
UGC NET CSE | October 2020 | Part 2 | Question: 98
Consider the following table structures related to a university for the below question. EMPLOYEE NAME VARCHAR (30) NOT NULL, EID VARCHAR (10) NOT NULL, DEPTNO INT (5) NOT NULL, HODEID VARCHAR (10), SALARY INT (10), PRIMARY KEY (EID), FOREIGN KEY ... answer from the options given below: $i$ and $ii$ only $i$ and $iii$ only $ii$ only $iii$ only
go_editor
asked
in
Databases
Nov 20, 2020
by
go_editor
1.4k
views
ugcnetcse-oct2020-paper2
databases
sql
1
vote
1
answer
79
UGC NET CSE | October 2020 | Part 2 | Question: 99
Consider the following table structures related to a university for the below question. EMPLOYEE NAME VARCHAR (30) NOT NULL, EID VARCHAR (10) NOT NULL, DEPTNO INT (5) NOT NULL, HODEID VARCHAR (10), SALARY INT (10), PRIMARY KEY (EID), FOREIGN KEY (HODEID) ... from the options given below: $a$ and $b$ only $a$ and $c$ only $b$ and $c$ only $a$ only
go_editor
asked
in
Databases
Nov 20, 2020
by
go_editor
1.3k
views
ugcnetcse-oct2020-paper2
databases
sql
1
vote
1
answer
80
UGC NET CSE | October 2020 | Part 2 | Question: 100
Consider the following table structures related to a university for the below question. EMPLOYEE NAME VARCHAR (30) NOT NULL, EID VARCHAR (10) NOT NULL, DEPTNO INT (5) NOT NULL, HODEID VARCHAR (10), SALARY INT (10), PRIMARY KEY (EID), FOREIGN KEY ( ... correct answer from the options given below: $a$ and $b$ only $a$ only $b$ and $c$ only $c$ only
go_editor
asked
in
Databases
Nov 20, 2020
by
go_editor
1.1k
views
ugcnetcse-oct2020-paper2
databases
sql
Page:
« prev
1
2
3
4
5
6
7
8
...
17
next »
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent questions tagged sql
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...