questions i got wrong

Question 1

w2: sdlc DETAILED CONCEPTUAL MODEL

Answer 1

ANALYSIS

Question 2

w2:sdlc data DEFINED categoruuy LISTED …

Answer 2

ANALYSIS

Question 3

w2: consensus on dataa def

Answer 3

org conflict

Question 4

w2: primary puruses of dbms EXCPET

Answer 4

int dev env

Question 5

good data def will describe all characeritsts EXCEPT

Answer 5

DELETE THE DATA

Question 6

entity type name should be everything except

Answer 6

AS SHORT AS POSSIBLE

Question 7

a___ def or constarints business aspect

Answer 7

BUSIENESS RULE

Question 8

the __ no PK MAY BE NULL

Answer 8

tntity integrity

Question 9

func dependnacy 2 oor more non key

Answer 9

TRANSITIVE DEPENDANCY

Question 10

entity integrity is a rule that

Answer 10

no NULL

Question 11

Domain def consists of all excet

Answer 11

INTEGRITY CONSTRAINTS

Question 12

WHICH of follow clauses finds all groups meeting stated condiitons

Answer 12

HAVING

Question 13

A view may not be directly updated if it contains

Answer 13

HAVING

Question 14

last part of sql query to be read

Answer 14

ORDER BY

Question 15

single val return form sql

Answer 15

scalar agg

SCALAR = SINGLE

Question 16

multi value return

Answer 16

vector agg

Question 17

to get all cust from hawaii sorted together?

Answer 17

ORDER BY

Question 18

Which of the following counts only row that contain vlaue

Answer 18

COUNT

Question 19

all multival removed: 1ST

no multival attributed + nonkey dep on pk: 2ND

normal form removes remaiing func de: BOYCODD

Question 20

WHAT PRODUCES SCALAR AND VECTOR AGG

Answer 20

GROUP BY

Question 21

What does the following SQL statement do?

DELETE FROM Customer_T
WHERE state = ‘HI’;

Answer 21

Deletes all records from Customer_t where the state is equal to HI

Question 22

SELECT MIN(Product_Description)
FROM Product_V;

Answer 22

FIRST VALAUE OF PRODUCT DECSIRPTION WILL BE SHOWN

Question 23

INSERT INTO is an example of ________ code.

Answer 23

DML

Question 24

__ set of commands to CONTROL db
__ set of commands to UPDATE and Query a db

Answer 24

DCL
DML

Question 25

__ NO primary key may be null

Answer 25

ENTITY INTEGRITY RULE

Question 26

Domain def consists of all components EXCEPT

Answer 26

integrity constraintis!!

Question 27

student and room!!

Answer 27

one to many

Question 28

!!! if it says SDLC IN THE QUESTION:

-> if it doesnt say SDLC! only says logical schema

Answer 28

ITS ANALYSIS

ITS DESIGN

Question 29

all mv: 1st
no mv attributres: 2nd
Mv depend: 4th
remaining func dep: boyecodd

ANM: 1ST 2ND 4TH (ANNEMARIE)
remaining: boycecodd