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
the pin code
the last name
the compound key first name and last name
Tr from next page
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
A transaction is in state after the final statement has been executed.
SQL server stores index information in the _____system table
The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
Which of the following is not a consequence of non-normalized database?
Which of the following is not a recovery technique?
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Change Staff table by removing default of Assistant for position column
Which is the best file organization when data is frequently added or deleted from a file?
Relations produced from an E-R model will always be
For correct behaviour during recovery, undo and redo operation must be
The relational model is based on the concept that data is organized and stored in two-dimensional tables…
The fact that all employees of a particular organization should not have salaries more than $10000 is…
If the closure of an attribute set is the entire relation then the attribute set is a
Which of the following statement on the view concept in SQL is invalid?
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
Which of the following is a reason to model data?
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
The clause alter table in SQL can be used to
approach reduces time and effort required for design and lesser risk in database management.
The graphical representation of a query is .
The set of all values that can be taken by the attribute is called as _______ of the attribute.
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
In SQL, testing whether a subquery is empty is done using
In an ER model,_____ is described in the database by storing its data.
operator is used to compare a value to a list of literals values that have been specified.
According to the levels of abstraction, the schema at the intermediate level is called
Which one is true statement :
The common column is eliminated in
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter