Database
| Description: Complete study material for DBMS, RDBMS, Data Base Management System, Relational Data Base Management System, Primary Key, Foreign Key, Data, Information to prepare for B.Sc-IT, M.Sc-IT, BCA, MCA, MCa Entrance | |
| Number of Questions: 50 | |
| Created by: Avani Handa | |
| Tags: DBMS RDBMS Data Base Management System Relational Data Base Management System Primary Key Foreign Key Data Information B.Sc-IT M.Sc-IT BCA MCA MCa Entrance Databases |
If every non key attribute is functionally dependent on the primary key, the relation will be in
Which of the following is a record based logical model?
Redundancy is dangerous as it is a potential threat to
The set of permitted values for each attribute is called its
Which of the following is more concerned about the conceptual level of the DBMS?
Relations produced through an E-R model will always be in
An attribute of one table matching the primary key of another table is called
The way a particular application views the data from the database, which is used by application, is a
Locking can be used for
In an E-R diagram, an ellipsis represents
If a relation is in BCNF, it is also in
ER Model comes under
Which of the following is/are the problem(s) of file management system?
In Relation Model, column is referred to as
Which of the following is/are relational database?
Periodically adding, changing and deleting file records is called
An Index consists of
The set of permitted values for each attribute is called its
E-R modeling technique is a
A locked file
A DBMS consists of application programs called
Transaction X holds a shared lock R. If transaction Y requests for a shared lock on R
The command used to select only one copy of each set of duplicable rows is
Which command is used to remove a table or index from the database in SQL?
In a relational schema, each tuple is divided into fields called
Which of the following is the characteristics of a relational database model?
Which command(s) is/are used to remove rows from a table?
The 'modify' operation is likely to be done after ___________ operation.
A report generator is used
Report generators are used to
A database environment has all of the following components, except
Director's salary details are hidden from the employee. This is called
Embedded pointers provide
The distinguishable parts of a record are called
If every non-key attribute is functionally dependent on the primary key, the relation will be in
Which of the following is a record based logical model?
A schema describes
Which language is used by most of DBMS's for helping their users to access data?
Which of the following is at the highest level in the hierarchy of data organization?
A data dictionary does not provide information about
Which database handles full text data, image, audio and video?
all of the above
The logical data structure with one to many relationship is
An entry in a telephone book can be compared to a
Data item characteristics that are important in data management include
Which of the following contains complete record of all activities that affect the contents of a database?
The model for a record management system might be
A large computer information system maintains many different computer files. Which file is perpetual file?
In a multi-user database, if two users wish to update the same record at the same time, they are prevented by
A table consists of