______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Also checkout these categories
Clock MCQ Rearrangement Set 6 MCQ Hydrogen- Water and Hydrogen Peroxide MCQ Microsoft PowerPoint MCQ Physiological and Anatomy of Plants MCQ Direction MCQ Rearrangement Set 1 MCQ Basics of Neurology MCQ Cell Biology MCQ Fungi and Lichens MCQ Chain Rule MCQ Accounts Fundamental MCQ
- ______contains information that defines valid values that are stored in a column or data type.
- By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
- The language that requires a user to specify the data to be retrieved without specifying exactly how…
- The collection of information stored in a database at a particular moment is called as ......
- In a relational schema, each tuple is divided into fields called
- If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
- Wait-for graph is used for
- DROP is a statement in SQL.
- In SQL the word natural can be used with
- Which of the following is not a consequence of concurrent operations?
- The clause alter table in SQL can be used to
- The one guideline to be followed while designing the database is
- The statement that is executed automatically by the system as a side effect of the modification of the…
- If a transaction T has obtained an exclusive lock on item Q, then T can
- A _____ is used to define overall design of the database
- The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
- An outstanding functionality of SQL is its support for automatic_____ to the target data.
- Which of the following is not a consequence of non-normalized database?
- The drawback of shadow paging technique are
- A ______ module is typically designed so that it will run on a user workstation or personal computer.
- The transactions like adding an employee, enrolling a student in a course are examples of _______
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
- The data models defined by ANSI/SPARC architecture are
- A table can have only one
- Which of the following is not a characteristic of a relational database model?
- The size of a data item is called its _______, which can be a field of some record or may be a larger…
- A logical schema
- If an entity can belong to only one lower level entity then the constraint is
- Which of the following constitutes a basic set of operations for manipulating relational data?