Relational Databases Multiple Choice Questions (MCQs) PDF Download - 312

Most commercial relational database systems employ the language

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

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

Magnetic tapes were developed for data storage over the period

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

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

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

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;