Relational Model Concepts Notes Questions with Answers PDF Download - 99

The tuples in relation are sensitive to

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

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

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

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

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 )