ISDS 402 Final Exam Questions with Answers

1




ISDS 402 Final Exam Questions with Answers
1. Imagine we have a number of controls in place in the database to keep from having two people being issued

the same seat for the same event. Fortunately, our database controls are in place and working. How might we

describe the state of the database?



a. Invalid state

b. Imaginary state


c. Valid state

d. Uncomfortable state: Valid state


2. Referential integrity is a constraint that involves how many tables?




a. Three tables

b. Two tables


c. Zero tables

d. Five tables: Two tables


3. What do you call a key that is unique and non-null, but for which there can only be one on a table?


a. Searchable key

b. Surrogate key

, 2






, 3

c. Candidate key


d. Primary key: Primary key


4. What language are we using to communicate with the Oracle Database in this class?



a. Python

b. C++


c. Basic

d. SQL*Plus: SQL*Plus


5. Who is usually responsible for authorizing access to the database, including basic user administration?

Select one:

a. Database Designers




b. Application Programmers


c. End Users

d. Database Administrators: Database Administrators


6. What do we call a particular kind of data item, defined by the values it can take? Each column in a

database will have one of these?

a. Data type

b. String

, 4