Data Base Study Guide

1.Q.What is a infobase? A.A collection of related to selective information. Oracle, SQL Server, DB2, MySQL, PostGres SQL, ACCESS 2.Q.What is the difference border by DBMS and RDBMS? A.In dbms, resemblance is betwixt 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 value organized in columns and rows. table = entity 4.Q.Data redundancy A.Storing info in more than one position in a infobase. Could fill to faulting or inconsistency 5.Q.Primary and contrary names A.Primary is a unique ID. unlike is a child pk from evoke table. 6.Q.What is SQL? A. merged query talking to used in comparative db to create objects and veer and retrieve data 7.Q.Entity, holding, ER diagram A.Something that the db is concerned with, astir(predicate) which data bear be stored, and which can have relationships with separate entities. Attributes define entities. ERD common rule of enactment entities and relations in a diagram. 8.Q.Which of the next scoop up defines the margin database requirement A.C. Something a database must do to follow out its affair function 9.Q.Which of these best defines data ace? A.A. The accuracy and appropriateness if the data in the database 10.Q.

A immersion that has the primary purpose of summarizing and displaying data is called a A.D. report 11.Q.The focus of a database, the trade problem it is designed to edify is called A.B. the domain of the database 12.Q.Work Shadowing A.Following and observing persons as they fo through their choke routine 13.Q.An attribute or combine of attributes that could be used as the primary let on for an entity is a A.A. nominee let out 14.Q.Composite key A.A key that consists of more than one attribute 15.Q.Which of the following statements is an avail 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 expect to get a unspoiled essay, coiffe it on our website: Ordercustompaper.com

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