Relational Databases Practice Test PDF Download eBook p. 312

MCQ: Most commercial relational database systems employ the language

1. C++
2. Java
3. SQL
4. DB2

MCQ: The first subquery of the recursive view that is non-recursive is called as the

1. Absolute query
2. Base query
3. Nonrecurring query
4. General query

MCQ: Magnetic tapes were developed for data storage over the period

1. 1940s-1950s
2. 1950s-1960s
3. 1960s-1965s
4. 1960s-1970s

MCQ: In a selection statement, the predicate appears as a subscript to

1. epsilon
2. zeta
3. sigma
4. delta

MCQ: The command that all instructors with salary over $100,000 receive a 3 percent raise, would be written as

1. update instructor
   set salary=salary * 1.03
   where salary > 100000;
2. update instructor
   set salary=salary * 1.03
   where salary <>=100000;
3. update in instructor
   set salary=salary * 1.03
   where salary >=100000;
4. update into instructor
   set salary=salary * 1.03
   where salary >=100000;