Oracle Questions and Answers

11. Oracle database produced and marketed by?

A. IBM
B. Google
C. Oracle Corporation
D. Facebook

View Answer


12. Oracle DB runs on the ?

A. Windows
B. Linux
C. Unix
D. All of the above

View Answer


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

A. 16
B. 32
C. 64
D. 128

View Answer


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

A. Global Temporary tables
B. Global Permanent tables
C. Local Permanent tables
D. Local Temporary tables

View Answer


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

A. Fetch
B. Select
C. Use
D. Get

View Answer


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

A. Union
B. Intersect
C. Having
D. Aliases

View Answer


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

A. View
B. Trigger
C. Procedure
D. Function

View Answer


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

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


19. Which processes is an instance made of Oracle?

A. Memory processes
B. Oracle background processes
C. Data processes
D. All of the above

View Answer


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

A. DDL
B. DML
C. TCL
D. TDL

View Answer





Discussion


* You must be logged in to add comment.