The information about data in a database is called _______.
The ER model includes additional concepts like:
A data dictionary is a special file that contains?
Which of the following hardware component is the most important to the...
Which relationship is used to represent a specialization entity?
Every time attribute A appears, it is matched with the same value of...
What operator tests column for the absence of data?
In a one-to-many relationship, the entity that is on the one side of...
E-R modelling techniques is a:
The highest level in the hierarchy of data organization is called
Immediate database modification technique uses
When transaction Ti requests a data item currently held by Tj , Ti is...
Which of the following is not true of the traditional approach to...
Find the names of these cities with temperature and condition whose...
In SQL, which command(s) is(are) used to change a table's storage...
Which normal form is considered adequate for normal relational...
The database system must take special actions to ensure that...
............ protocol grantees that a set of transactions becomes...
In a two-phase locking protocol, a transaction release locks in...
Which of the following is a procedure for acquiring the necessary...
Consider the following transaction involving two bank accounts x and...
A unit of storage that can store one or more records in a hash file...
The file organization which allows us to read records that would...
The command ________________ such tables are available only within the...
Which of the following gives a logical structure of the database...
The current copy of the database is identified by a pointer, called...
Every weak entity set can be converted into a strong entity set by:
A functional dependency is a relationship between or among:
The total participation by entities is represented in the E-R diagram...
The situation in which a transaction holds a data item and waits for...
A _____________ constraint requires that an entity belong to no more...
The DBMS acts as an interface between what two components of an...
The completeness constraint may be one of the following: Total...
A ________ is a logical grouping of database objects, usually to...
Which level of RAID refers to disk mirroring with block striping?
If every functional dependency in set E is also in closure of F then...
___________ is the collection of memory structures and Oracle...
Suppose we are given a view tot credits (year, num credits) giving the...
Find the temperature in increasing order of all cities
Consider the following transactions with data items P and Q...
Which of the following statement on the view concept in SQL is invalid...
Weak entity relationship is represented as
Which one of the following statements if FALSE?
Consider the following relational schemes for a library database:...
Relation R has eight attributes ABCDEFGH. Fields of R contain only...
The relation schema Student_Performance (name, courseNo, rollNo,...
Consider a relation R(A,B,C,D,E) with the following functional...
A table has fields F1, F2, F3, F4, and F5, with the following...
Consider a schema R(A, B, C, D) and functional dependencies A -> B...
Let R(A,B,C,D,E,P,G) be a relational schema in which the following FDs...
Consider the transactions T1, T2, and T3 and the schedules S1 and S2...
Relation R has eight attributes ABCDEFGH. Fields of R contain only...
Relation R with an associated set of functional dependencies, F, is...
The relation EMPDT1 is defined with attributes empcode(unique), name,...
Consider the following functional dependencies in a database. ...
Inst_dept (ID, name, salary, dept name, building, budget) is...