Which of the following is used for storing DDL Statement or database schema?
Data Dictionary
Tables
Both a and b
None of these
Which constraint uniquely identifies each record in a database table?
Foreign key
Super key
Candidate key
Primary key
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 is the collection of related fields?
Field
Record
File
Data
Which of the following is an advantage of DBMS?
Prevent data redundancy
Restrict unauthorized access
Data can be shared
All of the above
what is meta data?
Small amount of data
Data about data
Redundant data
Collection of data
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
Which is the most popular database model?
Network model
Relational model
Hierarchical model
Object model
What is a primary goal of a DBMS?
Provide an environment to store and retrieve database information
It can handle many files of information at a time
Database management system helps in making decision
Utilize a database for data processing activities
Which of the following is database language?
DML
DDL
Query Language
