16 questions
Applications of Database are:-
Banking
Sales
Ticket Reservation
HR Management
_______ builds the application programs that provide the required functionality for the end-users.
Data Administrator (DA)
Database Administrator (DBA)
Database Designers (Logical & Physical)
Application Programmers
Column titles are __________________________.
Field Names
Records
Primary Keys
Foreign Keys
Column in a table also known as
Attribute
Entity
Record
Relationship
SQL stands for
structured query language
structured question language
sustainable query language
sustainable question language
___ exists when different versions of the same data appear in different places
Data integrity
Data anomaly
Data redundancy
Data inconsistency
A Database Management System (DBMS) is
Collection of interrelated data
Collection of programs to access data
Collection of data describing one particular enterprise
All of the above
Disadvantages of File systems to store data is:
Data redundancy and inconsistency
Difficulty in accessing data
Data isolation
All of the above
Data Manipulation Language enables users to
Retrieval of information stored in database
Insertion of new information into the database
Deletion of information from the database
All of the above
Which of the following is not an Schema?
Database Schema
Physical Schema
Critical Schema
Logical Schema
Which of the following is Database Language?
Data Definition Language
Data Manipulation Language
Query Language
All of the above
Which of the following in not a function of DBA?
Network Maintenance
Routine Maintenance
Schema Definition
Authorization for data access
Which of the following is a Data Model?
Entity-Relationship model
Relational data model
Object-Based data model
All of the above