Register
Webpage for Databases:

Recent questions tagged databases

7 votes
3 answers
1891
ISRO2017-4
What does a data dictionary will identify? Field name Field format Field types All of the above
What does a data dictionary will identify?Field nameField formatField typesAll of the above
User Avatar
0 votes
1 answer
1897
Question Bank GATE
Find the Odd one Out: Candidate Key Super Key Primary Key Alternate Key
Find the Odd one Out: Candidate KeySuper KeyPrimary KeyAlternate Key
User Avatar
4 votes
0 answers
1899
tables in Self Referential relations
Plz explain what is the no of tables required in self referential relation( without multivalued attribute) and How:- and also (with multivalued attribute) ? ???
Plz explain what is the no of tables required in self referential relation( without multivalued attribute) and How:- and also (with multivalued attribute) ????
User Avatar
0 votes
1 answer
1900
Subschema View Virtual table in DBMS
What is the difference between Subschema, View and Virtual table in DBMS? please explain!!
What is the difference between Subschema, View and Virtual table in DBMS?please explain!!
User Avatar
0 votes
1 answer
1901
External schema
External schema consists of: a) Subschemas b) Virtual Tables c) Both a and b d) None of these
External schema consists of:a) Subschemasb) Virtual Tablesc) Both a and bd) None of these
User Avatar
6 votes
6 answers
1902
Databases
A Clustered index A) is a dense index always. B) is a sparse index always. C) can be either dense index or a sparse index,but not both. D) can be both dense index and sparse index.
A Clustered indexA) is a dense index always.B) is a sparse index always.C) can be either dense index or a sparse index,but not both.D) can be both dense index and sparse ...
User Avatar
2 votes
3 answers
1903
databases
Which of the following statements is TRUE ? A) Every primary index is also a clustered index. B) Every clustered index is also a primary index. C) Both primary index and clustered index are one and the same, D) An index can be either primary or clustered but not both.
Which of the following statements is TRUE ?A) Every primary index is also a clustered index.B) Every clustered index is also a primary index.C) Both primary index and clu...
User Avatar
0 votes
0 answers
1904
databases
This index is a dense index ...right ...???
This index is a dense index ...right ...???
User Avatar
2 votes
0 answers
1905
databases
State TRUE or FALSE. "In Indexing,the number of ordering field (field based on which records in data file and its corresponding index file are sorted) should always be 1". Please support your answer with explanations ...
State TRUE or FALSE."In Indexing,the number of ordering field (field based on which records in data file and its corresponding index file are sorted) should always be 1"....
User Avatar
9 votes
2 answers
1906
# DBMS #Normalization
IF a relation R(A,B,C,D,E) where AB is the key and ADE->C so is this in 2NF or not? Do Partial dependency exist??? because C is derived from ADE (A is part of key AB)
IF a relation R(A,B,C,D,E) whereAB is the key andADE->Cso is this in 2NF or not?Do Partial dependency exist??? because C is derived from ADE (A is part of key AB)
User Avatar
2 votes
2 answers
1907
databases
what is the difference between a "Block" and "Sector" in Hard disk ..??? Are they both same ???
what is the difference between a "Block" and "Sector" in Hard disk ..??? Are they both same ???
User Avatar
0 votes
1 answer
1909
Normalization
Is the following relation in 3NF or not ?
Is the following relation in 3NF or not ?
User Avatar
0 votes
0 answers
1911
what is the difference between Vertical and Horizontal fragmentations.If Data objects replicas are stored
what is the difference between Vertical and Horizontal fragmentations.If Data objects replicas are stored at multiple number of sites, Explain how the lock will be acquir...
User Avatar
4 votes
2 answers
1912
cil-2017 Q87
User Avatar
18 votes
3 answers
1914
Self doubt
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at both sides, Total Participation at both sides and partial participation at one side). (Tabular Format answer will be appreciated).
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at b...
User Avatar
1 votes
2 answers
1915
ME Workbook
1. How many minimum tables required which satisfy 1NF. 2. How many minimum tables required which satisfy BCNF. 3. How many minimum tables required which satisfy 4NF.
1. How many minimum tables required which satisfy 1NF.2. How many minimum tables required which satisfy BCNF.3. How many minimum tables required which satisfy 4NF.
User Avatar
0 votes
2 answers
1916
coal india
User Avatar
1 votes
2 answers
1917
Databases- B and B+ Tree
Searching and retrieval of data is more efficient using which tree? B Tree or B+ Tree?
Searching and retrieval of data is more efficient using which tree?B Tree or B+ Tree?
User Avatar
1 votes
1 answer
1918
Pessimistic time stamp ordering vs optimistic time stamp ordering
What is the difference between Pessimistic time stamp ordering and optimistic time stamp ordering.
What is the difference between Pessimistic time stamp ordering and optimistic time stamp ordering.
User Avatar
0 votes
0 answers
1920
Doubt in two phase Commit Protocol
In two phase Commit Protocol,why can blocking be completely eliminated even when participants elect a new Coordinator ?
In two phase Commit Protocol,why can blocking be completely eliminated even when participants elect a new Coordinator ?
User Avatar
Page: