Relational Operations MCQ (Multiple Choice Questions) PDF - 98

MCQ 486: The type of JOIN operation through which one can keep all tuples in relations without considering corresponding tuples in any other relation is classified as

1. stem join
2. leaf join
3. outer join
4. inner join

MCQ 487: In the statement DECIMAL () to specify numeric data type, the number of decimal digits is called

1. the string
2. the numeric strip
3. the precision
4. the scale

MCQ 488: The files in which the updates are performed rarely are classified as

3. dynamic files
4. static files

MCQ 489: The process in which tuple is created by having combined attributes from two relations is classified as

1. Cartesian compatibility
2. Cartesian multiples
3. Cartesian product
4. Cartesian ordinate

MCQ 490: The type of relational database which incorporate the concepts of object database is classified as

1. functional object system
2. behavioral relational system
3. extended relational system
4. extended objects system