Oracle Databases

@T-Bone

This question paper focuses on the "Oracle" of Databases. These Multiple Choice Questions (mcq) should be practiced to improve the Databases skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

This question paper focuses on the "Oracle" of Databases. These Multiple Choice Questions (mcq) should be practiced to improve the Databases skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

Questions

1. Oracle database is a ?

Mark the correct option

2. How many editions of the Oracle database there?

Mark the correct option

3. A __________ is a single field or combination of fields that contains a unique record.

Mark the correct option

4. Which statement is used to create a table from an existing table by copying the columns of existing table?

Mark the correct option

5. A ________ is created by a query joining one or more tables.

Mark the correct option

6. Which query is used to add, modify, delete or drop colums of a table?

Mark the correct option

7. Which clause is used to remove the duplicate records from the result set?

Mark the correct option

8. How many CREATE TRIGGER statements are there?

Mark the correct option

9. view is a virtual table that does not physically exist.

Mark the correct option

10. Which is the smallest unit of storage in an Oracle database?

Mark the correct option

11. Oracle database produced and marketed by?

Mark the correct option

12. Oracle DB runs on the ?

Mark the correct option

13. In Oracle, total number of columns cannot be more than?

Mark the correct option

14. Which tables are defined and scoped to the session in which you created it?

Mark the correct option

15. Which command is used to fetch records from database?

Mark the correct option

16. Which of the following is done to give a temporary to a column or table?

Mark the correct option

17. A ________ is a group of PL/SQL statements that can be called by name.

Mark the correct option

18. TRUNCATE TABLE statement is used to remove the table.

Mark the correct option

19. Which processes is an instance made of Oracle?

Mark the correct option

20. The language used application programs to request data from the DBMS is referred to as __________

Mark the correct option

Index of Questions