Database Test 2 Computer Subject
Database Test 2 Computer Subject
Question 1
Which of the following is not one of the three schemas used in the ANSI/SPARC?
The three schemas are external, internal, and conceptual; 'Implementation' is not part of the ANSI/SPARC model.
Not clear enough?
Question 2
Which of three schemas used in the three-schema model represents how users view the database?
The external schema defines how individual users or applications view the data in the database.
Not clear enough?
Question 3
Which of three schemas used in the three-schema model is a complete logical view of the database?
The conceptual schema provides a complete logical representation of all data in the database, independent of physical storage.
Not clear enough?
Question 4
Which of three schemas used in the three-schema model shows physical storage using a particular product or technique?
The internal schema defines how the data is physically stored and organized on storage media.
Not clear enough?
Question 5
Which of the following data models stores data in table structures and performs various operations on table rows and columns?
The relational model organizes data into tables (relations) and supports operations on rows and columns.
Not clear enough?
Question 6
Although all database professionals are concerned with performance, select the database professional that is most likely to be concerned about database performance:
Database administrators are primarily responsible for performance tuning, monitoring, and optimization of database systems.
Not clear enough?
Question 7
Which data model creates parent-child relationships between data elements and restricts each child to have just one parent?
The hierarchical data model enforces a tree-like structure where each child has only one parent.
Not clear enough?
Question 8
Which of the following is not a major area for the database administrator?
DBAs focus on planning, implementation, and security, but programming is usually handled by application developers.
Not clear enough?
Question 9
When discussing a data model under construction, users speak in terms of the _______ schema they work with, which database developers must translate into ______ schema?
Users work with the external schema, which developers translate into the conceptual schema for the overall database.
Not clear enough?
Question 10
The older logical database model that organizes data in a tree-like structure is?
The hierarchical model organizes data in a tree structure with parent-child relationships.
Not clear enough?
You might like
'That year the harvest was sad, like a funeral and many farmers wept as they dug up the miserable yams. One man tied his clothe to a tree branch and hanged himself.
Chinua Achebe: Things Fall Apart.
The mood conveyed in the excerpt above is one of
Tossing a coin and rolling a die are two separate events. What is the probability of obtaining a tail on the coin and an even number on the die?