Relational DBMS
Comprehensive quiz covering fundamental concepts in Relational Database Management Systems including SQL, relational algebra, constraints, transactions, keys, and database structures.
Questions
Which of the following forms of SQL is designed for use within general purpose programming languages such as PL/I, COBOL, Pascal and C?
- Data definition language
- Data manipulation language
- Transactional control
- Embedded DML
- View definition
Which of the following entity constraints in DBMS requires that an entity belongs to no more than one lower level entity set?
- Overlapping
- Disjoint
- Key constraint
- Not null constraint
- Condition defined
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?
- Query language
- Relational algebra
- Tuple relational calculus
- DML precompiler
- DBA
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.
- sequential
- heap
- index
- clustering
- direct
Which of the following is a binary operation that allows us to combine certain selections and a cartesian product into one operation?
- Cartesian product
- Set difference
- Project
- Natural join
- Union
In _____________ mode/phase, the transaction only wants to read the data item.
- exclusive
- shared
- growing
- shrinking
- deadlock
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?
- Atomicity
- Commit
- Isolation
- Durability
- Serialisability
Which of the following terms in database refers to the number of tuples or records that it contains in a relation?
- Attribute
- Cardinality
- Degree
- Relation
- Tuple
In a database relation, when one or more fields serve as primary key, then such a key is called
- alternate key
- foreign key
- composite key
- secondary key
- attribute key
Which of the following operations in relation algebra requires two relations having the same number of attributes?
- Cartesian product
- Intersection
- Union
- Set difference
- Select
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?
- Hierarchical data model
- Relational data model
- Network data model
- Relational algebra
- Project
Which of the following objects in SQL is a predicate expressing a condition that we wish the database always to satisfy?
- Triggers
- Cursor
- Assertion
- Alerts
- Primary key
Which of the following languages includes a query language based on both the relational algebra and the tuple relational calculus?
- Embedded DML
- DDL
- DML
- TCL
- Assembly language
______ is the time taken to find a particular data item or a set of items using the technique in a database query.
- Insertion time
- Deletion time
- Access time
- Space overhead
- Access types
Which of the following structures in oracle database consists of datafiles, redo log files and control files?
- Database blocks
- Schema
- Physical structure
- Extent
- Segment