Interview Questions


Database concepts Interview questions - Part 4

<<Previous  Next>>

 Part 1 | Part 2 | Part 3 | Part 4

28.Define aggregate and scalar functions.

Aggregate Functions return a single value by operating against a group of values. Scalar functions operate against a single value................ 

29.What are the restrictions applicable while creating views?

Views can be created referencing tables and views only in the current database.
A view name must not be the same as any table owned by that user.
You can build views on other views and on procedures that reference views.............

30.What is "correlated subqueries"?

In "correlated subqueries", the result of outer query is passed to the subquery and the subquery runs for each row...............  

31.What is Data Warehousing?

Data Warehousing is a process of storing and accessing data from central location for some strategic decision................ 

32.What is a join and explain different types of joins.

Joins are used in queries to explain how different tables are related.
Joins also let you select data from a table depending upon data from another table................ 

Part 1 | Part 2 | Part 3 | Part 4
<<Previous  Next>>

Also read

What are the capabilities of Cursors?

Answer - Cursors can support various functionalities that are listed here.....

What are the ways to controlling Cursor Behavior?

Answer - Cursors behavior can be controlled by dividing them into cursor types: forward-only, static,........

Define temporary and extended stored procedure.

Answer - Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

Describe in brief authentication modes in SQL server.

Answer - This is the default and recommended security mode. In this mode, access to SQL server is controlled by Windows NT.....

Define Identity and uniqueidentifier property of Column.

Answer - Column with identity property contains unique system generated value in the table. Column with identity property is similar to AutoNumber field in MS Access....



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring