Sawaal
  • Home/
  • Searching for h

 Searching for "h"

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 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:

How to create recursive query in SQL Server?

Answer

Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression). It might be also worth asking about performance as CTE is not always very fast.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Which command using Query Analyzer will give you the version of SQL server and operating system?

Answer

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel') and SERVERPROPERTY ('edition').

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

What is SQL Server Agent?

Answer

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Which TCP/IP port does SQL Server run on? How can it be changed?

Answer

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL