Modification of Database MCQ (Multiple Choice Questions) PDF - 218

MCQ 1086: Instead of specifying a set of tuples, we can also use the

1. Select
2. Group by
3. Having
4. Like

MCQ 1087: For updates, the trigger can specify attributes whose update causes the trigger to

1. Initiated
2. Evaluate
3. Execute
4. Prioritize

MCQ 1088: The security and authorization information for each relation, is overlooked by

1. SQL DDL
2. SQL DML
3. Authorization control
4. View definition

MCQ 1089: A query can usually be translated into any of a number of evaluation plan, that all give

1. Same results
2. Different results
3. Dependent results
4. Interchanging results

MCQ 1090: It is customary to list the primary key attributes of a

1. Relation schema
2. Relation instance
3. Relation tuple
4. Relation attribute