Recent questions in Databases

Web Page

ER‐model. Relational model:Relational algebra, Tuple calculus, SQL. Integrity constraints, Normal forms. File organization, Indexing (e.g., B and B+ trees). Transactions and concurrency control.

$$\small{\overset{{\large{\textbf{Mark Distribution in Previous GATE}}}}{\begin{array}{|c|c|c|c|c|c|c|c|}\hline
\textbf{Year}&\textbf{2019}&\textbf{2018}&\textbf{2017-1}&\textbf{2017-2}&\textbf{2016-1}&\textbf{2016-2}&\textbf{Minimum}&\textbf{Average}&\textbf{Maximum}
\\\hline\textbf{1 Mark Count}&2&2&2&2&3&2&2&2.2&3
\\\hline\textbf{2 Marks Count}&3&2&3&3&1&2&1&2.3&3
\\\hline\textbf{Total Marks}&8&6&8&8&5&6&\bf{6}&\bf{6.8}&\bf{8}\\\hline
\end{array}}}$$

+1 vote

2 answers

ISRO2020-48
Properties of $ DELETE'$ and $ TRUNCATE'$ commands indicate that After the execution of $'TRUNCATE'$ operation, $COMMIT$, and $ROLLBACK$ statements cannot be performed to retrieve the lost data, while $ DELETE'$ allows it After the execution of $'DELETE'$ and ... $'DELETE'$ and $'TRUNCATE'$ operation no retrieval is possible for the lost data

asked Jan 13 in Databases by Satbir Boss (24k points) | 147 views

+2 votes

2 answers

ISRO2020-51
The SQL query SELECT columns FROM TableA RIGHT OUTER JOIN TableB ON A.columnName = B.columnName WHERE A.columnName IS NULL returns the following : All the rows in Table $B$, which meets equality condition above and, none from Table $A$ which meets the ... condition. All rows in Table $B$, which meets the equality condition All rows in Table $A$, which meets the equality condition

asked Jan 13 in Databases by Satbir Boss (24k points) | 278 views

+3 votes

6 answers

ISRO2020-50
If every non-key attribute functionally dependent on the primary key, then the relation will be in First normal form Second normal form Third normal form Fourth Normal form

asked Jan 13 in Databases by Satbir Boss (24k points) | 438 views

+1 vote

1 answer

ISRO2020-22
Raymonds tree based algorithm ensures no starvation, but deadlock may occur in rare cases no deadlock, but starvation may occur neither deadlock nor starvation can occur deadlock may occur in cases where the process is already starved

asked Jan 13 in Databases by Satbir Boss (24k points) | 75 views

+2 votes

2 answers

NTA NET DEC 2019 (B-tree)
In a B- Tree, each node represents a disk block. Suppose one block holds 8192 bytes, each key uses 32 bytes. In a B-Tree of order M there are M-1 keys. Since each branch is on another disk block, we assume a branch is of 4 bytes. The total memory requirement for a non-leaf node is (1) 32M – 32 (2) 36 M – 32 (3) 36 M – 36 (4) 32M -36

asked Dec 21, 2019 in Databases by Sanjay Sharma Boss (49.3k points) | 91 views

0 votes

0 answers

NTA NET DEC 2019 (SQL_Query)
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(*)>5 1)Total number of ... )Display total number of employees in both department D1 and D2 4)The output of the query must have at least two rows

asked Dec 20, 2019 in Databases by Sanjay Sharma Boss (49.3k points) | 81 views

+3 votes

2 answers

NTA NET DEC 2019 Natural Join
Given two tables $\mathrm{R_1(x,y)}$ and $\mathrm{R_2(y,z)}$ with $50$ and $30$ number of tuples respectively . Find maximum number of tuples in the output of natural join between tables $\mathrm {R_1}$ and $\mathrm{R_2}$ $1)\;30 $ $ 2)\; 20 $ $ 3) \;50 $ $ 4)\; 1500$

asked Dec 20, 2019 in Databases by Sanjay Sharma Boss (49.3k points) | 123 views

+1 vote

3 answers

UGCNET-June-2019-II-31
Which of the following has same expressive power with regard to relational query language? Rational algebra and domain relational calculus Relational algebra and tuples relational calculus Relational algebra and domain relational calculus restricted to safe expression Relational algebra and ... restricted to safe expression a and b only c and d only a and c only b and d only

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 359 views

+2 votes

1 answer

UGCNET-June-2019-II-32
Which of the following features is supported in the rational database model? Complex data-types Multivalued attributes Associations with multiplicities Generalization relationships

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 256 views

+2 votes

2 answers

UGCNET-June-2019-II-33
With respect to relational algebra, which of the following operations are included from mathematical set theory? Join Intersection Cartisian product Project a and d b and c c and d b and d

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 245 views

+3 votes

4 answers

UGCNET-June-2019-II-34
In relational databases, if relation R is in BCNF, then which of the following is true about relation R? R is in 4NF R is not in 1NF R is in 2NF and not in 3NF R is in 2NF and 3NF

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 337 views

+1 vote

2 answers

UGCNET-June-2019-II-35
Which of the following key constraints is required for functioning of foreign key in the context relational databases? Unique key Primary key Candidate key Check key

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 254 views

+1 vote

1 answer

UGCNET-June-2019-II-36
In relational database management, which of the following is/are property/properties of candidate key? P: Uniqueness Q: Irreducibility P only Q only Both P and Q Neither P nor Q

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 183 views

+1 vote

1 answer

UGCNET-June-2019-II-37
Which of the following statements are DML statements? Update [tablename] Set [columnname]=VALUE Delete [tablename] Select * from [tablename] a and b a and d a, b and c b and c

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 184 views

+1 vote

3 answers

UGCNET-June-2019-II-39
Following table has two attributes Employee_id and Manager_id, where Employee_id is a primary key and manager_id is a foreign key referencing Employee_id with on-delete cascade: ... $(30, 35)$ and $(35, 20)$ only $(35, 20)$ only $(40, 45)$ and $(25, 40)$ only

asked Jul 2, 2019 in Databases by Arjun Veteran (431k points) | 233 views

+1 vote

0 answers

Er diagram minimum table
Is this a correct way to find the minimum number of tables in a ER DIAGRAM?

asked Jun 10, 2019 in Databases by kshitij (295 points) | 90 views

0 votes

0 answers

DBMS: SELF DOUBT .
Is basic 2 phase locking always recoverable?

asked Jun 10, 2019 in Databases by Hirak Active (3.6k points) | 87 views

0 votes

1 answer

ER Model Self Doubt
How to represent referential integrity constraint in ER model? pls explain with diagram

asked Jun 7, 2019 in Databases by aditi19 Active (5.2k points) | 252 views

0 votes

1 answer

ACE Test series: Database

asked Jun 7, 2019 in Databases by ushamya Junior (529 points) | 243 views

+1 vote

0 answers

B TRees DBMS Self doubt
In case of B Trees we split a node on insertion in case of overflow, is there any possible case in which this may lead to underflow also? as a key is promoted to parent the children formed may have subtrees, which may be broken such that we get underflow somewhere? just a thought

asked Jun 7, 2019 in Databases by manisha11 Active (2.3k points) | 67 views

+1 vote

3 answers

ACE Test Series : dependency preserving
R(A,B,C) is a relation.Which of the following don't have dependency preserving BCNF decomposition? A->B, B->C A->B,B->C,C->A AB->C,C->A None of these

asked Jun 3, 2019 in Databases by ushamya Junior (529 points) | 141 views

0 votes

1 answer

Virtual Gate Test Series: Databases - ER to Relational Model
how many tables are required?

asked May 28, 2019 in Databases by aditi19 Active (5.2k points) | 224 views

0 votes

0 answers

Virtual Gate Test Series: Databases - Schedules
A' is set of all possible schedules 'C' is set of all possible schedules that are guaranteed to produce a correct final result 'S' is the set of all serializable schedules 'P' is the set of all schedules possible under 2-phase locking protocol Which is FALSE? $P\subseteq C$ $S\subset P$ $S\subseteq P$ $P\subset C$

asked May 28, 2019 in Databases by aditi19 Active (5.2k points) | 133 views

+1 vote

3 answers

Doubt on database normalization for relation having all prime attributes
In a relation, if every attribute is prime but key may not be simple then the relation is in ______. A. 1NF B. 2NF C. 3NF D. BCNF

asked May 27, 2019 in Databases by Tuhin Dutta Boss (10.6k points) | 266 views

+1 vote

1 answer

MADE EASY Relational Algebra
In a relational algebra ∩ is not a basic operator, to make it basic only relational operator we should have are X, – X, U U, –

asked May 25, 2019 in Databases by Hirak Active (3.6k points) | 208 views

0 votes

1 answer

VANI Question Bank :DBMS
Minimum number of tables required to represent the relation R where the $A_n$ stands for the primary key of each entity is ___________

asked May 25, 2019 in Databases by Hirak Active (3.6k points) | 91 views

0 votes

0 answers

#DBMS_ER Model
A university database contains information about professors (identified by SSN) and courses (identified by courseid). Professors teach courses; each of the following situations concerns the Teaches relationship set. For below situation, draw the ER diagram: ... in a team can teach the course. Model this situation introducing additional entity sets and relationship sets if necessary.

asked May 24, 2019 in Databases by Sumiran Agrawal (101 points) | 95 views

0 votes

1 answer

Geeksforgeeks: GATE CS Mock 2018
Consider the given schedule and choose the suitable option S = T1:R(x), T1:R(y), T1:W(x), T2:R(y), T3:W(y), T1:W(x), T2:R(y) Schedule is view serializable Schedule is conflict serializable but not view serializable Schedule is view serializable but not conflict serializable Neither view serializable nor conflict serializable

asked May 22, 2019 in Databases by ushamya Junior (529 points) | 179 views

0 votes

0 answers

UGC NET 2015 DEC-III
Consider the following three SQL queries (Assume the data in the people table): (a)Select Name from people where Age > 21; (b)Select Name from people where Height > 180; (c)Select Name from people where (Age > 21) or (Height > 180); If ... 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ?

asked May 22, 2019 in Databases by aditi19 Active (5.2k points) | 113 views

+1 vote

0 answers

Made Easy Test Series:Databases-Tables
Number of tables required in above ER diagram will be _____________ Is $R_{1}$ create separate table or not?? and $R_{2}$ look like if we remove loop from it?? Answer given for table $E_{1}R_{1}$ Key will be $AC$ , with ... Entities. So, it will add one extra table. I already read https://gateoverflow.in/229580/madeeasy-test-series-number-of-tables-required

asked May 22, 2019 in Databases by srestha Veteran (119k points) | 106 views

Page:

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 questions in Databases

Recent Posts

Recent Blog Comments