Answers by Sankaranarayanan P.N

Answers by Sankaranarayanan P.N

4 votes

1

self doubt #database #please explain

answered in Databases Oct 10, 2017

213 views

0 votes

2

he number of students who take both the subjects mathematics and chemistry is 30

answered in Set Theory & Algebra Oct 10, 2017

4.2k views

0 votes

3

UGCNET-Jan2017-III: 7
Consider following schedules involving two transactions: $S_{1}: \: r_{1}(X);r_{1}(Y);r_{2}(X);r_{2}(Y);w_{2}(Y);w_{1}(X)$ $S_{2}: \: r_{1}(X);r_{2}(X);r_{2}(Y);w_{2}(Y);r_{1}(Y);w_{1}(X)$ ... $S_2$ is not conflict serializable $S_1$ is not conflict serializable and $S_2$ is conflict serializable Both $S_1$ and $S_2$ are not conflict serializable

answered in Databases Oct 9, 2017

2.3k views

3 votes

4

UGCNET-Jan2017-III: 8
Which one is correct w.r.t. RDBMS? primary key $\subseteq$ super key $\subseteq$ candidate key primary key $\subseteq$ candidate key $\subseteq$ super key super key $\subseteq$ candidate key $\subseteq$ primary key super key $\subseteq$ primary key $\subseteq$ candidate key

answered in Databases Oct 9, 2017

1.3k views

4 votes

5

UGCNET-Jan2017-III: 9
Let $pk(R)$ denotes primary key of relation $R$. A many-to-one relationship that exists between two relation $R_1$ and $R_2$ can be expressed as follows: $pk(R_2)\rightarrow pk(R_1)$ $pk(R_1)\rightarrow pk(R_2)$ $pk(R_2)\rightarrow R_1 \cap R_2$ $pk(R_1)\rightarrow R_1 \cap R_2$

answered in Databases Oct 9, 2017

372 views

2 votes

6

UGCNET-Jan2017-III: 10
For database relation $R(A,B,C,D)$ where the domains of $A,B,C$ and $D$ include only atomic values, only the following functional dependencies and those that can be inferred from them are: $A \rightarrow C$ $B \rightarrow D$ The relation $R$ ... in second normal form Second normal form but not in third normal form. Both in second normal form as well as in third normal form.

answered in Databases Oct 9, 2017

534 views

3 votes

7

UGCNET-Dec2012-III: 8
Using RSA algorithm, what is the value of cipher text C, if the plain text M=5 and p=3, q=11 and d=7? 33 5 25 26

answered in Computer Networks Sep 16, 2016

8.9k views

2 votes

8

UGCNET-June2016-III: 54
Suppose that the time to do a null remote procedure call (RPC) (i.e., 0 data bytes) is 1.0 msec with an additional 1.5 msec for every 1K of data. How long does it take to read 32 K from the file server as 32 1K RPCs? 49 msec 80 msec 48 msec 100 msec

answered in Distributed Computing Sep 16, 2016

2.5k views

2 votes

9

UGCNET-June2016-III: 30
Encrypt the plain text message $``\text{EXTRANET}"$ ... $`\text{Z'}$ as bogus character. $\text{TAXERTZENZ}$ $\text{EXTRANETZZ}$ $\text{EZXZTRZANZET}$ $\text{EXTZRANZETZ}$

answered in Computer Networks Sep 16, 2016

4.4k views

0 votes

10

UGCNET-June2016-III: 29
Assume that we need to download text documents at the rate of 100 pages per minute. A page is in average of 24 lines with 80 characters in each line requires 8 bits. Then the required bit rate of the channel is 1.636 Kbps 1.636 Mbps 3.272 Mbps 3.272 Kbps

answered in Computer Networks Sep 16, 2016

6.3k views

2 votes

11

UGCNET-June2016-III: 11
Consider the following ORACLE relations: R(A, B, C)={<1, 2, 3>, <1, 2, 0>, <1, 3, 1>, <6, 2, 3>, <1, 4, 2>, <3, 1, 4>} S(B, C, D)={<2, 3, 7>, <1, 4, 5>, <1, 2, 3>, <2, 3, 4>, <3 ... the number of tuples returned by SQ$_1$ and If N is the number of tuples returned by SQ$_2$ then M=4, N=2 M=5, N=3 M=2, N=2 M=3, N=3

answered in Databases Sep 16, 2016

4.0k views

3 votes

12

UGCNET-June2016-II: 17
Which of the following statement(s) is/are FALSE in the context of Relational DBMS? Views in a database system are important because they with access control by aloowing users to see only a particular subset of the data in the databse E-R diagrams are useful to logically ... well SQL is a procedural language I and IV only III and IV only I, II and III only II, III and IV only

answered in Databases Sep 15, 2016

4.1k views

2 votes

13

UGCNET-June2016-II: 1
How many difference equivalence relations with exactly three different equivalence classes are there on a set with five elements? 10 15 25 30

answered in Set Theory & Algebra Sep 15, 2016

3.4k views

0 votes

14

UGCNET-Dec2012-II: 50
Given a Relation POSITION (Posting-No, Skill), then the query to retrieve all distinct pairs of posting-nos. requiring skill is Select p.posting-No, p.posting-No from position p where p.skill=p.skill and p.posting-No < p.posting-No Select p$_1$.posting-No, p$_2$. ... No from position p$_1$, position p$_2$ where p$_1$.skill=p$_2$.skill and p$_1$.posting.No = p$_2$.posting-No

answered in Databases Aug 19, 2016

2.1k views

2 votes

15

UGCNET-Dec2012-II: 37
AES is a round cipher based on the Rijndal Algorithm that uses a 128 – bit block of data. AES has three different configurations. ______ rounds with a key size of 128-bits, ______ rounds with a key size of 192 bits and ______ rounds with a key size of 256 –bits 5, 7, 15 10, 12, 14 5, 6, 7 20, 12, 14

answered in Computer Networks Aug 19, 2016

2.2k views

0 votes

16

UGCNET-Dec2012-II: 22
In DML, RECONNCT command cannot be used with OPTIONAL Set FIXED Set MANDATOR Set All of the above

answered in Databases Aug 19, 2016

2.2k views

4 votes

17

UGCNET-Dec2012-II: 14
Given a memory partitions of 100 K, 500 K, 200 K, 300 K and 600 K (in order) and processes of 212 K, 417 K, 112 K and 426 K (in order), using the first fit algorithm, in which partition would the process requiring 426 K be placed? 500 K 200 K 300 K 600 K

answered in Operating System Aug 19, 2016

5.3k views

2 votes

18

UGCNET-Dec2015-II: 38
The inorder traversal of the following tree is $2 \, \, \, 3 \, \, \, 4 \, \, \, 6 \, \, \, 7 \, \, \, 13 \, \, \, 15 \, \, \, 17 \, \, \, 18 \, \, \, 18 \, \, \, 20$ ...

answered in DS Aug 2, 2016

1.4k views

0 votes

19

UGCNET-Dec2015-II: 20
A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G}. Which of the following is a candidate key? A AB ABC ABD

answered in Databases Aug 2, 2016

4.0k views

0 votes

20

UGCNET-Dec2015-II: 14
Match the following database terms to their functions $:$ ... $\text{(a)-(iv), (b)-(iii), (c)-(ii), (d)-(i)}$

answered in Databases Aug 2, 2016

1.3k views

0 votes

21

UGCNET-June2015-III: 60
Match the following : ... $\text{(a)-(iii), (b)-(i), (c)-(iv), (d)-(ii)}$

answered in IS&Software Engineering Aug 2, 2016

1.1k views

31 votes

22

GATE CSE 2012 | Question: 49
Consider the following C code segment. int a, b, c = 0; void prtFun(void); main() { static int a = 1; /* Line 1 */ prtFun(); a += 1; prtFun(); printf( \n %d %d , a, b); } void prtFun(void) { static int a = 2; /* Line 2 */ int b = 1; a += ++b ... $\begin{array}{ll} \text{4} & \text{2} \\ \text{4} & \text{2} \\ \text{2} & \text{0} \\ \end{array}$

answered in Programming Apr 29, 2016

6.9k views

0 votes

23

what is the meaning of the data item actually when we write the statement READ(A) ?

answered in Databases Sep 9, 2015

263 views

1 vote

24

what is the significance of checkpoint in a transaction ?
I am confused regrading the significance of checkpoint i.e. is it that whenever we place checkpoint does that mean that all the data items before it have been written onto the data base , if not then why do we place it below the transactions which have simply written the data item but not yet committed ?

answered in Databases Sep 9, 2015

1.7k views

0 votes

25

Write equivalent first order expression
There are worms inside some ripe mangoes.

answered in Mathematical Logic Sep 3, 2015

267 views

1 vote

26

Write Equivalent first order expression
All crows are birds but not all birds are crows.

answered in Mathematical Logic Sep 3, 2015

140 views

Page:

1
2
3
next »

Follow @gateoverflow

Search GATE Overflow for GATE CSE