ME Test Series

Consider the following schema (primary keys are underlined):Which of the following queries returns the department numbers of those departments for which there are no cour...

GO Classes

328 views

GO Classes asked Feb 5

Databases
goclasses2024-mockgate-14
databases
sql
2-marks

+ –

5 votes

1 answer

GO Classes asked Jan 28

489 views

GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 64
Consider the following schema: The primary key fields are underlined, and the domain of each field is listed after the field name. Assume there are no NULL values in any column of any relation and every relation has at least one tuple. ... who have a rating of $10 $ OR have reserved boat $104.$ All sids of sailor table Empty set.

Consider the following schema:The primary key fields are underlined, and the domain of each field is listed after the field name. Assume there are no NULL values in any c...

GO Classes

489 views

GO Classes asked Jan 28

Databases
goclasses2024-mockgate-13
goclasses
databases
sql
2-marks

+ –

12 votes

1 answer

GO Classes asked Jan 21

749 views

GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 25
Let $\mathrm{R}(\mathrm{a}, \mathrm{b})$ be a schema and $\mathrm{Q} 1$ and $\mathrm{Q} 2$ are queries on $\mathrm{R}$. Q1: SELECT * FROM R; Q2: (SELECT * FROM R) INTERSECT (SELECT * FROM R); Which of the ... to $\text{Q2}$ is always contained in the answer to $\text{Q1}.$ $\text{Q1}$ and $\text{Q2}$ produce different answers.

Let $\mathrm{R}(\mathrm{a}, \mathrm{b})$ be a schema and $\mathrm{Q} 1$ and $\mathrm{Q} 2$ are queries on $\mathrm{R}$.Q1: SELECT * FROM R; Q2: (SELECT * FROM R) INTERSEC...

GO Classes

749 views

GO Classes asked Jan 21

Databases
goclasses2024-mockgate-12
goclasses
databases
sql
1-mark

+ –

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

0 reply

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

0