Oracle Database Interview Questions - 3

1. POST-BLOCK trigger is also a ?

A. Navigational Trigger

B. Key Trigger

C. Transaction Trigger

D. All of the Mentioned

Correct Answer is : Navigational Trigger

2. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________

A. SYSTEM.LAST_RECORD

B. SYSTEM.CURSOR_RECORD

C. SYSTEM.CURSOR_FIELD

D. SYSTEM.LAST_QUERY

Correct Answer is : SYSTEM.LAST_QUERY

3. In Oracle, which of the following package procedure is UNRESTRICTED ?

A. CALL_INPUT

B. CLEAR_BLOCK

C. EXECUTE_QUERY

D. USER_EXIT

Correct Answer is : USER_EXIT

4. What is SQL * FORMS ?

A. SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application

B. SQL * FORMS is a 3GL tool for connecting to a Database

C. SQL * FORMS is a reporting tool

D. None of the Mentioned

Correct Answer is : SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application

5. Which of the following statement is false ?

A. Any procedure can raise a error and return an user message and error number

B. Error number is ranging from 20000 to 20999 are reserved for user defined messages

C. Oracle checks Uniqueness of User defined errors

D. Raise_Application_error is used for raising an user defined error

Correct Answer is : Oracle checks Uniqueness of User defined errors

6. What is the result of the following ‘PAN’NULL’KAJ’?

A. Error

B. PAN KAJ

C. PANKAJ

D.

Correct Answer is : PANKAJ

7. Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL 20000 A48 ABHYUDAY A83 KRISHNA 30000 Select count(SALARY) from EMP; will result in

A. 1

B. 0

C. 3

D. None of the Mentioned

Correct Answer is : 3

8. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

A. select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;

B. select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;

C. select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;

D. select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

Correct Answer is : select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;

9. Where is data dictionary kept?

A. SYSTEM Tablespace

B. Stack Space

C. Data File

D. None of the Mentioned

Correct Answer is : SYSTEM Tablespace

10. Which schema object instructs Oracle to connect to remotely access an object of a database?

A. Sequence

B. Remote Link

C. Database Link

D. Data Link

Correct Answer is : Data Link

11. Which of the following object types below cannot be replicated?

A. Data

B. Trigger

C. View

D. Sequence

Correct Answer is : Sequence

12. How we can force a log switch?

A. By using ALTER SYSTEM LOG

B. By using ALTER SYSTEM SWITCH LOGFILE

C. By using ALTER SYSTEM SWITCH LOGS

D. By using ALTER SYS LOGFILES

Correct Answer is : By using ALTER SYSTEM SWITCH LOGFILE

13. In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory

A. 0.15-35

B. quantity – 100

C. 35*20

D. 100 / 0.15

Correct Answer is : 100 / 0.15

14. The ORDER BY clause can only be used in ___________

A. SELECT queries

B. INSERT queries

C. GROUP BY queries

D. HAVING queries

Correct Answer is : SELECT queries

15. Which of the following rule below are categories of index?

A. Column and Functional

B. Multiple Column and Functional

C. To create an index in another schema

D. None of the Mentioned

Correct Answer is : Column and Functional

16. What is the purpose of SMON (System Monitor Process) background process?

A. Performs crash recovery when a failed instance starts up again

B. Performs recovery when a user process fails

C. Writes redo log entries to disk

D. All of the Mentioned

Correct Answer is : Performs crash recovery when a failed instance starts up again

17. Recycle bin can be turned on or off this. This parameter is stored in which of the below file?

A. PARAMETER FILE

B. PARFILE

C. DATAFILES

D. PFILE

Correct Answer is : PARAMETER FILE

18. When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called

A. Undone Data

B. Archive Data

C. Redo Data

D. Undo Data

Correct Answer is : Undo Data

19. A collection of data designed to be used by different people is called a/an

A. Organization

B. Database

C. Relationship

D. Schema

Correct Answer is : Database

20. Which of the following is the oldest database model?

A. Relational

B. Deductive

C. Physical

D. Network

Correct Answer is : Network

Oracle Database interview questions part 3

Oracle Database interview questions part 3

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. POST-BLOCK trigger is also a ?

2. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________

3. In Oracle, which of the following package procedure is UNRESTRICTED ?

4. What is SQL * FORMS ?

5. Which of the following statement is false ?

6. What is the result of the following ‘PAN’NULL’KAJ’?

7. Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL 20000 A48 ABHYUDAY A83 KRISHNA 30000 Select count(SALARY) from EMP; will result in

8. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

9. Where is data dictionary kept?

10. Which schema object instructs Oracle to connect to remotely access an object of a database?

11. Which of the following object types below cannot be replicated?

12. How we can force a log switch?

13. In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory

14. The ORDER BY clause can only be used in ___________

15. Which of the following rule below are categories of index?

16. What is the purpose of SMON (System Monitor Process) background process?

17. Recycle bin can be turned on or off this. This parameter is stored in which of the below file?

18. When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called

19. A collection of data designed to be used by different people is called a/an

20. Which of the following is the oldest database model?

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !