ISYS6123003 - Post Test

The requirement that each entity much have a unique primary key where the value of that primary key is not null, is known as the....

• Entity Integrity Rule

• Entity-Relationship Rule

• Referential Integrity Rule

• Validation Index

•  

  The frequency of a relationship between entities may be described by....

• Indexed fields

• Referential integrity

• Transitive dependencies

• Cardinality

Majority of relational database system employ which language....

• SQL

• C#

• Java

• All of the above

Which of the following makes it possible for entities to share a relationship?

• The same number of attributes

• A common attribute

• A foreign key

• Multi-valued attributes

The following are date functions, except....

• DATEDIFF

• YEAR

• DATESUM

• DAY

Functions that returns the starting position of a character string is called....

• SUBSTRING

• REPLACE

• CHARINDEX

• STUFF

Functions that deletes a specified length of characters and inserts string at a specified starting index is called....

• CHARINDEX

• STUFF

• SUBSTRING

• CAST & CONVERT

The ISO standard defines five aggregate functions namely....

• COUNT, SUM, MAX, LOWER, AVG

• COUNT, SUM, UPPER, MIN, AVG

• COUNT, MIN, AVG, LOWER, MAX

• COUNT, AVG, SUM, MAX, MIN

COUNT, MIN, and MAX only apply to numeric fields.

• TRUE

• FALSE

DISTINCT has no effect with MIN/MAX, but may have with SUM/AVG.

• TRUE

• FALSE