DBMS
Description: Free Online DBMS Test for Placement and GATE Examination | |
Number of Questions: 50 | |
Created by: Adhira Saini | |
Tags: DBMS DBMS Database Computer Science Question GATE Question Data Structure Databases Programming and Data Structures |
A director's salary details are hidden from the employee. This process is called
In a multi-user database, if two users wish to update the same record at the same time, they are prevented by
Data security threat includes
A locked file can be
Locking can be used for
Transaction X holds a shared lock R. What happens if transaction Y requests for a shared lock on R?
Which command is used to remove rows from a table?
Which of the following is the characteristic of a relational database model?
Which command is used to remove a table or index from the database in SQL?
The command used to select only one copy of each set of duplicable rows is called
The model for a record management system might be a
Which of the following is at the highest level in the hierarchy of data organisation?
Which database handles full text data, image, audio and video?
Which of the following contains a complete record of all the activities that affect the contents of a database?
A data dictionary does not provide information about
Which of the following is a record based logical model?
Which of the following is a relational database?
Which of the following is the highest level of data abstraction?
A DBMS consists of application programs called
A large computer information system maintains many different computer files, which file is called perpetual file?
An entry in a telephone book can be compared to a
The logical data structure with one to many relationship is a
Which language is used by most DBMS for helping their users to access the data?
A schema describes
Data item characteristics that are important in data management include
The modify operation is likely to be done after
A report generator is used to
The distinguishable parts of a record are called
The set of permitted values for each attribute is called its
In a relational schema, each tuple is divided into fields called
The database environment has all of the following components except
Report generators are used to
Which of the following is the problem of file management system?
The index consists of
Periodically adding, changing and deleting file records is called file
In relation, model column is referred to as
E-R Model comes under
The way a particular application views the data from the database that the application uses is a
Embedded pointers provide
An attribute of one table matching the primary key of another table is called as
Which of the following is more concerned about the conceptual level of the DBMS?
If a relation is in BCNF, it is also in
Relations produced from an E-R model will always be in
In relational database systems, attributes correspond to
E-R modeling technique is a
Which of the following is not a record based logical model?
A table consists of
In an E-R diagram, ellipses represents
If every non key attribute is functionally dependent on the primary key, the relation will be in
If every non-key attribute is functionally dependent on the primary key, the relation will be in