click below
click below
Normal Size Small Size show me how
DB Chapter 1
CompTia Dababase Design & MySQL Lesson 7
Question | Answer |
---|---|
Why is storing data in a central repository advantageous? | The data is much easier to manage and manipulate. |
Why does the separation of the database systems and the programs that access them make an application programmer's job easier? | The programmer no longer needs to be concerned with how the database is defined or how it holds the data |
Which of the following can a database designer use to specify constraints on data? | Data Definition Language (DDL) |
Which of the following produced important information concerning database optimization | The Peterlee Relational Test Vehicle |
The development of commercial DBMS products, including IBM's DB2 and Oracle's SQL/DS, grew out of which of the following projects? | SQL |
Who first proposed the relational data model in a paper titled "A Relational Model of Data for Large Shared Data Banks?" | E.F. Codd |
Why is program-data independence advantageous? | New data structures can be added to the database without the need to modify the application programs that access the data. |
In a file-based database, what is the difficulty caused by holding data in separate, disparate files? | The process of accessing and synchronizing multiple files becomes more complex as the number of files that need to be accessed grows |
Which of the following databases is a file containing records that have no structured interrelationship? | Flat-file database |
Because businesses rely on their database systems for mission-critical information, the data within the database should be | organized in a manner that permits easy data retrieval. |
As regards a database management system (DBMS), what is managed concurrency? | A system that controls how multiple users can access data at the same time |