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.
Manager salary details are hidden from the employee .This is
______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 _________
A _____ is used to define overall design of the database
The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
For correct behaviour during recovery, undo and redo operation must be
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
Data items grouped together for storage purposes are called a
A top-to-bottom relationship among the items in a database is established by a
When an E-R diagram is mapped to tables, the representation is redundant for
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
_____ database is used to provide statistical information or summaries of values based on various criteria.
______ keyword is used to find the number of values in a column.
Which of the following is a reason to model data?
The statement that is executed automatically by the system as a side effect of the modification of the…
The clause alter table in SQL can be used to
Which of the following is not comparison operator?
approach reduces time and effort required for design and lesser risk in database management.
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
A logical schema
______is a special type of integrity constraint that relates two relations & maintains consistency across…
Data independence means
In E-R Diagram total participation is represented by
Change Staff table by removing default of Assistant for position column
E-R Modeling is achieved by using ____ diagrams
Drop Table cannot be used to drop a table referenced by a ______ constraint.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
Cascading rollback is avoided in all protocol except
In SQL, testing whether a subquery is empty is done using
SQL server stores index information in the _____system table
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter