MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Technology knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which SQL keyword is used to sort the result-set? |
| A. | ORDER |
| B. | ORDER BY |
| C. | SORT BY |
| D. | SORT |
| Answer» C. SORT BY | |
| 2. |
Which operator performs pattern matching ? |
| A. | LIKE operator |
| B. | EXISTS operator |
| C. | BETWEEN operator |
| D. | None of these |
| Answer» B. EXISTS operator | |
| 3. |
Which of the following is a comparison operator in SQL? |
| A. | |
| B. | <> |
| C. | ` |
| D. | / |
| Answer» B. <> | |
| 4. |
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables ? |
| A. | Data Manipulation Language(DML) |
| B. | Data Definition Language(DDL) |
| C. | Both A & B |
| D. | None |
| Answer» C. Both A & B | |
| 5. |
What operator tests column for the absence of data? |
| A. | NOT operator |
| B. | IS NULL operator |
| C. | EXISTS operator |
| D. | All of the above |
| Answer» C. EXISTS operator | |
| 6. |
The SQL SELECT statement is capable of |
| A. | Projection |
| B. | Selection |
| C. | Protection & Security |
| D. | Both A & B |
| Answer» E. | |
| 7. |
We can modify an existing Company from |
| A. | Company Info > Alter |
| B. | Gateway of Tally > Modify Company |
| C. | Company Info > Alter Company |
| D. | All of the above |
| Answer» B. Gateway of Tally > Modify Company | |
| 8. |
The arranging of data in a logical sequence is called |
| A. | Summarizing |
| B. | Classifying |
| C. | Sorting |
| D. | Rearranging |
| Answer» D. Rearranging | |
| 9. |
SQL views can be used to hide? |
| A. | Complicated SQL syntax |
| B. | Rows |
| C. | Columns |
| D. | All of the above |
| Answer» E. | |
| 10. |
AND, OR and NOT are examples of |
| A. | Clauses |
| B. | Boolean operators |
| C. | Conjuctive operators |
| D. | Exclusive operators |
| Answer» C. Conjuctive operators | |
| 11. |
A subquery in an SQL SELECT statement is enclosed in |
| A. | [ ] |
| B. | { } |
| C. | < > |
| D. | ( ) |
| Answer» E. | |
| 12. |
A DBMS query language is designed to |
| A. | Specify the structure of a database |
| B. | Support in the development of complex applications software |
| C. | Support end users who use English-like commands |
| D. | All of the above |
| Answer» E. | |
| 13. |
A database is used to |
| A. | store data |
| B. | modify data |
| C. | extract data |
| D. | All of the above |
| Answer» E. | |