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 leaving surrounded by DBMS and RDBMS? A.In dbms, relation is between cardinal 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 whizz place in a selective informationbase. Could lead to faulting or discrepancy 5.Q.Primary and Foreign keys A.Primary is a unique ID. Foreign is a claw pk from parent table. 6.Q.What is SQL? A. merged query language used in relational db to create objects and modify and retrieve entropy 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 posit entities. ERD common method of enactment entities and relations in a diagram. 8.Q.Which of the next best defines the margin database requirement A.C. Something a database mustiness 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. state 11.Q.The focus of a database, the business problem it is designed to exonerate is called A.B. the domain of the database 12.Q.Work Shadowing A.Following and observing persons as they fo by dint of their work routine 13.Q.An ascribe or combination of ascribes that could be used as the primary key fo r an entity is a A.A. prospect 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, execute it on our website: OrderEssay.net

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