Register

Recent questions tagged database-design

0 0 votes
1 1 answer
248
248 views
UGC NET CSE | December 2025 | Part 2 | Question: 21
Specialization process does not allowto define a set a sub classes of an entity type.to establish additional specific attributes with each subclass.to define a generalize...
User Avatar
0 0 votes
1 1 answer
162
162 views
ISRO CSE 2025 | Question: 30
Assume a one-to-many relationship from table named "authors" to the table named "books". Where should the foreign key reside in an optimal design for this relationship?In...
User Avatar
2 2 votes
1 1 answer
310
310 views
UGC NET CSE | January 2025 | Part 2 | Question: 35
What will be the right sequence of the phases of database design-Physical DesignConceptual DesignLogical DesignRequirement collection and analysisChoose the correct answe...
User Avatar
1 1 vote
0 0 answers
203
203 views
UGC NET CSE | August 2024 | Part 2 | Question: 41
Arrange the following phases of database design in the correct order:Physical DesignConceptual DesignLogical DesignRequirement AnalysisChoose the correct answer from the ...
User Avatar
2 2 votes
1 1 answer
415
415 views
UGC NET CSE | December 2023 | Part 2 | Question: 50
Which of the following is/are NOT CORRECT statement?The first record in each block of the data file is known as actor record.Dense index has index entries for every searc...
User Avatar
1 1 vote
0 0 answers
323
323 views
UGC NET CSE | December 2023 | Part 2 | Question: 97
Consider the following relations $\mathrm{X}(\mathrm{S}, \mathrm{Si}, \mathrm{C})$ and $\mathrm{Y}(\mathrm{S}, \mathrm{P}, \mathrm{D})$.\[X =\begin{array}{|c|c|c|}\hlineS...
User Avatar
0 0 votes
1 answers 1 answer
476
476 views
ISI2024-MCS-PCB (CS) | Question: 10
Suppose the relationship between customers and products are stored in a table BOUGHT (CUST, PROD, QT) such that there is a tuple $(c, p, n) \in$ BOUGHT if and only if the...
User Avatar
0 0 votes
0 0 answers
318
318 views
Can a candidate key for a composite attribute be called a composite key?
Let's take an example of student entity typeNameClassSectionAddress (Line1, Line2, City, State, Country, PinCode)Since composite attribute holds multiple atomic attribute...
User Avatar
0 0 votes
0 0 answers
760
760 views
UGC NET CSE | June 2023 | Part 2: 39
The total cost of retrieving records in sorted order using an unclustered $\mathrm{B}+$ tree is (P-Average number of records per data pageN- Data pagesF- Ratio of the siz...
User Avatar
0 0 votes
0 0 answers
554
554 views
UGC NET CSE | June 2023 | Part 2: 48
Consider the following statements:A database design is in BCNF if each member of the set of relation schemas that constitutes the design is in BCNFA BCNF schema can have ...
User Avatar
0 0 votes
0 0 answers
511
511 views
UGCNET CSE December 2022: 49
Which of the following database model, we have a parent-child relationshipA. hierarchical databasesB. network databasesC. relational databasesChoose the correct answer fr...
User Avatar
0 0 votes
0 0 answers
566
566 views
UGC NET CSE | October 2022 | Part 1 | Question: 52
Consider the following statements:Statement $\text{I}$: Composite attributes cannot be divided into smaller subparts.Statement $\text{II}$: Complex attribute is formed by...
User Avatar
0 0 votes
0 0 answers
1.2k
1.2k views
DBMS -- Book Confusion
which is best book for DBMS korth or navathe ?since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language...
User Avatar
0 0 votes
1 1 answer
721
721 views
NIELIT 2021 Dec Scientist A - Section B: 57
Consider a relation $\text{R}$ with attributes $\{ \text{A, B, C} \}$ and functional dependency set $\text {S= \{ A} \rightarrow \text{B, } \text{A} \rightarrow \text{C} ...
User Avatar
0 0 votes
1 1 answer
1.1k
1.1k views
NIELIT 2021 Dec Scientist B - Section B: 65
Assume that a $\text{DBA}$ issued the following create table command : create table $\text{A (Aid, $\dots\dots$)}$storage $\text{ (initial 20480, next 20480, maxextents 8...
User Avatar
2 2 votes
1 answers 1 answer
751
751 views
GATE ACADEMY TEST SERIES
Under a relational database if table A has a foreign key constraint referencing to another table B, then Each tuple in A is related to zero or one tuple of B.Each tuple i...
User Avatar
0 0 votes
1 1 answer
870
870 views
UGC NET CSE | June 2007 | Part 2 | Question: 20
Which statement is false regarding data Independence:Hierarchical data model suffers from data Independence.Network model suffers from data Independence.Relational model ...
User Avatar
0 0 votes
0 0 answers
376
376 views
UGC NET CSE | June 2006 | Part 2 | Question: 19
Which data management language component enabled the DBA to define the schema components?$\text{DML}$Subschema $\text{DLL}$Schema $\text{DLL}$All of these
User Avatar
0 0 votes
1 1 answer
568
568 views
UGC NET CSE | December 2005 | Part 2 | Question: 18
In a relational schema, each tuple is divided in fields called :RelationsDomainsQueriesAll the above
User Avatar
1 1 vote
1 1 answer
3.4k
3.4k views
UGC NET CSE | December 2004 | Part 2 | Question: 18
The completeness constraint has rules :Supertype, SubtypeTotal specialization, Partial specializationSpecialization, GeneralizationAll of the above
User Avatar
1 1 vote
2 answers 2 answers
2.1k
2.1k views
UGC NET CSE | January 2017 | Part 2 | Question: 16
An attribute $A$ of datatype varchar $(20)$ has value 'Ram' and the attribute $B$ of datatype char $(20)$ has value 'Sita' in oracle. The attribute $A$ has ________ memor...
User Avatar
0 0 votes
1 1 answer
665
665 views
KPGCET-CSE-2019-4
The schema for the entire database is designed using Data definitional languageStructured query languageData manipulation language Schema structure language
User Avatar
0 0 votes
1 1 answer
730
730 views
KPGCET-CSE-2019-8
Couple of the good database design principles suggest that preservation and minimization of functional dependencies. These issues can be resolved byEliminating transitive...
User Avatar
0 0 votes
1 1 answer
601
601 views
KPGCET-CSE-2019-9
The normalization is a way to implementGood software engineering principlesGood database design principlesStructured Query LanguageDatabase Schema
User Avatar
0 0 votes
0 0 answers
323
323 views
KPGCET-CSE-2019-38
In DBMS, the only association would satiate the complete interrelationships set of business processes and in object oriented paradigm, the inter relationships are enhance...
User Avatar
0 0 votes
1 1 answer
1.2k
1.2k views
DBMS Korth Edition 6 Exercise 7 Question 29 (Page No. 321)
Explain the distinction between total and partial constraints.
User Avatar
0 0 votes
1 1 answer
1.3k
1.3k views
DBMS Korth Edition 6 Exercise 7 Question 28 (Page No. 321)
Explain the distinction between disjoint and overlapping constraints.
User Avatar
2 2 votes
0 0 answers
797
797 views
DBMS Korth Edition 6 Exercise 7 Question 27 (Page No. 321)
Explain the distinction between condition-defined and user-defined constraints.Which of these constraints can the system check automatically?Explain your answer.
User Avatar
5 5 votes
0 0 answers
2.3k
2.3k views
DBMS Korth Edition 6 Exercise 7 Question 26 (Page No. 321)
Design a generalization-specialization hierarchy for a motor vehicle salescompany. The company sells motorcycles, passenger cars, vans, and buses.Justify your placement o...
User Avatar
Page: