MIS 375: Questions from the Final

· “An attribute that is a primary key in another table” describes

· “If you can’t measure it, you can’t manage it”

· A bit map index saves space and time

· A blank value in a field of a database table means

· A Natural Join is

· A table Projection chooses one or more particular rows.

· A tuple is another name for ...

· A View …

· According to the text, when do you label arcs in a data model?

· Adding useful information in a row of a table but lacking a value for the primary key is an example of the

· All columns are single-valued

· All non-key columns depend on the key

· An Index …

· Build a prototype so the client can experiment

· Cardinality and degree are defined as:

· Deleting all the rows of a table also deletes the table.

· EDI is slowly replacing XML

· Giving employees greater freedom to make decisions best defines

· Handling a query for a recursive relationship is puzzling until you realize …

· Having a PK for every FK is the …

· How do you handle exceptions when data modeling?

· How does DK Normal Form differ from other normal forms?

· How does your data model fit with the corporate data model?

· In database modeling, an Entity:

· In the operation of a database, disks are a bottleneck

· Joining two SQL queries to answer an "Either/Or" question is best done using

· Just say no!

· No transitive dependencies

· SELECT * FROM R WHERE R.X > 0;

· SELECT * FROM R, S;

· SELECT X FROM R;

· The richest form of information comes from …

· The term SQL stands for …

· The use of statistical analysis and artificial intelligence to identify hidden relationships in data BEST describes

· To answer an "is there any?" question is best done using

· Typically, organizations expend more training on developing advanced skills (know how) than on system understanding (know why)

· Unlike HTML, XML is concerned with meaning, not just presentation.

· Using meaningful identifiers/keys most directly violates which normal form?

· What does XML stand for?

· What is a useful technique for identifying entities in a written description of a data modeling problem?

· What is a weak entity?

· What is an independent entity?

· What is data modeling?

· What is normalization?

· What is the difference between a primary key and an alternate key?

· What is the goal of normalization?

· What is the relationship between XML and SGML?

· When does a data model have high-fidelity?

· When Information Satisficing, a manager ...

· When is a data model well-formed?

· When two tables are joined together using keys with identical values it is a/an …

· Which of the following are required for any relational database?

· Which of the following best defines a recursive relationship?

· Which of the following describe the bill-of-materials relationship?

· Which of the following file extensions is for XML schema?

· Which of the following in NOT and advantage of PHP?

· Which of the following in NOT true about clustering?

· Which of the following is a built-in, aggregate function in SQL?

· Which of the following is a synonym for “dependent entity”?

· Which of the following is NOT a description of managerial work?

· Which of the following is NOT a one of the primitive relational operations?

· Which of the following most directly aids in DB security?

· Which of the following NOT true about Hashing?

· Which of the following organization models best fits a thesaurus?

· Which of the following SQL fragments demonstrates the creation of a table alias?

· Who is credited with the concept of the Relational DBMS?

· Why do we need the entity integrity rule?

· Why is a domain useful?