Relational DBMS
Which of the following forms of SQL is designed for use within general purpose programming languages such as PL/I, COBOL, Pascal and C?
Which of the following entity constraints in DBMS requires that an entity belongs to no more than one lower level entity set?
Which of the following is a procedural query language that consists of a set of operations that takes one or two relations as input and produces a new relation as their result?
The file organisation in DBMS in which any record can be placed anywhere in the file where there is space for the record is called _________ file organisation.
Which of the following is a binary operation that allows us to combine certain selections and a cartesian product into one operation?
In _____________ mode/phase, the transaction only wants to read the data item.
Which of the following properties of transaction in distributed database guarantees that when the transaction is committed, the results of operations will never be lost, independent of subsequent failures?
Which of the following terms in database refers to the number of tuples or records that it contains in a relation?
In a database relation, when one or more fields serve as primary key, then such a key is called
Which of the following operations in relation algebra requires two relations having the same number of attributes?
In which of the following data models in DBMS, the relationship between records is represented by a relation that contains a key for each record involved in the relationship?
Which of the following objects in SQL is a predicate expressing a condition that we wish the database always to satisfy?
Which of the following languages includes a query language based on both the relational algebra and the tuple relational calculus?
______ is the time taken to find a particular data item or a set of items using the technique in a database query.
Which of the following structures in oracle database consists of datafiles, redo log files and control files?