In an E-R diagram double lines indicate
None of the above.
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Which of the following is not a logical database structure?
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
In E-R Diagram total participation is represented by
A _____ is a logical unit of database processing that includes one or more data access operations that…
The language that requires a user to specify the data to be retrieved without specifying exactly how…
______is a special type of integrity constraint that relates two relations & maintains consistency across…
An outstanding functionality of SQL is its support for automatic_____ to the target data.
In a relational schema, each tuple is divided into fields called
A _____ is used to define overall design of the database
DROP is a statement in SQL.
______contains information that defines valid values that are stored in a column or data type.
____ table store information about database or about the system.
Change Staff table by removing default of Assistant for position column
An advantage of views is
Tree structures are used to store data in
Which of the following relational algebraic operations is not from set theory?
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
If a transaction T has obtained an exclusive lock on item Q, then T can
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
In multiple granularity of locks SIX lock is compatible with
The one guideline to be followed while designing the database is
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
Cascading rollback is avoided in all protocol except
Checkpoints are a part of
Shadow paging has
The set of all values that can be taken by the attribute is called as _______ of the attribute.
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
A table can have only one
Which is the best file organization when data is frequently added or deleted from a file?
The full form of GUI is _________
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter