........... s the intermediate layer between the database and the programs that access the data.
Anonymous Quiz
4%
DB
86%
DBMS
10%
BOTH
........... is collection of programs that enables users to create and maintain a database and control access to them.
Anonymous Quiz
8%
DB
85%
DBMS
7%
BOTH
the primary key cannot have a NULL value, so the candidate key with a NULL value can be the primary key
Anonymous Quiz
39%
T
61%
F
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