Which of the following is not a function provided by the DBMS?
Anonymous Quiz
5%
Data security
9%
Concurrency
77%
Generating reports from the data
10%
Data integrity
Performance in a database system refers to
Anonymous Quiz
14%
System protection against hardware or software malfunction
12%
Security protection against unauthorized or malicious access
12%
Constructing the database
62%
Optimizing the speed and efficiency of database operations
Advantages of database
Anonymous Quiz
6%
It needs expertise to use
90%
Inconsistency can be avoided.
4%
DBMS itself is expensive
Which component of a database system is responsible for identifying the data to be stored and choosing appropriate structures to represent and store the data?
Anonymous Quiz
13%
Application programmer
24%
Database administrator
47%
Logical database designer
15%
Physical database designer
Who is responsible for the physical realization of the database, authorizing access, and coordinating and monitoring its use?
Anonymous Quiz
6%
Application programmer
50%
Database administrator
7%
Logical database designer
38%
Physical database designer
Who determines the requirements of end users in a database system?
Anonymous Quiz
35%
Application programmers
13%
Database administrators
52%
System analysts
Which component of a database system interacts with the database by issuing appropriate requests (SQL statements) to the DBMS?
Anonymous Quiz
72%
Application programmer
18%
Database administrator
10%
Logical database designer
Which type of database system allows at most one user to access the database at any given time?
Anonymous Quiz
79%
Single-user DBS
16%
Multi-user DBS
5%
Naïve user DBS
Which category of end users is unaware of the DBMS and accesses the database using application programs?
Anonymous Quiz
83%
Naïve users
8%
Sophisticated end-users
5%
System analysts
4%
Workers behind the scene
What is the main responsibility of system analysts in a database system?
Anonymous Quiz
15%
Acquiring software and hardware resources
9%
Designing security measures for the data
77%
Determining the requirements of end users
Which type of database system allows many users to access the database at the same time?
Anonymous Quiz
2%
Single-user DBS
95%
Multi-user DBS
3%
Sophisticated user DBS
Familiar with the structure of DB and DBMS
Anonymous Quiz
13%
Naïve users
87%
Sophisticated end-user
What is the first phase of the Database Development Life Cycle?
Anonymous Quiz
32%
Design
52%
Analysis
16%
Implementation
Which phase of the Database Development Life Cycle focuses on identifying the requirements and constraints of the database system?
Anonymous Quiz
33%
Design
48%
Analysis
19%
Implementation
Data design involves
Anonymous Quiz
13%
logical model
11%
physical model
76%
logical model , physical model
Implementation doesn't involves
Anonymous Quiz
23%
data conversion and loading
18%
testing
59%
Planning
A major purpose of a database system is to provide users with an abstract view of the data.
Anonymous Quiz
91%
T
9%
F