Which of the following relational algebraic operations is not from set theory?
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The graphical representation of a query is .
A _____ is a logical unit of database processing that includes one or more data access operations that…
The data models defined by ANSI/SPARC architecture are
DBMS is a collection of _____ that enables user to create and maintain a database.
In SQL the statement select * from R, S is equivalent to
The rule that a value of a foreign key must appear as a value of some specific table is called a
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
In multiple granularity of locks SIX lock is compatible with
Tree structures are used to store data in
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
Grant and revoke are _____ statements.
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Which of the following statement on the view concept in SQL is invalid?
The drawback of shadow paging technique are
operator is used to compare a value to a list of literals values that have been specified.
Relationships among relationships can be represented in an-E-R model using
An advantage of views is
Relations produced from an E-R model will always be
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
____specifies a search condition for a group or an aggregate.
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
If a transaction T has obtained an exclusive lock on item Q, then T can
____ table store information about database or about the system.
Which normal form is considered adequate for normal relational database design?
The keyword to eliminate duplicate rows from the query result in SQL is
_____is a full form of SQL.
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter