final exam Flashcards

1
Q

the benefit of linux is

A

it’s cheap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

a subclass ____ attributes from the superclass

A

inherits

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

a stack is

A

LIFO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

needs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A
  • results

- response time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

associative

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

partial specialization (incomplete) implies

A

an instance of the superclass may not belong to a subclass

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

the overlap constraint states that

A

an instance of the superclass may belong to multiple subclasses

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

MySQL is a(n)

A

relational DBSM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

data independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

referential integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

SQL stands for

A

structured query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

data dependence can lead to

A

data redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

maximum cardinality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

data about the data in the database are stored in the

A

data dictionary

17
Q

the goal of database design is to eliminate

A

redundancy

18
Q

which of the following is used to ensure data integrity

A
  • default values
  • range controls
  • referential integrity
  • null value controls
19
Q

which of the following is true about Linux

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

which statement is more correct?

A

SQL is embedded in PHP which is embedded in html

21
Q

the purpose of normalization is to

A

reduce inconsistency

22
Q

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

A

minimum cardinality

23
Q

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

A

sequential file organization

24
Q

which of the following is used to ensure data integrity

A
  • default values
  • range controls
  • referential integrity
  • null value controls
25
Q

denormalization is often used to

A

decrease response time

26
Q

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

A

the application logic layer

27
Q

partial specialization (incomplete) implies

A

an instance of the superclass may not belong to a subclass

28
Q

the disjoint constraint states that

A

an instance of the superclass may only belong to one subclass

29
Q

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

A

fat client

30
Q

Linux was developed by

A

Linus Torvalds

31
Q

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

32
Q

unix is

A

open source

33
Q

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