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 4896
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 4894
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 4888
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 4879
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 4879
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 4878
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 4876
Q:

Explain Non Breaking space in HTML.

Answer

When we add many spaces in the content then HTML remove all space except one space this is Non Breaking Space. To overcome this problem we use “&nbsp”. Suppose we want to add 3 space between two words then we have to use &nbp three time. 


 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 4871