T-sql programming interview questions

Please forward this error screen to 208. Interview Questions and answers on Database Basics 1. The database management system is a collection of programs that enables user to store, retrieve, update and delete information from a database. Data from relational database t-sql programming interview questions be accessed or reassembled in many different ways without having to reorganize the database tables.

What are the different type of SQL’s statements ? This is one of the most frequently asked SQL Interview Questions for freshers. SQL statements are broadly classified into three. Data Definition Language DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table. Data Manipulation Language DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table.

The Select statement is considered as a limited version of the DML, since it can’t change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function. DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example – Grant, Revoke access permission to the user to access data in the database. What are the Advantages of SQL ?

Did not find what they wanted? Try here

SQL is not a proprietary language used by specific database vendors. Almost every major DBMS supports SQL, so learning this one language will enable programmers to interact with any database like ORACLE, SQL ,MYSQL etc. The statements are all made up of descriptive English words, and there aren’t that many of them. SQL is actually a very powerful language and by using its language elements you can perform very complex and sophisticated database operations.

Immediate Job Openings in Java . A field is an area within a record reserved for a specific piece of data. Examples: Employee Name, Employee ID, etc. What is a Record in a database ? What is a Table in a database ? A table is a collection of records of a specific type. For example, employee table, salary table etc.

Subscribe to our Newsletter Subscribe to our weekly Newsletter and receive updates via email. And for some reason it is not configured properly. Few pages of this site are under construction and we are constantly trying to improve it. If you have any suggestions or ideas about how to improve the site, please Let us know. You don’t directly connect your components and services together in code but describe which services are needed by which components in a configuration file. Applying IoC, objects are given their dependencies at creation time by some external entity that coordinates each object in the system.

That is, dependencies are injected into objects. So, IoC means an inversion of responsibility with regard to how an object obtains references to collaborating objects. Dependencies are provided as constructor parameters. Injection is done through an interface. Minimizes the amount of code in your application.

With IOC containers you do not care about how services are created and how you get references to the ones you need. You can also easily add additional services by adding a new constructor or a setter method with little or no extra configuration. Make your application more testable by not requiring any singletons or JNDI lookup mechanisms in your unit test cases. IOC containers make unit testing and switching implementations very easy by manually allowing you to inject your own objects into the object under test.

Loose coupling is promoted with minimal effort and least intrusive mechanism. The factory design pattern is more intrusive because components or services need to be requested explicitly whereas in IOC the dependency is injected into requesting piece of code. Also some containers promote the design to interfaces not to implementations design concept by encouraging managed objects to implement a well-defined service interface of your own. IOC containers support eager instantiation and lazy loading of services. Containers also provide support for instantiation of managed objects, cyclical dependencies, life cycles management, and dependency resolution between managed objects etc.