DAT 380 Wk 5 Final Examination | eBooks | Education

DAT 380 Wk 5 Final Examination

DAT 380 Wk 5 Final Examination PLDZ-13220 Free
In Stock
$ 0.00 USD
Free Download! Description

***************************************************************

Click Here To Download Your Files :  

https://uopcourse.com/category/dat-380/

  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can buy more tutorials from the below link

https://uopcourse.com/

***************************************************************

DAT 380 Wk 5 Final Examination

1.One-to-one relationships are the most common in a relational database.________

A) True__

B) False   one-to-many

2.In a one-to-many relationship the foreign key goes in________

  1. __

3.The most common type of database in use today is the ___________.________

  1. __

4.In an Entity Relationship Diagram (ERD) a relationship connects what two things?________

  1. __

5.___________ describe the entities, attributes,  relationships and actions that a ________

business finds important. These should be documented by the database developer.__

6.A poorly structured relation often has data concerning more than one topic________

T) True__

F) False

Questions may be continued on backside. Please see over.

DAT/380 Advanced Database ArchitecturePage 1 of 5

Name______________________Date__________

QuestionAnswer

7.The process of decomposing a poorly structured relation into well-structured ________

relations is called ___________.__

8.The set of values that a column may contain is known as its:________

  1. __

9.A relationship is created between two tables by specifying the primary key field in ________

the first table as a(n): _________ in the second.__

A)  Domain

B)  Index

C)  Foreign key

D)  Business rule

10.The development team builds a data model from the user's statements about:________

A) forms__

B) reports

C) internal structure of the data

D) all of the above

E) a and b above

11.A primary key:________

  1. __

12.Identifiers (Primary Keys) that consist of two or more attributes are called _______________

  1. __

13.To list all the contents of the PRODUCT table, you would use ____.________

A) LIST * FROM PRODUCT;__

B) SELECT * FROM PRODUCT;

C) DISPLAY * FROM PRODUCT;

D) SELECT DATA  FROM PRODUCT;

14.The SQL command that enables you to make changes to existing records is ____.________

  1. INSERT__
  2. COMMIT
  3. SELECT
  4. UPDATE

15.When using a(n) ____ join, only rows that meet the given join criteria in both tables ________

are returned.__

  1. full
  2. inner
  3. outer
  4. set

16.Database developers usually want their database to be in at least which of the ________

following normal forms?__

17.The SQL command that lets you insert data into a table, one row at a time, is ____.

*************************************************************** Click Here To Download Your Files : https://uopcourse.com/category/dat-380/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You can buy more tutorials from the below link http
Recent Reviews Write a Review
0 0 0 0 reviews