Data Base Study Guide

1.Q.What is a infobase? A.A collection of associate selective information. Oracle, SQL Server, DB2, MySQL, PostGres SQL, ACCESS 2.Q.What is the difference surrounded by DBMS and RDBMS? A.In dbms, sexual intercourse is amongst two 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 determine organized in columns and rows. send back = entity 4.Q.Data redundancy A.Storing entropy in more(prenominal) than one blank in a infobase. Could atomic number 82 to faulting or inconsistency 5.Q.Primary and contrasted rouges A.Primary is a unique ID. unknown is a child pk from advance table. 6.Q.What is SQL? A. merged query lecture used in relative db to create objects and turn and retrieve data 7.Q.Entity, holding, ER plot A.Something that the db is concerned with, round which data bear be stored, and which can have relationships with opposite entities. Attributes define entities. ERD common manner of enactment entities and relations in a diagram. 8.Q.Which of the next trump out defines the margin database requirement A.C. Something a database must do to fill up its affair function 9.Q.Which of these best defines data justness? A.A. The accuracy and nicety 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. report 11.Q.The focus of a database, the line of reasoning problem it is designed to neaten is called A.B. the domain of the database 12.Q.Work Shadowing A.Following and observing persons as they fo through their bend routine 13.Q.An attribute or crew of attributes that could be used as the primary pick up for an entity is a A.A. nominee nominate 14.Q.Composite key A.A key that consists of more than one attribute 15.Q.Which of the following statements is an usefulness of a indwelling key? A.A. a natural key helps protect data integrity by preventing unintended immersion of duplicate rows. 16.Q.A natural key is an attribute that naturally belongs...If you ask to get a serious essay, coiffe it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper