Micosoft office - class-XII
Description: micosoft office | |
Number of Questions: 36 | |
Created by: Gagan Singh | |
Tags: accounting using data base management system (dbms) computerised accounting accountancy computer in accounting final accounts with adjustments database management system application of electronic spreadsheet in accounting |
A relation is given an identity by its ___and description by its ____.
In relational data model each row of a table is called as ______________.
In relational data model column header is called as_________.
Code is known as ________of account.
A column header is called an __________, in relational data model.
In database, the ___________ implies that distinct tables have been logically organised and the purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.
The ________ represents the database as collection of relations, which resembles a table of values (or data table).
A row is called a _________, in relational data model.
In database, __________ means that all those who are authorised to use data/information have access to relevant data.
__________ refers to data that have been processed and organised in a form, which is suitable for decision-making.
Among several representational models, __________ is the most popular and widely used in actual practice.
__________ is defined as a set of programs, which are designed and developed for a community of users and not for any particular application with respect to a particular user.
The data type describing the types of values (such as text value, numeric values, data values, currency value, etc.) that can appear in each column is called a ________, which is a set of indivisible values.
When a relation has more than one attribute with unique values, each such attribute is called:
The four constraints that can be specified on relational databases are _____________________.
A __________ is a set of tuples wherein each tuple is an ordered list of values corresponding to attributes of relation.
Each row of a table is called a _________, in relational data model.
Each simple attribute of an entity type is associated with a value set called _____ of values.
A __________ is a set of relation schemas and a set of integrity constraints.
Entity integrity constraint states that no ______ key value can be null because it is used to identify individual tuple in a relation.
The ______ for binary relationship specifies the number of relationship instance that an entity can participate in.
The integrity constraints, specified on ________, must hold in every database state of that schema.
A special value called ______ is used to represent unknown or not applicable values of attributes in a tuple.
While ______ and ________ constraints are specified on individual relation, the _______ constraint is specified between two or more relations.
Every relation that has at least one key by default, which is the combination of all its attributes is called _________ by default, which specifies uniqueness constraint.
____________ is defined as that part of super-key from which any attribute cannot be removed without sacrificing the uniqueness constraint.
The minimal super-key is also called ______.
___________ operation is carried out to remove a tuple from a relation.
_______ operation on Relational Data Model does not cause violation any integrity constraints.
Which of the following are the constraints of database schemas?
a. Domain constraints, Key constraints, Entity integrity constraints, Referential integrity constraints
b. Domain constraints, Data constraints, Entity integrity constraints, Referential integrity constraints
Which of the following statements are correct for Relational Data Model (RDM):
a. Relational Data Model (RDM) is the most popular and widely used in actual practice.
b. Relational data model represents the database as collection of relations, which resembles a table of values.
The value of each attribute of a relation must be an indivisible value and drawn out of possible values associated with its ________.
A ________ state is a set of relation states such that every relational database state satisfies the integrity constraints specified on relational database schema.
The ___________ model represents the database as collection of relations, which resembles a table of values (or data table).
While key and entity constraints are specified on individual relation, the referential integrity constraints is specified between _________ relations.
The two categories of operations on relational model are ______ and ______.