What is the self-describing nature of a database system?
Anonymous Quiz
68%
It contains a complete definition of the database structure and constraints.
24%
It requires the use of metadata to describe the data.
9%
It stores data items and values separately.
What is stored in the DBMS catalog of a database system?
Anonymous Quiz
13%
Data items and values
80%
Metadata describing the structure and constraints of the database
7%
Virtual data derived from the database files
Which type of systems do not require metadata in NOSQL systems?
Anonymous Quiz
31%
File-based systems
19%
Database systems
38%
Self-describing systems
12%
Virtual data systems
What is the insulation between programs and data called in a database system?
Anonymous Quiz
63%
Program-data independence
9%
File-based structure
28%
DBMS catalog
What does a view represent in a database system?
Anonymous Quiz
12%
The structure of the data files
53%
The virtual data derived from the database files
22%
The subset of the database
13%
The programs that access the database
Constructing the database refers to:
Anonymous Quiz
76%
Storing the data on a storage medium controlled by the DBMS
13%
Retrieving specific data from the database
3%
Generating reports from the data
9%
Updating the database to reflect changes in the miniworld
he database catalog or dictionary stores:
Anonymous Quiz
48%
Data types, structures, and constraints of the data
40%
Descriptive information about the database
12%
Queries to retrieve specific data
Sharing a database allows
Anonymous Quiz
94%
Multiple users and programs to access the database simultaneously
1%
Constructing the database
5%
Manipulating the database
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