Interview Questions

Q:

Can SQL Servers linked to other servers like Oracle?

Answer

SQL Server can be linked to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has an OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 5306
Q:

What is the maximum number of Triggers can be applied in a table ?

A) 8 B) 9
C) 12 D) 14
 
Answer & Explanation Answer: C) 12

Explanation:

We can apply at max of 12 triggers in a table.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle
Job Role: Analyst , IT Trainer

4 5304
Q:

Explain the basic difference between Intra partition TDQ and Extra partition TDQ?

Answer

INTRA PARTITION TD QUEUE : It is a goup of sequential records which are produced by the same and / or different transaction within a CICS region. These Qs are stored in only one physical file (VSAM) in a CICS region, which is prepared by the system programmer. Once a record is read from a queue, the record will be logically removed from the queue.


EXTRA PARTITION TD QUEUE:  It is a group of sequential record which interface between the transaction s of the CICS region and the systems outside of CICS region. Each of there TDQs is a separate physical file, and it may be on the disk, tap, printer or plotter.

Report Error

View answer Workspace Report Error Discuss

0 5269
Q:

Which SQL keyword is used to sort the result-set?

A) ORDER B) ORDER BY
C) SORT BY D) SORT
 
Answer & Explanation Answer: B) ORDER BY

Explanation:

SQL keyword ORDER BY is used to sort the result-set.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 5223
Q:

Difference between Stack and Queue

Answer

Stack is a collection of objects that works in LIFO (Last in First out) mechanism while Queue is FIFO (First in First out). This means that the object that is inserted first is removed last in a stack while an object that is inserted first is removed first in a queue.

Report Error

View answer Workspace Report Error Discuss

Subject: C++

0 5218
Q:

What are steps to define supplier?

Answer

Supplier should follow the check list.

1. He should create confidence in the client mind
2. Services to be done (fulfilled in time)
3. Services to be done according the specification of the client
4. He should be placed the another order by doing the above three steps

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable

6 5210
Q:

What kind of object is modifying sequence algorithm?

A) Function template B) Class template
C) Method D) None of these
 
Answer & Explanation Answer: A) Function template

Explanation:

It is a group of functions and implemented under algorithm header file.

Report Error

View Answer Report Error Discuss

Filed Under: C++

1 5177
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

0 5168