Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
- 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.