Which of the following is not a logical database structure?
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The ______ indexes are forced to store only record IDs in the data structure and require at least one…
Relationships among relationships can be represented in an-E-R model using
Which of the following concurrency control schemes is not based on the serializability property?
The relational model is based on the concept that data is organized and stored in two-dimensional tables…
What is data integrity?
The cost of reading and writing temporary files while evaluating a query can be reduced by
Manager salary details are hidden from the employee .This is
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
Which of the following relational algebraic operations is not from set theory?
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
The _______ is a set of programs to use and / or modify this data.
As per equivalence rules for query transformation, selection operation distributes over
Dependency preservation is not guaranteed in
An advantage of views is
______is a special type of integrity constraint that relates two relations & maintains consistency across…
DBMS helps achieve
The keyword to eliminate duplicate rows from the query result in SQL is
Grant and revoke are _____ statements.
Isolation of the transactions is ensured by
In multiple granularity of locks SIX lock is compatible with
A logical schema
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
In b-tree the number of keys in each node is than the number of its children.
Which of the following is true for network structure?
Shadow paging has
____ table store information about database or about the system.
What is a disjoint less constraint?
operator is used to compare a value to a list of literals values that have been specified.
A data type or format is specified for each _________
………………… approach reduces time and effort required for design…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter