Relational Databases Multiple Choice Questions with Answers PDF – Test 312

MCQ 1556: Most commercial relational database systems employ the language:

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

MCQ 1557: 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 1558: Magnetic tapes were developed for data storage over the period:

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

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

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

MCQ 1560: 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;