Dark Mode

Answers by amarVashishth

1 vote

211

Type of language ?
it will be accepted by NPDA. Right ??

answered in Theory of Computation Jul 25, 2015

437 views

3 votes

212

number of tuples

answered in Databases Jul 11, 2015

889 views

52 votes

213

GATE CSE 2005 | Question: 70
Consider a disk drive with the following specifications: $16$ surfaces, $512$ tracks/surface, $512$ sectors/track, $1$ KB/sector, rotation speed $3000$ rpm. The disk is operated in cycle stealing mode whereby whenever one $4$ byte word is ready it is sent ... $40$ nsec. The maximum percentage of time that the CPU gets blocked during DMA operation is: $10$ $25$ $40$ $50$

answered in CO and Architecture Jul 11, 2015

65.2k views

5 votes

214

Total size of cache
Consider a 8 million word main memory and 256 block cache.Both partitioned into 64 words block.What is the size of additional memory for tags? Size of the cache? consider direct mapping is used and word size 1 byte.

answered in CO and Architecture Jul 10, 2015

8.1k views

1 vote

215

set associativity / full associativity
https://gateoverflow.in/?qa=blob&qa_blobid=3717160066093697882

answered in CO and Architecture Jul 7, 2015

313 views

9 votes

216

Conflict Equivalent
Consider the following ordering S of transaction T1:R(X),W(Y), T2:R(X),W(Y);T3:R(X),W(Y). how many schedules if any are conflict equivalent to S? 1) 3 2) 5 c) 15 d) 30

answered in Databases Jul 6, 2015

4.0k views

11 votes

217

GATE CSE 1998 | Question: 27
Consider the following relational database schemes: COURSES (Cno, Name) PRE_REQ(Cno, Pre_Cno) COMPLETED (Student_no, Cno) COURSES gives the number and name of all the available courses. PRE_REQ gives the information about which courses are pre- ... relational algebra: List all the courses for which a student with Student_no 2310 has completed all the pre-requisites.

answered in Databases Jul 6, 2015

8.1k views

3 votes

218

join
Consider a relation $R(A,B,C)$ with the following functional dependencies $AB \to C$ and $AC \to B$. $A$ can take 20 distinct values, $B$ can take 10 distinct values and $C$ can take 100 distinct values. What is the maximum possible size (in tuples) of the self join of $R$ on $C$? 4,000 200 4,00,000 20,000

answered in Databases Jul 5, 2015

1.3k views

2 votes

219

comment
T1:W(X), T2:R(Y), T1:R(Y), T2:R(X) • Is it conflict serializable, view serializable, serializable, recoverable, avoids cascading aborts, strict?

answered in Databases Jun 30, 2015

738 views

4 votes

220

ER MODEL
HOW many minimum relation which satisfy BCNF.??

answered in Databases Jun 25, 2015

1.6k views

174 votes

221

GATE CSE 2001 | Question: 2.23
$R(A,B,C,D)$ is a relation. Which of the following does not have a lossless join, dependency preserving $BCNF$ decomposition? $A \rightarrow B, B \rightarrow CD$ $A \rightarrow B, B \rightarrow C, C \rightarrow D$ $ AB \rightarrow C, C \rightarrow AD$ $A \rightarrow BCD$

answered in Databases Jun 23, 2015

51.6k views

Page:

« prev
1
...
3
4
5
6
7
8