11. Which are new data types introduced in SQL SERVER 2008? The GEOMETRY Type: The GEOMETRY data type is a system .NET common language runtime (CLR) data type in SQL …
May 2016
- Interview Questions and AnswersSQL ServerTechnical Interview Questions and Answers
- Interview Questions and AnswersSQL ServerTechnical Interview Questions and Answers
SQL Server 2008 Interview Questions And Answers For Freshers and Experience Part-1
by Sby S1. What are the basic functions for master, msdb, model, tempdb and resource databases? The master database holds information for all databases located on the SQL Server instance and is …
- Interview Questions and AnswersSQLTechnical Interview Questions and Answers
SQL Server Common Interview Questions And Answers For Freshers and Experience Patrt-3
by Sby S21. What is PRIMARY KEY? A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table should have a primary key constraint to uniquely …
- Interview Questions and AnswersSQLTechnical Interview Questions and Answers
SQL Server Common Interview Questions And Answers For Freshers and Experience Patrt-2
by Sby S11. What is SQL Profiler? SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save …
- Interview Questions and AnswersSQLTechnical Interview Questions and Answers
SQL Server Common Interview Questions And Answers For Freshers and Experience Patrt-1
by Sby S1. Which TCP/IP port does SQL Server run on? How can it be changed? SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties. …
- Interview Questions and AnswersSQLTechnical Interview Questions and Answers
SQL Server General Interview Questions And Answers For Freshers and Experience Part-2
by Sby S10. What is Index? An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It …
- Interview Questions and AnswersSQLTechnical Interview Questions and Answers
SQL Server General Interview Questions And Answers For Freshers and Experience Part-1
by Sby S1. What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-14
by Sby S131. Describe the difference between data and database administration. Data administration is responsible for the overall management of data resources. Some of the core roles include the creation of data …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-13
by Sby S121. Describe middleware applications that ease the connection of databases to Web applications. Both ASP and ColdFusion are middleware that ease the connection of databases to Web applications. Both require …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-12
by Sby S111. Explain a join between tables A join allows tables to be linked to other tables when a relationship between the tables exists. The relationships are established by using a …