Which of the following is an advantage of DBMS?
Prevent data redundancy
Restrict unauthorized access
Data can be shared
All of the above
Which of the following is referred as rows of a relation in RDBMS?
Domain
Relation
Tuple
Attributes
Which of the following is the collection of related fields?
Field
Record
File
Data
Which of the following feature provides the ability to modify a schema definition at one level without affecting the schema definition at the next higher level?
Data Abstraction
Data manipulation
Data independency
Data structure
Which of the following include schema definition?
DML
DDL
DCL
DQL
Which of the following is correct about cardinality?
Number of rows or tuples in a relation
Columns of a relation
Rows of a relation
Attributes of a relation
Which of the following have the information about data?
Metadata
Entity
Relations
Which is the main component of DBMS?
Data management system
Data base processing system
Database
Which dbms represents the db as a collection of relations and is assigned with a unique name?
Relational DBMS
Navigational DBMS
SQL DBMS
Application DBMS
What is data redundancy?
Duplication of data
Smallest unit of stored data
Data about data
Sharing of data
