Oracle SQL Interview Questions and Answers

What is Rowid?
It is a Hexadecimal Representation of a Row in a Table. Rowid can only be Changed if we ‘Enable Row Movement’ on a Partitioned Table. Rowid’s of Deleted Rows can be Reused if Transaction is Committed.
What is the Difference between Translate & Replace?
Translate function converts each character in String with specified one whereas Replace function replaces part of the string in continuity by another sub-string.
What is NVL?
NVL: Null value function converts a null value to a non-null value for the purpose of evaluating an expression.
Operators used in SELECT statements are?
= Equal <> or != Not equal > Greater than < Less than >= Greater than or equal <= Less than or equal BETWEEN Between an inclusive range LIKE Search for a pattern
What is the significance of the & and && operators?
The & operator means that the PL SQL block requires user input for a variable.The && operator means that the value of this variable should be the same as inputted by the user previously for this same variable
Is Sysdate a system variable or a system function?
System Function
What is the difference between a view and a synonym ?
Synonym is just a second name of table used for multiple link of database.View can be created with many tables, and with virtual columns and with conditions.But synonym can be on view.

Latest Updates

Average

The mean of 100 students marks was found to be 40. it was found later that a mark 53 was read as 83. the correct mean is?

Numbers

The geometric mean of three observations 40, 50 and X is 10, then the value of X is ?

Indian Politics

Who appoints the members of National human rights commission?

The President of India can resign by writing under his hand addressed to?

Under which article of the constitution of India can the President of India refer a matter to the Supreme Court for its opinion?

General Computer Knowledge

The term VPN stands for ?

The transmission control protocol(TCP) is a............ layer protocol ?

Oracle PL/SQL

What is the difference between Procedure and Function?

Define exception and How will you raise an exception in PL/SQL procedure?

What is the advantage of using packages for storing PL/SQL objects?

Fill in the blank

I ________ station before the train arrived.

If I ______ a king, I would help everyone.

Radha___________her daughter for an hour.

Errors Identification

Find out which part of the sentence below has an error and mark the option accourdingly -
Sohan was married in 1990 and have three children.

Find out which part of the sentence below has an error and mark the option accourdingly -
There is no money in the bank in Ram Singh's and Rama's joint account.

Direction

Swapnil start from his home and walked 35 km towards east, after that he turned to his right and walked 20 km. He again turned to his right and walks 35 km. Finally, he turned to his left and walked 20 km and reached his office. How far is his office from his home?

Numbers

How many 2 digit numbers are divisible by 6?

HCF and LCM

Find the smallest square number which is exactly divisible by 3, 5, 15, 18, 20 and 24?