DBMS is a collection of _____ that enables user to create and maintain a database.
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The graphical representation of a query is .
The statement that is executed automatically by the system as a side effect of the modification of the…
A relational database developer refers to a record as
The middleware databases in which the business rules act are applicable to _______ tier architectures
_____ command can be used to modify a column in a table
If the closure of an attribute set is the entire relation then the attribute set is a
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
In E-R Diagram total participation is represented by
Which is the best file organization when data is frequently added or deleted from a file?
Relationships among relationships can be represented in an-E-R model using
In an ER model,_____ is described in the database by storing its data.
Which of the following addressing modes permits relocation without any change over in the code?
In SQL the word natural can be used with
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
A data type or format is specified for each _________
According to the levels of abstraction, the schema at the intermediate level is called
Tree structures are used to store data in
Which two files are used during operation of the DBMS?
Which one is true statement :
______contains information that defines valid values that are stored in a column or data type.
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
______is a preferred method for enforcing data integrity
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
Data items grouped together for storage purposes are called a
The ______ indexes are forced to store only record IDs in the data structure and require at least one…
Key to represent relationship between tables is called
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
The metadata is created by the