Interview Questions

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

What do you mean by reference variable in c++?

Answer

A reference variable provides an alias to a previously defined variable.


Data type & reference-name = variable name

Report Error

View answer Workspace Report Error Discuss

Subject: C++
Job Role: Software Architect

0 5351
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 5348
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 5320
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 5272
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 5256
Q:

Which of these investments may pay dividends?

A) Savings account B) Stocks
C) Bonds D) Certificates of deposit
 
Answer & Explanation Answer: B) Stocks

Explanation:

Stock investment may pay the dividends.

The amount of dividend will be depended on how many stocks you own and how much is that's company net income in that year

For example :

If you own 15 % of the company, and the company announced that they will pay Rs. 1,00,000 as dividend this year, you will get dividend payment of Rs. 15,000.

Report Error

View Answer Report Error Discuss

Filed Under: Accounts Payable
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 5236
Q:

How can different versions of private assemblies be used in the same application without a re-build?

Answer

You can use different versions of private assemblies in the same application without a re-build by specifying the assembly version in the AssemblyInfo.cs or AssemblyInfo.vb file.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

1 5232