MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which is the smallest unit of storage in an Oracle database? |
| A. | Segment |
| B. | Data Block |
| C. | Extent |
| D. | Data File |
| E. | |
| Answer» C. Extent | |
| 2. |
view is a virtual table that does not physically exist. |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 3. |
How many CREATE TRIGGER statements are there? |
| A. | 4 |
| B. | 5 |
| C. | 6 |
| D. | 7 |
| Answer» D. 7 | |
| 4. |
Which clause is used to remove the duplicate records from the result set? |
| A. | Where |
| B. | Group by |
| C. | Like |
| D. | Distinct |
| Answer» E. | |
| 5. |
Which query is used to add, modify, delete or drop colums of a table? |
| A. | Update |
| B. | Alter |
| C. | Truncate |
| D. | Drop |
| Answer» C. Truncate | |
| 6. |
A ________ is created by a query joining one or more tables. |
| A. | Trigger |
| B. | Procedure |
| C. | Both A and B |
| D. | View |
| Answer» E. | |
| 7. |
A __________ is a single field or combination of fields that contains a unique record. |
| A. | Compound Key |
| B. | Primary key |
| C. | Foreign Key |
| D. | Index |
| Answer» C. Foreign Key | |
| 8. |
How many editions of the Oracle database there? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» D. 5 | |
| 9. |
Oracle database is a ? |
| A. | Centralised database |
| B. | End-user database |
| C. | Commercial database |
| D. | Relational database |
| Answer» E. | |