Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Webpage for Databases:
Recent questions tagged databases
4
votes
1
answer
2371
UGC NET CSE | December 2014 | Part 2 | Question: 20
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$ $AE$ $BE$ $CE$
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$...
makhdoom ghaya
4.4k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
database-normalization
+
–
5
votes
1
answer
2372
UGC NET CSE | December 2014 | Part 2 | Question: 19
The best normal form of relation scheme $R(A, B, C, D)$ along with the set of functional dependencies $F = \left\{AB \rightarrow C, AB \rightarrow D, C \rightarrow A, D \rightarrow B\right\}$ is Boyce-Codd Normal form Third Normal form Second Normal form First Normal form
The best normal form of relation scheme $R(A, B, C, D)$ along with the set of functional dependencies $F = \left\{AB \rightarrow C, AB \rightarrow D, C \rightarrow A, D \...
makhdoom ghaya
5.8k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
database-normalization
+
–
4
votes
3
answers
2373
UGC NET CSE | December 2014 | Part 2 | Question: 18
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram Generalization Aggregation Specialization Adding suitable attributes
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagramGeneralization Aggregation Specia...
makhdoom ghaya
4.6k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
er-diagram
+
–
4
votes
2
answers
2374
UGC NET CSE | December 2014 | Part 2 | Question: 17
Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are equivalent. $I$ and $II$ are correct. $II$ and $III$ are correct. Only $III$ is correct. Only $I$ is correct.
Which of the following is true ?I. Implementation of self-join is possible in SQL with table alias.II. Outer-join operation is basic operation in relational algebra.III. ...
makhdoom ghaya
4.5k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
sql
+
–
3
votes
1
answer
2375
UGC NET CSE | December 2014 | Part 2 | Question: 16
Division operation is ideally suited to handle queries of the type : Customers who have no account in any of the branches in Delhi. Customers who have an account at all branches in Delhi. Customers who have an account in atleast one branch in Delhi. Customers who have only joint account in any one branch in Delhi
Division operation is ideally suited to handle queries of the type : Customers who have no account in any of the branches in Delhi. Customers who have an account at all b...
makhdoom ghaya
2.5k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
sql
+
–
3
votes
2
answers
2376
UGC NET CSE | June 2013 | Part 3 | Question: 47
Match the following: a. Foreign keys i. Domain constraint b. Private key ii. Referential integrity c. Event control action model iii. Encryption d. Data security iv. Trigger a-iii, b-ii, c-i, d-iv a-ii, b-i, c-iv, d-iii a-iii, b-iv, c-i, d-ii a-i, b-ii, c-iii, d-iv
Match the following:a. Foreign keysi. Domain constraintb. Private keyii. Referential integrityc. Event control action modeliii. Encryptiond. Data securityiv. Triggera-iii...
go_editor
1.8k
views
go_editor
asked
Jul 17, 2016
Databases
ugcnetcse-june2013-paper3
databases
+
–
3
votes
2
answers
2377
UGC NET CSE | June 2013 | Part 3 | Question: 34
Horn clauses are special kinds of propositions which can be described as Single atomic proposition on left side Single or multiple atomic proposition on left side A single atomic proposition on left side and a single atomic proposition on right side A single atomic proposition on left side or an empty left side
Horn clauses are special kinds of propositions which can be described asSingle atomic proposition on left sideSingle or multiple atomic proposition on left sideA single a...
go_editor
2.4k
views
go_editor
asked
Jul 17, 2016
Databases
ugcnetcse-june2013-paper3
databases
rdbms
+
–
5
votes
3
answers
2378
UGC NET CSE | June 2013 | Part 3 | Question: 9
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a $\rightarrow$ c, b $\rightarrow$ d holds in the following relation. In 1NF not in 2NF In 2NF not in 3NF In 3NF in 1 NF
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a $\rightarrow$ c, b $\rightarrow$ d holds...
go_editor
1.5k
views
go_editor
asked
Jul 16, 2016
Databases
ugcnetcse-june2013-paper3
databases
database-normalization
+
–
0
votes
2
answers
2379
UGC NET CSE | June 2013 | Part 3 | Question: 8
The employee information of an organization is stored in a relation: Employee (name, sex, salary, deptname). Consider the following SQL query: Select deptname from Employee where sex=’M’ group by dept name ... salary of the organization Average salary of male employees in a department is more than average salary of the organization
The employee information of an organization is stored in a relation: Employee (name, sex, salary, deptname). Consider the following SQL query:Select deptname from Employe...
go_editor
3.5k
views
go_editor
asked
Jul 16, 2016
Databases
ugcnetcse-june2013-paper3
databases
sql
+
–
0
votes
1
answer
2380
UGC NET CSE | June 2013 | Part 3 | Question: 7
The “PROJECT” operator of a relational algebra creates a new table that has always More columns than columns in original table More rows than original table Same number of rows as the original table Same number of columns as the original table
The “PROJECT” operator of a relational algebra creates a new table that has alwaysMore columns than columns in original tableMore rows than original tableSame...
go_editor
3.2k
views
go_editor
asked
Jul 16, 2016
Databases
ugcnetcse-june2013-paper3
databases
rdbms
+
–
1
votes
1
answer
2381
DBMS: Spot the wrong statement
Spot the wrong statement. Subschema is related with external view only. Data dictionary is a tool used exclusively by the database administrator. To define a schema DDL, DML and DCL are comulsory. SET concept is used in network model
Spot the wrong statement.Subschema is related with external view only.Data dictionary is a tool used exclusively by the database administrator.To define a schema DDL, DML...
sh!va
774
views
sh!va
asked
Jul 15, 2016
Unknown Category
databases
+
–
0
votes
2
answers
2382
UGC NET CSE | December 2012 | Part 3 | Question: 70
Referential integrity is directly related to Relation key Foreign key Primary key Candidate key
Referential integrity is directly related toRelation keyForeign keyPrimary keyCandidate key
go_editor
2.0k
views
go_editor
asked
Jul 13, 2016
Databases
ugcnetcse-dec2012-paper3
databases
sql
+
–
3
votes
2
answers
2383
UGC NET CSE | December 2012 | Part 3 | Question: 63
The third normal form is based on the concept of_____ Closure Dependency Transitive Dependency Normal Dependency Functional Dependency
The third normal form is based on the concept of_____Closure DependencyTransitive DependencyNormal DependencyFunctional Dependency
go_editor
3.6k
views
go_editor
asked
Jul 13, 2016
Databases
ugcnetcse-dec2012-paper3
databases
database-normalization
+
–
1
votes
2
answers
2384
UGC NET CSE | December 2012 | Part 3 | Question: 56
If a relation with a Schema R is decomposed into two relations $R_1$ and $R_2$ such that $(R_1 \cup R_2) = R_1$ then which one of the following is to be satisfied for a lossless joint decomposition ($\rightarrow$ indicates functional ... $(R_1 \cap R_2) \rightarrow R_1 \text{ and } R_1 \cap R_2 \rightarrow R_2$
If a relation with a Schema R is decomposed into two relations $R_1$ and $R_2$ such that $(R_1 \cup R_2) = R_1$ then which one of the following is to be satisfied for a l...
go_editor
3.0k
views
go_editor
asked
Jul 13, 2016
Databases
ugcnetcse-dec2012-paper3
databases
decomposition
+
–
2
votes
3
answers
2385
UGC NET CSE | December 2012 | Part 2 | Question: 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$. ... p$_1$, position p$_2$ where p$_1$.skill=p$_2$.skill and p$_1$.posting.No = p$_2$.posting-No
Given a Relation POSITION (Posting-No, Skill), then the query to retrieve all distinct pairs of posting-nos. requiring skill isSelect p.posting-No, p.posting-No from posi...
go_editor
2.9k
views
go_editor
asked
Jul 11, 2016
Databases
ugcnetcse-dec2012-paper2
databases
sql
+
–
2
votes
1
answer
2386
UGC NET CSE | June 2016 | Part 3 | Question: 8
In distributed databases, location transparency allows for database users, programmers and administratirs to treat the data as if it is at one location, A SQL query with location transparency needs to specify Inheritances Fragments Locations Local formats
In distributed databases, location transparency allows for database users, programmers and administratirs to treat the data as if it is at one location, A SQL query with ...
Sanjay Sharma
5.8k
views
Sanjay Sharma
asked
Jul 11, 2016
Databases
ugcnetcse-june2016-paper3
databases
distributed-database
+
–
1
votes
0
answers
2387
UGC NET CSE | June 2016 | Part 3 | Question: 7
Which of the following statements concerning Object-oriented database is false? Objects in object-oriented databse contain not only data but also methods for processing the data Object-oriented database store computational instructions ... databases Object-oriented databases store more types of data than relational databases and access that data faster
Which of the following statements concerning Object-oriented database is false?Objects in object-oriented databse contain not only data but also methods for processing th...
Sanjay Sharma
1.6k
views
Sanjay Sharma
asked
Jul 11, 2016
Databases
ugcnetcse-june2016-paper3
databases
object-oriented-database
+
–
4
votes
2
answers
2388
UGC NET CSE | December 2012 | Part 2 | Question: 34
The maximum number of keys stored in a B-tree of order $m$ and depth $d$ is $m^{d +1}-1$ $\frac{m^{d+1}-1}{m-1}$ $(m-1)(m^{d+1}-1)$ $\frac{m^d-1}{m-1}$
The maximum number of keys stored in a B-tree of order $m$ and depth $d$ is$m^{d +1}-1$$\frac{m^{d+1}-1}{m-1}$$(m-1)(m^{d+1}-1)$$\frac{m^d-1}{m-1}$
go_editor
4.4k
views
go_editor
asked
Jul 11, 2016
DS
ugcnetcse-dec2012-paper2
b-tree
databases
+
–
0
votes
1
answer
2389
UGC NET CSE | December 2012 | Part 2 | Question: 32
The User Work Area (UWA) is a set of Program variables declared in the host program to communicate the contents of individual records between DBMS and the Host record Host program and the Host record Host program and DBMS Host program and Host language
The User Work Area (UWA) is a set of Program variables declared in the host program to communicate the contents of individual records betweenDBMS and the Host recordHost ...
go_editor
2.0k
views
go_editor
asked
Jul 11, 2016
Databases
ugcnetcse-dec2012-paper2
databases
+
–
0
votes
2
answers
2390
UGC NET CSE | June 2014 | Part 3 | Question: 27, UGCNET-June2015-II: 17
Which of the following concurrency protocol ensues both conflict serializability and freedom from deadlock: $2$-phase locking Time phase ordering Both I & II II only I only Neither I nor II
Which of the following concurrency protocol ensues both conflict serializability and freedom from deadlock:$2$-phase lockingTime phase orderingBoth I & IIII onlyI onlyNei...
makhdoom ghaya
1.5k
views
makhdoom ghaya
asked
Jul 9, 2016
Databases
ugcnetjune2014iii
databases
concurrency
protocol
ugcnetcse-june2015-paper2
+
–
0
votes
4
answers
2391
UGC NET CSE | June 2014 | Part 3 | Question: 23
Specialization Lattice stands for An entity type can participate as a subclass in only one specialization. An entity type can participate as a subclass in more than one specialization. An entity type that can participate in one specialization. An entity type that can participate in one generalization.
Specialization Lattice stands for An entity type can participate as a subclass in only one specialization.An entity type can participate as a subclass in more than one sp...
makhdoom ghaya
2.3k
views
makhdoom ghaya
asked
Jul 9, 2016
Databases
ugcnetjune2014iii
databases
enhanced-er-model
+
–
1
votes
2
answers
2392
UGC NET CSE | June 2014 | Part 3 | Question: 22
Consider the following relational schemas for a library database : Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection(Title, Author, Catalog_no) with the following functional dependencies : I. Title, Author $\rightarrow$ ... . Book is in $2$NF and Collection in $3$NF. Both Book and Collection are in $2$NF.
Consider the following relational schemas for a library database :Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection(Title, Author, Catalog_no) with the ...
makhdoom ghaya
2.0k
views
makhdoom ghaya
asked
Jul 9, 2016
Databases
ugcnetjune2014iii
databases
database-normalization
+
–
1
votes
0
answers
2393
Identify the recovery mechanism
A DBMS recovery mechanism is upgraded to recover the data even in case of failure of any one site including the coordinating site, without blocking any site. Which recovery mechanism was applied in this DBMS ? Two-phase commit Three-phase commit Roll-backward recovery Roll-forward recovery
A DBMS recovery mechanism is upgraded to recover the data even in case of failure of any one site including the coordinating site, without blocking any site. Which recove...
sh!va
268
views
sh!va
asked
Jul 9, 2016
Databases
databases
+
–
2
votes
3
answers
2394
UGC NET CSE | June 2012 | Part 3 | Question: 9
The problem that occurs when one transaction updates a database item and the transaction fails for some reason is Temporary Select Problem Temporary Modify Problem Dirty Read Problem None
The problem that occurs when one transaction updates a database item and the transaction fails for some reason isTemporary Select ProblemTemporary Modify ProblemDirty Rea...
go_editor
3.1k
views
go_editor
asked
Jul 6, 2016
Databases
ugcnetcse-june2012-paper3
databases
+
–
2
votes
1
answer
2395
UGC NET CSE | June 2012 | Part 3 | Question: 8, UGCNET-Dec2012-III: 59
Which level of abstraction describes what data are stored in the database? Physical level View level Abstraction level Logical level
Which level of abstraction describes what data are stored in the database? Physical levelView levelAbstraction levelLogical level
go_editor
4.9k
views
go_editor
asked
Jul 6, 2016
Databases
ugcnetcse-june2012-paper3
databases
data-model
ugcnetcse-dec2012-paper3
+
–
2
votes
2
answers
2396
UGC NET CSE | June 2012 | Part 3 | Question: 4
What is Granularity? The size of database The size of data item The size of record The size of file
What is Granularity?The size of databaseThe size of data itemThe size of recordThe size of file
go_editor
2.8k
views
go_editor
asked
Jul 6, 2016
Databases
ugcnetcse-june2012-paper3
databases
granularity
+
–
5
votes
1
answer
2397
ISRO2016-58
Trigger is Statement that enables to start any DBMS Statement that is executed by the user when debugging an application program The condition that the system tests for the validity of the database user Statement that is executed automatically by the system as a side effect of a modification of the database
Trigger isStatement that enables to start any DBMSStatement that is executed by the user when debugging an application programThe condition that the system tests for the ...
go_editor
5.2k
views
go_editor
asked
Jul 6, 2016
Databases
isro2016
databases
transaction-and-concurrency
+
–
4
votes
2
answers
2398
ISRO2016-56
Goals for the design of the logical scheme include avoiding data inconsistency being able to construct query easily being able to access data efficiently All of the above
Goals for the design of the logical scheme includeavoiding data inconsistencybeing able to construct query easilybeing able to access data efficientlyAll of the above
go_editor
4.2k
views
go_editor
asked
Jul 6, 2016
Databases
isro2016
databases
er-diagram
+
–
0
votes
1
answer
2399
UGC NET CSE | June 2012 | Part 2 | Question: 12
A Transaction Manager is which of the following? Maintains a log of transactions Maintains before and after database images Maintains appropriate concurrent control All of the above
A Transaction Manager is which of the following?Maintains a log of transactionsMaintains before and after database imagesMaintains appropriate concurrent controlAll of th...
go_editor
2.2k
views
go_editor
asked
Jul 4, 2016
Databases
ugcnetcse-june2012-paper2
databases
transaction-and-concurrency
+
–
1
votes
1
answer
2400
UGC NET CSE | June 2012 | Part 2 | Question: 9
What deletes the entire file except the file structure? ERASE DELETE ZAP PACK
What deletes the entire file except the file structure?ERASEDELETEZAPPACK
go_editor
1.0k
views
go_editor
asked
Jul 4, 2016
Web Technologies
ugcnetcse-june2012-paper2
databases
non-gate
+
–
Page:
« prev
1
...
75
76
77
78
79
80
81
82
83
84
85
...
97
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register