Blog

You are developing a learning management system (LMS) for a local community college. Categorize the following requirements into ‘functional’ or ‘non-functional”.

A complete schedule always has the property that committed transactions are never rolled back 

As the project manager for developing a custom learning management system for a local community college, categorize the following activities into the most appropriate phase of the software development life cycle (SDLC). If an activity could belong to more than one phase, select the most predominant one.

Principle of Least Privilege (POLP) (choose best)

What is the best choice for an index for the following query: select name, age from employee where age > 21 and age < 65;

A strict schedule is often non-recoverable

Given R(A, B, C) with state: A B C a f m a g m b h m b i n c j n c k n The functional dependency B → A holds for the database state shown. (true or false)

A relation R(A, B), where A is a prime attribute and B is a non-prime attribute, meets 2NF criteria

With respect to JDBC (pick true statement):     

Desirable properties of relational normalization include