Related Questions
What is the correct answer?
4
Which of the following is true for network structure?
A. It is a physical representation of the data.
B. It allows many to many relationship.
C. It is conceptually simple.
D. It will be the dominant database of the future.
What is the correct answer?
4
Protection of data from unauthorized Disclosure results in loss of _______
D. Discretionary Security
What is the correct answer?
4
Which of the following relational algebraic operations is not from set theory?
What is the correct answer?
4
The part of a database management system which ensures that the data remains in a consistent state is
A. authorization and integrity manager
What is the correct answer?
4
What are the desirable properties of a decomposition
B. Dependency preservation.
What is the correct answer?
4
In an ER model,_____ is described in the database by storing its data.
What is the correct answer?
4
____ table store information about database or about the system.
What is the correct answer?
4
Which of the following addressing modes permits relocation without any change over in the code?
C. PC relative addressing
D. Base register addressing
What is the correct answer?
4
The normal form that is not necessarily dependency preserving is
What is the correct answer?
4
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
What is the correct answer?
4
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
What is the correct answer?
4
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
What is the correct answer?
4
Relationships among relationships can be represented in an-E-R model using
D. Weak relationship sets
What is the correct answer?
4
Immediate database modification technique uses
D. Neither undo nor redo.
What is the correct answer?
4
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
What is the correct answer?
4
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
What is the correct answer?
4
Which of the following statement on the view concept in SQL is invalid?
A. All views are not updateable
B. The views may be referenced in an SQL statement whenever tables are referenced.
C. The views are instantiated at the time they are referenced and not when they are defined.
D. The definition of a view should not have GROUP BY clause in it.
What is the correct answer?
4
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
What is the correct answer?
4
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
What is the correct answer?
4
The default level of consistency in SQL is
What is the correct answer?
4
Which is the best file organization when data is frequently added or deleted from a file?
What is the correct answer?
4
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
What is the correct answer?
4
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
What is the correct answer?
4
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
C. the compound key first name and last name
What is the correct answer?
4
The metadata is created by the
What is the correct answer?
4
The statement that is executed automatically by the system as a side effect of the modification of the database is
What is the correct answer?
4
_____ First proposed the process of normalization.
What is the correct answer?
4
If an entity can belong to only one lower level entity then the constraint is
What is the correct answer?
4
………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database
What is the correct answer?
4
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values