Interview Questions

Q:

What are user defined data-types and when do you use them?

Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.


We use them to format the database and segregate specific repetitions of rows and columns in the database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2671
Q:

When would you use the ping command with the "-t" switch?

Answer

to get the ping back from other computer with no packet loss

Report Error

View answer Workspace Report Error Discuss

1 2670
Q:

What is the difference between view and materialized view?

Answer

View:


- Tail raid data representation is provided by a view to access data from its table.


- It has logical structure can not occupy space.


- Changes get affected in corresponding tables.


 


Materialized view


- Pre calculated data persists in materialized view.


- It has physical data space occupation.


- Changes will not get affected in corresponding tables.

Report Error

View answer Workspace Report Error Discuss

0 2669
Q:

Which among the following are the capabilities of the Cursor?

A) It reads every row one by one. B) It can be parameterised and hence are flexible
C) It can be positioned to specific rows D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:

All the above listed actions are the functions of cursor

Report Error

View Answer Report Error Discuss

3 2668
Q:

What are the differences between static ip addressing and dynamic ip addressing?

Answer

With static IP addressing, a computer (or other device) is configured to always use the same IP address. With dynamic addressing, the IP address can change periodically and is managed by a centralized network service

Report Error

View answer Workspace Report Error Discuss

0 2666
Q:

Designing pricing strategies and programs :

How do buyers respond to price changes?

Answer

Depending upon the increase or decrease in price rates, buyers may respond accordingly. Some buyers may assume that quality of the product may have reduced to to reduction in price or that the company may not be selling the product as per expectations. The other assumption that buyers may make is that prices may go down in the future and so may delay purchase. On the other hand increased price may lead to a decrease in demand as the product may be more costly for the consumers who may switch to another seller offering similar products at lower prices.

Report Error

View answer Workspace Report Error Discuss

0 2664
Q:

How will you find the 3rd max salary in the employment table?

Answer

SELECT DISTINCT(salary) FROM emp as e1 


WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2663
Q:

Describe account receivable?

Answer

Accounts Receivable means the amount which comes in to the business. Eg: If the trader made sales to the customer then obviously the trader will received the amount for the sales made. So here the amount which comes in is said to be accouts receivable.

Report Error

View answer Workspace Report Error Discuss

1 2663