final exam

Question 1

the benefit of linux is

Answer 1

it’s cheap

Question 2

a subclass ____ attributes from the superclass

Answer 2

inherits

Question 3

a stack is

Answer 3

LIFO

Question 4

In MIS we have to remember that we are always trying to meet the users _____

Answer 4

needs

Question 5

a good side to redundancy is that it can lead to better ____

Answer 5

• results

- response time

Question 6

a relationship that has attributes can become a(n) _____ entity

Answer 6

associative

Question 7

when converting a many-to-many relationship, how many relations will be created

Answer 7

3

Question 8

partial specialization (incomplete) implies

Answer 8

an instance of the superclass may not belong to a subclass

Question 9

the overlap constraint states that

Answer 9

an instance of the superclass may belong to multiple subclasses

Question 10

MySQL is a(n)

Answer 10

relational DBSM

Question 11

the idea of a DBMS separating the data from the application is

Answer 11

data independence

Question 12

the concept that a foreign key in one table must have a matching primary key in the connected table is

Answer 12

referential integrity

Question 13

SQL stands for

Answer 13

structured query language

Question 14

data dependence can lead to

Answer 14

data redundancy

Question 15

the number or instances of entity A that may be associated with entity B is the

Answer 15

maximum cardinality

Question 16

data about the data in the database are stored in the

Answer 16

data dictionary

Question 17

the goal of database design is to eliminate

Answer 17

redundancy

Question 18

which of the following is used to ensure data integrity

Answer 18

• default values
• range controls
• referential integrity
• null value controls

Question 19

which of the following is true about Linux

Answer 19

• it is a version of unix
• it was developed by linus torvalds
• it is essentially free

Question 20

which statement is more correct?

Answer 20

SQL is embedded in PHP which is embedded in html

Question 21

the purpose of normalization is to

Answer 21

reduce inconsistency

Question 22

the number of instances of entity A that must be associated with entity B is the

Answer 22

minimum cardinality

Question 23

the storage of records in order on a tape or disk by primary key is an example of

Answer 23

sequential file organization

Question 24

which of the following is used to ensure data integrity

Answer 24

• default values
• range controls
• referential integrity
• null value controls

Question 25

denormalization is often used to

Answer 25

decrease response time

Question 26

the layer of coding logic that processes the data for the user in a client server architecture is

Answer 26

the application logic layer

Question 27

partial specialization (incomplete) implies

Answer 27

an instance of the superclass may not belong to a subclass

Question 28

the disjoint constraint states that

Answer 28

an instance of the superclass may only belong to one subclass

Question 29

a client that can handle major database and application processing and has a powerful CPU is probably a(n)

Answer 29

fat client

Question 30

Linux was developed by

Answer 30

Linus Torvalds

Question 31

a client server architecture with a server for the DBMS and a separate server for the applications is

Answer 31

3 tierd

Question 32

unix is

Answer 32

open source

Question 33

in MIS we have to remember that we are always trying the meet the users

Answer 33

needs?