SQL server stores index information in the _____system table
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
In an E-R diagram double lines indicate
Which of the following is not a consequence of non-normalized database?
Drop Table cannot be used to drop a table referenced by a ______ constraint.
The values of the attribute describes a particular
A _____ is a logical unit of database processing that includes one or more data access operations that…
Which of the following is not a property of transactions?
The statement that is executed automatically by the system as a side effect of the modification of the…
DBMS helps achieve
Which of the following is a reason to model data?
A top-to-bottom relationship among the items in a database is established by a
Data independence means
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
In an ER model,_____ is described in the database by storing its data.
Maximum height of a B+ tree of order m with n key values is
Grant and revoke are _____ statements.
The clause alter table in SQL can be used to
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
In multiple granularity of locks SIX lock is compatible with
Which of the following is not a consequence of concurrent operations?
Isolation of the transactions is ensured by
The _______ is a set of programs to use and / or modify this data.
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
What is a disjoint less constraint?
Which of the following is not comparison operator?
Which of the following addressing modes permits relocation without any change over in the code?
Cascading rollback is avoided in all protocol except
The cost of reading and writing temporary files while evaluating a query can be reduced by
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter