Relational Model Concepts Quiz PDF: Questions and Answers - 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 )