SQL Data Definition and Types Notes Questions with Answers PDF Download – Test 55

MCQ 271: In SQL, the identifier which are used to indicate the user of schema is classified as:

1. high level identifiers
2. low level identifiers
3. authorization identifier
4. query identifier

MCQ 272: In the reflexive rule (IR1), the true dependencies generated are classified as:

1. trivial
2. nontrivial
3. inferential
4. functional

MCQ 273: When two different schemas used a same name to describe schemas then this is called:

1. antonym
2. synonym
3. homonym
4. none of above

MCQ 274: In database management system, the executing process or executing program which considers the updating or reading of records stored in database is called:

1. conceptualization
2. execution
3. implementation
4. transaction

MCQ 275: The control feature in database management system which ensures the accuracy of data updated by multiple users is classified as:

1. conceptual implementation control
2. concurrency control
3. interface modeling control
4. user accessibility control