Midterm

Which type of databases are not optimized for a single application?

Which term is not typically associated with relational databases?

Which of the following is most likely meta data?

The structure of a database is described by its:

Characteristics of data warehouses include all of the following EXCEPT:

The term "key" will be mostly commonly used in database with respect to discussing "key-value pairs".

We will talk about "traversal" most commonly with regards to what type of database operation?

Physical databases are common created during which part of the "waterfall" development process?

Is data modeling and database design usually an iterative or linear software process?

Conceptual modeling focuses on:

Logical modeling focuses on:

Usually, databases are constructed before the detailed design and coding of database application because:

Which database model is the most popular with respect DBMSs used today?

The relational database model has which of the following characteristics:

XML can best be considered which database model?

Relational database engines provide best performance for all traversal profiles.

Which of the following is not a semi-structured data engine approach?

Which of the following most likely be considered "databases"?

All database management systems are based on the relational model

The most popular database management systems are based on the relational model.

All records in a database must have values for each and every attribute.

Names are the best choice to use for unique identifiers.

The characteristics of the ideal unique identifier include all of the following except:

Artificial keys are most commonly not compound keys

The most commonly used keys in database designs are:

Which statement best describes "smart keys":

Modern DBMS commonly support triggers and/or allow the cascading of changes made to unique identifiers over time.

The key difference between conceptual data modeling and logical data modeling is:

All logical data models are based on relational database model structures.

What holds (implements) the relationship that exists between instances of related entities in the a relational logical data model?

For relational logical data models, which of the following statement best describes the use of foreign keys:

The cardinality of inheritance relationships is:

A "one-to-many" relationship between two entities (such as X and Y, respectively) means:

One-to-one "HAS A" relationships are uncommon in relational logical data models.

Many-to-many relationships are common in relational logical data models.

You can choose assess a data model conforms to 3rd Normal Form only-- in other words, without consideration of whether or not it complies with other Normal Forms).

A logical data model that has been changed to break one of the rules associated with normalization is called:

Commonly, logical data models are modified until they comply with which normal form:

Which Normal Form is associated with evaluating partial key dependencies:

Which Normal Form is associated with evaluating transitive key dependencies:

Which Normal Form is associated with eliminating repeating data groups:

Each and every entity must have a primary key associated with it to assess Normal Forms.

Each predicate in an Object Role Model represents what with respect to logical data models and normalization:

Which of the following statement(s) best describes why primary keys of entities are important in normalization?

Microsoft SQL Server uses a "slot array" as part of its row storage structure. The "slot array" is used for:

Oracle internally stores numbers in which of the following formats:

Based on overhead, what is estimated maximum number of rows that can be stored on one Microsoft Sql Server 8K database page?

Which DBMS(s) incur no overhead for "trailing NULLs"? (Columns in table definition occur in a declared order such as ID, Last Name, First Name, Middle Name, Phone, Fax, Address. Lets assume that all columns except ID are declared as NULL. Then "trailing NULLs" might be a case where a row had NULL for Phone, Fax, and Address. If Fax or Address was not a NULL value, then there would not be trailing NULLs no matter what other columns had NULL values for a given row.)

For MySql databases (using InnoDB data engine), how many bytes are required per field pointer in a row header?

Which DBMS reserve space for fixed-length columns regardless of whether of not they are NULL?