Sawaal
  • Home/
  • Searching for i

 Searching for "i"

Q:

Name any three PL/SQL exceptions?

Answer

Too_many_rows.


No_Data_Found.


Zero_Error.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Describe the use of PL/SQL table?

Answer

PL/SQL tables are scalar arrays that can be referenced by a binary digit. They can be used to store values for later queries and calculations.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What type of Joins have you used?

Answer

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What is the difference between JOIN and UNION?

Answer

SQL JOIN allows access to records of other table based on the given conditions between two tables.


Ex: If we are provided with the department ID of each employee, then we can use the department ID of the employee table to merge with the department ID of the department table to access department names.


UNION operation allows addition of 2 similar data sets to create a resulting set that contains all the data from the source data sets.


Ex: If we are provided with 2 employee tables of the same structure, we can UNION them to create a singular result that will contain all employee from both the table.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Write SQL Query to display current date?

Answer

The built in function called GetDate() returns the time stamp.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Difference between a query and a statement in SQL?

Answer

An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard.


A query is a statement that returns a record-set.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Write an SQL Query to find employees whose name starts with an ‘M’?

Answer

SELECT *FROM Employees WHERE EmpName like ‘M%’.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Define a temp table.

Answer

In a nutshell, a temp table is a temporary storage structure. It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.


In table_user.gender column change ‘male to female’ and ‘female to male’ in one SQL statement.


UPDATE table_user


SET gender =


CASE gender


WHEN ‘male’ THEN ‘female’


WHEN ‘female’ THEN ‘male’


ELSE gender


END

Report Error

View answer Workspace Report Error Discuss

Subject: SQL