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 going surrounded by DBMS and RDBMS? A.In dbms, relation is between both 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 info in more than iodine place in a selective informationbase. Could lead to faulting or repulsion 5.Q.Primary and Foreign keys A.Primary is a unique ID. Foreign is a infant pk from parent table. 6.Q.What is SQL? A. merged query language used in relational db to create objects and modify and retrieve data 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 coiffure entities. ERD common method of enactment entities and relation s in a diagram. 8.Q.Which of the next best defines the margin database requirement A.C. Something a database must 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. physical composition 11.Q.The focus of a database, the business problem it is designed to reform is called A.B. the domain of the database 12.Q.Work Shadowing A.Following and observing persons as they fo through their work routine 13.Q.An designate or combination of puts t hat could be used as the primary key for an ! entity is a A.A. nominee 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, exercise it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay