1.2 What is the most commonly used type of database?
Ans. The most commonly used type of database is Relational Database.
1.7 Define the terms data and information. Explain how the two terms differ.
Ans. There is a subtle difference between data and information. Data are the facts or details from which information is derived. Individual pieces of data are rarely useful alone. For data to become information, data needs to be put into context.
1.22 Define the term database.
Ans. Database is a collection of data in an organized form which allows a user for fast storage and retrieval of required data.
1.27 Is Microsoft Access a DBMS? Why or why not?
Ans. Microsoft Access is not just a DBMS it is also an Application Generator. Although Microsoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, report, and query components that are the Microsoft Access application Generator.
1.33 Name the components of an enterprise-class database system.
Ans. These are the components of an enterprise-class database system: 1. Applications Running Over Corporate Network 2. E-Commerce Applications on Web Server 3. Web Portal with Reporting Applications 4. XML Web Services Applications 5. Mobile Apps
1.37 List several consequences of a poorly designed database.
Ans. These are the consequences of a poorly designed database: 1. Redundancy 2. Improper Tables or Many Tables for same Object 3. Null Values From Critical Information 4. Primary keys of multiple fields due to bad design
1.45 What job functions does a database administrator perform?
Ans. Database administrators are primarily concerned with the management of the database like Designing, Construction & Managing the database.
1.50 What were the early objections to the relational model?
Ans. In 1970 E. F. Codd Created the Relational Model for database. Codd’s work was at first viewed as too theoretical for practical implementation. Practitioners argued that it was too slow and required so much storage that it would never be useful in the commercial world.
1.52 What are some of the reasons for the success of Oracle Database?
Ans. Oracle Database achieved success for many reasons, one of which was that it would run on just about any computer and just about any operating system. However, in addition to being able to run on many different types of machines, Oracle Database had, and continues to have, an elegant and efficient internal design.
1.59 What is XML? What comment did Bill Gates make regarding XML?
Ans. XML means Extensible Markup Language. It is a Markup Language which is used to exchange text, data & graphics between different types of computers.
Bill Gates said that “XML is the lingua-franca of the Internet Age.”