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
Filter
User ibia
Wall
Recent activity
All questions
All answers
Exams Taken
All Blogs
Recent activity by ibia
1
answer
1
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.12
Specify the following queries in SQL on the database schema of Figure 1.2. Figure 1.2: A database that stores student and course information.Caption Retrieve the names of all senior students majoring in ‘CS& ... name, course number, credit hours, semester, year, and grade for each course completed by the student.
asked
in
Databases
Apr 7, 2016
1.4k
views
descriptive
databases
sql
navathe
0
answers
2
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.10
Specify the following queries in SQL on the COMPANY relational database schema shown in figure 3.5 .Show the result of each query if it is applied to the COMPANY database in Figure 3.6 Retrieve the ... for the COMPANY relational database schema. FIGURE 3.6:One possible database state for the COMPANY relational database schema
asked
in
Databases
Apr 6, 2016
3.5k
views
databases
descriptive
sql
navathe
0
answers
3
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.11
Specify the updates of Exercise 3.11 using the SQL update commands. EXERCISE 3.11 : Suppose that each of the following Update operations is applied directly to the database state shown in Figure 3.6. Discuss all integrity ... Michael M 1988-01-04 Son 123456789 Alice F 1988-12-30 Daughter 123456789 Elizabeth F 1967-05-05 Spouse
asked
in
Databases
Apr 5, 2016
776
views
databases
descriptive
sql
navathe
0
answers
4
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.14
Design a relational database schema for a database application of your choice. Declare your relations,using the SQL DDL. Specify a number of queries in SQL that are needed by your database application. Based on your ... that should have indexes specified on them Implement your database , if you have a DBMS that supports SQL.
asked
in
Databases
Apr 5, 2016
474
views
databases
descriptive
sql
navathe
0
answers
5
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.8
Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema of figure below. Specify the keys and referential triggered actions.
asked
in
Databases
Apr 4, 2016
1.1k
views
databases
sql
1
answer
6
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.2
List the data types that are allowed for SQL attributes.
asked
in
Databases
Apr 2, 2016
390
views
databases
sql
descriptive
0
answers
7
Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.7
Consider the LIBRARY relational database schema shown in the figure below .Choose the appropriate action (reject, cascade, set to NULL, set to default) for each referential integrity constraint, both for the deletion of a referenced tuple and for the update of primary key attribute value in a referenced tuple.Justify your choices
asked
in
Databases
Apr 2, 2016
1.0k
views
databases
referential-integrity
navathe
descriptive
0
answers
8
Navathe-sixth edition-4.5
Consider the database shown below ,Whose schema is also shown below .What are the referential integrity constraints that should hold on the schema ? Write appropriate $SQL$ $DDL$ ... Credit_hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section_identifier Course_number Semester year Instructor GRADE_REPORT Student_number Section_identifier Grade
asked
in
Databases
Apr 1, 2016
523
views
databases
referential-integrity
navathe
descriptive
2
answers
9
Number of candidate keys
A relation $R$ with $5$ attributes $A_1,A_2,A_3,A_4,A_5$. Given the following FDs $A_1\rightarrow A_2$ $A_2A_3\rightarrow A_5$ $A_4A_5\rightarrow A_1$ the number of candidates keys that includes attribute $A_3$ is ________________.
edited
in
Databases
Mar 30, 2016
970
views
databases
database-normalization
2
answers
10
GATE2013 CE: GA-7
If $\mid 4X-7 \mid =5$ then the values of $2\mid X\mid -\mid -X\mid$ is: $\quad 2,\left(\dfrac{1}{3}\right)$ $\left(\dfrac{1}{2}\right),3$ $\left(\dfrac{3}{2}\right),9$ $\left(\dfrac{2}{3}\right),9$
commented
in
Quantitative Aptitude
Feb 24, 2016
3.5k
views
gate2013-ce
quantitative-aptitude
absolute-value
6
answers
11
GATE2014 AE: GA-7
Anuj, Bhola, Chandan, Dilip, Eswar and Faisal live on different floors in a six-storeyed building (the ground floor is numbered $1$, the floor above it $2$, and so on) Anuj lives on an even-numbered floor, Bhola does not live on an odd numbered floor. Chandan does not live on ...
answered
in
Analytical Aptitude
Feb 22, 2016
2.5k
views
gate2014-ae
logical-reasoning
analytical-aptitude
descriptive
5
answers
12
GATE2013 EE: GA-10
Find the sum to $'n'$ terms of the series $10+84+734+\dots$ $\frac{9(9^n+1)}{10} +1$ $\frac{9(9^n-1)}{8} +1$ $\frac{9(9^n-1)}{8} +n$ $\frac{9(9^n-1)}{8} +n^2$
answered
in
Quantitative Aptitude
Feb 19, 2016
4.1k
views
gate2013-ee
quantitative-aptitude
number-series
2
answers
13
GATE CSE 2016 Set 1 | Question: 21
Which of the following is NOT a superkey in a relational schema with attributes $V,W,X,Y,Z$ and primary key $V\;Y$? $VXYZ$ $VWXZ$ $VWXY$ $VWXYZ$
edited
in
Databases
Feb 18, 2016
7.1k
views
gatecse-2016-set1
databases
database-normalization
easy
1
answer
14
Eigen values
The possible set of eigen values of a $4*4$ skew symmetric; orthogonal real matrix is A). $\pm i$ B), $(\pm i,\pm1)$ C). $\pm1$ D). $(0,\pm i)$
edited
in
Linear Algebra
Feb 11, 2016
2.0k
views
eigen-value
engineering-mathematics
linear-algebra
2
answers
15
What does R represent here ?
Q). Let $A= (a+b)^*ab(a+b)^*,B=a^*b^*$ and $ C=(a+b)^*$ .Then the relation between $A,B$ and $C$ is: A). $A+B=C$ B). $A^R+ B^R =C$ C). $A^R +B=C$ D). None
edited
in
Theory of Computation
Feb 10, 2016
399
views
1
answer
16
tcp problem
Q). Consider a TCP machine having window size $32 \text{KB}$ over a $512 \text{Mbps}$ channel that has one way delay of $20\text{msec}$ . The line efficiency in percentage is __________.
edited
in
Computer Networks
Feb 10, 2016
808
views
1
answer
17
no of connected component
if G and G* are isomorphic graphs , then no of connected components of G* if G has connected components, are
answered
in
Graph Theory
Feb 10, 2016
2.1k
views
1
answer
18
what is the processor time
Consider the disk drive with the following specification $16$ surface. $1024$ tracks per surface. $1024$ sectors/track, $1$ KB /sector rotation speed is $3000$ $\text{rpm}$.The disk is operated in Burst Mode.The processor runs at $600$ ... $\text{KB}$ What is the percentage of processor time consumed for the transfer operation?
edited
in
CO and Architecture
Feb 10, 2016
489
views
dma
1
answer
19
Dependency
Consider the following program segment: What types of dependencies were included in the above program? $I_1$ : MOV $R_3,R_7$ ; $R_3 \implies (R_7)$ $I_2$ : Load $R_8,(R_3)$ ; $R_8 \implies Mem (R_3)$ $I_3$ : Add $R_3,R_3,4 $ ... . Write after write and write after read C). Read after write and write after read D). Write after write,read after write, and write after read
edited
in
CO and Architecture
Feb 8, 2016
286
views
1
answer
20
cache mem with TLB ans ??
Common Data Questions 50 and 51 A four-way associative writeback cache has a $2^{11} * \text{89-bit}$ tag store. The cache uses a custom replacement policy that requires $9$ $\text{bits}$ per set. The cache block size is $64$ bytes. The cache is virtually -indexed and ... is the size of the cache data store? (a). $512 KB$ (b). $256 KB$ (c). $128 KB$ (d). $1024KB$
edited
in
CO and Architecture
Feb 8, 2016
401
views
1
answer
21
integration
Please solve the following integration problem $\int_{0}^{\infty}{ y^{\frac{1}{2} }}e^{-y^3}dx$ I want full explanation. please help me ?
edited
in
Calculus
Feb 8, 2016
2.4k
views
1
answer
22
A set of r vectors with r > n elements are always Linearly Dependent How?
Let r = No. of Vectors and n = No. of elements in each vector A set of r vectors with r > n elements are always Linearly Dependent, Can anyone please explain How?
answered
in
Linear Algebra
Feb 3, 2016
300
views
0
answers
23
Couldn't understand how to approach this problem on digital logic
Q) What is the maximum clock frequency that the sequential circuit which has the longest flip-flops delay of $2 \text{ns}$ , the longest setup time and hold time among the flip-flops of $1.5\text{ns}$ and $1\text{ns}$, and the ... $(31.74) $ $\text{MHz}$(correct to two decimal places).
edited
in
Digital Logic
Feb 3, 2016
262
views
digital-logic
1
answer
24
no. of splits
Q).Consider the following $B^+$ tree Which of the following is true, after inserting $80$. (If rotation allowed) (A).No node splitted (B).Only Root node splitted (C). Only leaf node splitted (D).Both Root & leaf node splitted
edited
in
Databases
Feb 3, 2016
249
views
1
answer
25
Virtual Gate Test Series: Linear Algebra - Matrix(Number Of Solutions)
$1)$ If the row reduced the form of a matrix has more than two non-zero entries in any row, then the corresponding system of equations has Infinitely many solutions. $2)$ If the row reduced the form of a matrix has more ... 2 non zero, then it's good, because then we will have more number of equations? How is the answer C?
answered
in
Linear Algebra
Feb 1, 2016
1.4k
views
engineering-mathematics
linear-algebra
matrix
number-of-solutions
virtual-gate-test-series
1
answer
26
what is L3
Q). Given a regular set $L1$ & a language $L2$ we form $L3= L_1 \cup L_2$ or $L3=L_1 \cap L_2$ Which of the following is true. (A).The emptiness problem of $L_3$ is decidable (B). It is decidable is $L_3$ is empty, finite or infinite (C). $L_3$ is necessary regular (D). It is undecidable if $L_3$ is a r.e set
edited
in
Theory of Computation
Feb 1, 2016
414
views
identify-class-language
0
answers
27
CSE
Consider a cache as follows: • Direct mapped. • 8 words total cache data size. • 2 word cache block size. A sequence of eight memory reads is performed in the order shown from the following addresses. 0, 11, 4, 14, 9, 1, 8, 0 The (number of misses + Number of compulsory misses + Number of conflict misses) value is ______.
commented
in
Operating System
Feb 1, 2016
290
views
1
answer
28
Orthogonal set of vectors in R
What is R in this question? How to solve this? Q).Let $A$ be a real $n*n$ matrix ,then which of the following statements are true? I). $A$ is orthogonal iff the row vectors form an orthgonal set of vectors in $R^4$. II). $A$ is orthogonal iff the columns ... of vectors in $R^4$. (A) Only I (B) Only II (C) Both I and II (D) None of these The correct answer is C.
answered
in
Linear Algebra
Feb 1, 2016
863
views
linear-algebra
eigen-value
engineering-mathematics
1
answer
29
Is phi a regular language or not
phi is regular language or not
edited
in
Theory of Computation
Jan 29, 2016
1.7k
views
theory-of-computation
2
answers
30
projection
The Project operation $(\prod)$ in relational algebra: (i) Is used for eliminating duplicate rows automatically from the output. (ii). Is used to filter columns. (iii). Is a unary operator. (iv). has degree of output relation same as input relation. (A). (i). and (iii) (B). (ii) and (v) (C). (i) and (ii) (D). (iv) only
edited
in
Databases
Jan 27, 2016
1.8k
views
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 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:...