Data Base Study Guide

1.Q.What is a infobase? A.A collection of related selective information. Oracle, SQL Server, DB2, MySQL, PostGres SQL, ACCESS 2.Q.What is the discrimination surrounded by DBMS and RDBMS? A.In dbms, relation is between 2 files. In rdbms relation is made between two tables. rdbms follows 12 rules of codd. 3.Q.What is a table? A.A set of values organized in columns and rows. Table = entity 4.Q.Data redundancy A.Storing information in more than nonpareil place in a infobase. Could lead to faulting or mutual exclusiveness 5.Q.Primary and Foreign keys A.Primary is a unique ID. Foreign is a tike pk from parent table. 6.Q.What is SQL? A. merged query language used in relational db to create objects and modify and retrieve information 7.Q.Entity, holding, ER diagram A.Something that the db is concerned with, about which data bear be stored, and which can have relationships with other entities. Attributes pin down entities. ERD common method of enactment enti ties and relations in a diagram. 8.Q.Which of the next best defines the margin database requirement A.C. Something a database essential do to fulfill its affair function 9.Q.Which of these best defines data integrity? A.A. The accuracy and correctness if the data in the database 10.Q.

A document that has the primary purpose of summarizing and displaying data is called a A.D. circulate 11.Q.The focus of a database, the business problem it is designed to illumine is called A.B. the domain of the database 12.Q.Work Shadowing A.Following and observing persons as they fo by means of their work routine 13.Q.An specify or combination of belongingss that could be used as the pri mary key for an entity is a A.A. candida! te key 14.Q.Composite key A.A key that consists of more than one attribute 15.Q.Which of the following statements is an advantage of a indwelling key? A.A. a natural key helps protect data integrity by preventing unintended entry of duplicate rows. 16.Q.A natural key is an attribute that naturally belongs...If you want to get a full essay, serve it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay