Oracle Questions and Answers
11. Oracle database produced and marketed by?
A. IBM
B. Google
C. Oracle Corporation
D. Facebook
View Answer
Ans : C
Explanation: It is produced and marketed by Oracle Corporation.
12. Oracle DB runs on the ?
A. Windows
B. Linux
C. Unix
D. All of the above
View Answer
Ans : D
Explanation: Oracle DB runs on the most major platforms like Windows, UNIX, Linux and Mac OS.
13. In Oracle, total number of columns cannot be more than?
A. 16
B. 32
C. 64
D. 128
View Answer
Ans : B
Explanation: In Oracle, total number of columns cannot be more than 32.
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
Ans : D
Explanation: local temporary tables are distinct within modules. These tables are defined and scoped to the session in which you created it.
15. Which command is used to fetch records from database?
A. Fetch
B. Select
C. Use
D. Get
View Answer
Ans : B
Explanation: Oracle select query is used to fetch records from database. For example:
SELECT * from customers;
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
Ans : D
Explanation: In Oracle, aliasing can also be done in column name as well as in table name. Aliasing is done to give a temporary to a column or table.
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
Ans : C
Explanation: A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method or a third-generation language routine so that it can be called from SQL and PL/SQL.
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
Ans : B
Explanation: True, TRUNCATE TABLE statement is used to remove all records from a table.
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
Ans : D
Explanation: Oracle background processes is an instance made of Oracle.
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
Ans : A
Explanation: Data Manipulation Language (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to database, it can be rolled back.
Discussion