MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 18 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
While operating with strings, what does “_ _ _%” match with? |
| A. | A string of three letters |
| B. | A string of at least three letters |
| C. | A string of three words |
| D. | A string of at least three words |
| Answer» B. A string of at least three letters | |
| 2. |
Observe the following query and choose the correct option.select name, IDfrom student natural join department natural join section |
| A. | The query is syntactically wrong because there is no where clause |
| B. | The query is syntactically wrong because there are more than one attributes in the select clause |
| C. | The query is syntactically wrong because more than one relations are included in the natural join operation |
| D. | The query is correct |
| Answer» E. | |
| 3. |
What does the natural join operation do? |
| A. | It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations |
| B. | It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations |
| C. | It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations |
| D. | None of the mentioned |
| Answer» B. It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations | |
| 4. |
State true or false: Multiple conditions in the where clause are separated by a “,” |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be? |
| A. | The natural join of both the relations |
| B. | The left outer join of both the relations |
| C. | A syntactical error |
| D. | The Cartesian product of both the relations |
| Answer» E. | |
| 6. |
The ________ clause is used to list the attributes desired in the result of a query |
| A. | select |
| B. | from |
| C. | where |
| D. | create |
| Answer» B. from | |
| 7. |
What does the following query do?select name, ID, branchfrom student, departmentwhere student.branch = department.branch; |
| A. | It gives all values of name, ID, branch from both the relations only if all those attributes are present in both |
| B. | It gives all values of name, ID, branch from their respective relations |
| C. | It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same |
| D. | It gives the values of name, ID, branch from their respective relations where all the values are matching with each other |
| Answer» D. It gives the values of name, ID, branch from their respective relations where all the values are matching with each other | |
| 8. |
select distinct dept_namefrom institute; What does the above query do? |
| A. | It gives all the tuples having a distinct dept_name |
| B. | It gives the dept_name attribute values of all tuples without repetition |
| C. | It gives all the dept_name attribute of all the tuples |
| D. | It gives all the tuples having a null value under the dept_name attributeView Answer |
| Answer» C. It gives all the dept_name attribute of all the tuples | |
| 9. |
STATE_TRUE_OR_FALSE:_MULTIPLE_CONDITIONS_IN_THE_WHERE_CLAUSE_ARE_SEPARATED_BY_A_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ‚À´,‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖŒÄ?$# |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
IF_WE_SPECIFY_MULTIPLE_RELATIONS_IN_THE_FROM_CLAUSE_AND_DO_NOT_SPECIFY_ANY_CONDITIONS_IN_THE_WHERE_CLAUSE,_WHAT_WILL_THE_RESULT_BE??$ |
| A. | The natural join of both the relations |
| B. | The left outer join of both the relations |
| C. | A syntactical error |
| D. | The Cartesian product of both the relations |
| Answer» C. A syntactical error | |
| 11. |
Observe the following query and choose the correct option.$ |
| A. | |
| B. | |
| Answer» C. | |
| 12. |
What does the natural join operation do?$ |
| A. | It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations |
| B. | It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations |
| C. | It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations |
| D. | None of the mentioned |
| Answer» E. | |
| 13. |
Which keyword is used to rename a relation in a query? |
| A. | rename |
| B. | as |
| C. | is |
| D. | to |
| Answer» B. as | |
| 14. |
The ________ clause is used to list the attributes desired in the result of a quer? |
| A. | select |
| B. | from |
| C. | where |
| D. | create |
| Answer» E. | |
| 15. |
The where clause is a predicate involving attributes of the relation in the ______ clause. |
| A. | select |
| B. | from |
| C. | with |
| D. | none of the mentioned |
| Answer» C. with | |
| 16. |
Which of the following logical connectives is not included in SQL? |
| A. | and |
| B. | or |
| C. | nor |
| D. | not |
| Answer» E. | |
| 17. |
Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed? |
| A. | all |
| B. | not unique |
| C. | notnull |
| D. | include |
| Answer» B. not unique | |
| 18. |
Which of the following syntax of the basic query is correct? |
| A. | select <relation> from <attribute> |
| B. | select <attribute> from <elation> |
| C. | select <tuple> from <relation> |
| D. | select <tuple> from <attribute> |
| Answer» C. select <tuple> from <relation> | |