Interview Questions

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

1 4894
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 4893
Q:

What is the kind of execution does sequence point allow?

A) Non-overlap B) Overlap
C) Concurrent D) None of these
 
Answer & Explanation Answer: A) Non-overlap

Explanation:

To resolve all the side-effects in the program, the sequence point should not be overlapped.

Report Error

View Answer Report Error Discuss

Filed Under: C++

2 4886
Q:

What are PL/SQL Subprograms? What are its Advantages ?

Answer

Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs.


 


Advantages of PL/SQL subprograms are


- The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times. This will reduce the number of calls between the database and the application.


- PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application. The application will only make a call to the PL/SQL sub program


- PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 4878
Q:

what type of account appear on a post closing trial balance?

Answer

The types of accounts that appear on the post-closing trial balance are the permanent accounts, Assets, Liability and Owner's capital. Permanent accounts is also called real accounts.

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable

22 4878
Q:

How the member functions in the container can be accessed?

A) Iterator B) Indirect
C) Both a & b D) None of these
 
Answer & Explanation Answer: A) Iterator

Explanation:

The container manages the storage space for its elements and provides member functions to access them, either directly or through iterators which reference objects with similar properties to pointers.

Report Error

View Answer Report Error Discuss

Filed Under: C++

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

2 4874
Q:

How does Node.js prevents blocking code?

Answer

By providing callback function. Callback function gets called whenever corresponding event triggered.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Software Architect

0 4846