Database Management System MCQs
749+ questions with answers
A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
What are the desirable properties of a decomposition
R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
Which normal form is considered adequate for normal relational database design?
Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies: F1->F3 F2->F4 (F1,F2)->F5
Let R(A,B,C,D,E,P,G) be a relational schema in which the following FDs are known to hold: AB->CD DE->P C->E P->C B->G
The normal form which satisfies multivalued dependencies and which is in BCNF is
Which of the following is a tuple-generating dependencies?
The main task carried out in the __________ is to remove repeating attributes to separate tables.
Which of the normal form is based on multivalued dependencies?
Which forms has a relation that possesses data about an individual entity?
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
Fifth Normal form is concerned with
In 2NF
_____________ can help us detect poor E-R design.
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
Designers use which of the following to tune the performance of systems to support time-critical operations?
In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:
A method of modelling and describing user tasks for an interactive application is referred to as:
Information architecture influences:
Also known as schematics, a way of illustrating the layout of an individual webpage is a:
A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:
Blueprints are intended to:
Which of the following occupies boot record of hard and floppy disks and activated during computer startup?
A graphical or text depiction of the relationship between different groups of content on a website is a:
Which of the following is a description of information organization schemes?
Which of the following is a valid uniform resource locator?
http://www.google.com/search?q=silberschatz In the above URL which one is the argument which is used for processing of the URL?
HTTP defines two ways in which values entered by a user at the browser can be sent to the Web server. The _____ method encodes the values as part of the URL.
A __________ is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.
The application program typically communicates with a database server, through ___________ or other protocols, in order to get or store data.
This extra information is usually maintained in the form of a _________ at the client.
Html document must always be saved with:
The Java __________ specification defines an application programming interface for communication between the Web server and the application program.
The doGet() method in the example extracts values of the parameter’s type and number by using __________
Which JDBC driver Type(s) can be used in either applet or servlet code?
What MySQL property is used to create a surrogate key in MySQL?