Relational Model Concepts Notes Questions with Answers PDF – Download Test 99

MCQ 491: The tuples in relation are sensitive to:

1. order
2. format
3. entity type
4. concept type

MCQ 492: In client ⁄ server architecture, the machine that have capability of providing user interface and local processing is called:

1. module
2. client
3. server
4. host

MCQ 493: Consider two tuples B and C, the operation whose result includes tuples that are included in both relations or either in B or C is classified as:

1. square of relation B and C
2. union of relation B and C
3. intersection of relation B and C
4. difference of relation B and C

MCQ 494: Considering the change in schema statement in SQL, the command which is used to delete records of table and leave the definition of table for later use is classified as:

1. DELETE command
2. DROP TABLE command
3. PRIMARY KEY command
4. SECONDARY KEY command

MCQ 495: In relational operations, the SELECT operation is written as:

1. &Sigma < selection condition > ( S )
2. &sigma < selection condition > ( R )
3. &omega < selection condition > ( R )
4. Ω < selection condition > ( R )