Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 SSRS: 1. How to render a report to a user email? 2. How to join two dat...
As part of SQL Server 2005 Setup, the System Configuration Checker (SCC) scans the computer where Microsoft SQL Server 2005 will be installed. The SCC checks for conditions that prevent a successful SQL Server installation. Before Setup starts the SQL Server 2005 Installation Wizard, the SCC retr...
SQL Interview Questions http://career.guru99.com/top-50-sql-question-answers/ 1. What is DBMS? A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than savi...
Now, one more question to you guys. If you have heap table, what ?, Can anyone share their thoughts via putting some comments? Create a sample table: 1 2 3 4 5 6 7 CREATE TABLE tbl_Students ( StudID INT IDENTITY(1,1) ,Name VARCHAR(10) ...
These kinds ofSQL interview questionsconfuse the candidate at times. So, coming to the question, there are three different kinds of operators available in SQL. They are: Arithmetical operators Logical operators Comparison operators 4) Are the terms zero or blank space the same as that of NULL ...
SQL Interview Question 面试的时候发现会问一些SQL的基本问题,在此总结一下。 ProgramInterview/SQL这个网站上的问题还比较全。 1. Join type INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from ...
5. What are the steps you will take, if you are tasked with securing an SQL Server? Again this is another open ended question. Here are some things you could talk about: Preferring NT authentication, using server, database and application roles to control access to the data, securing the...
Ask us a new question Last Updated on Saturday, 28 June 2014 Read more... Article... Encrypt connectionStrings section of web.config Detecting Refresh or Post back in ASP.NET Send Email Using Gmail in ASP.NET The C# Programming Language Version 4.0 C# .NET 2.0 Test Driven Developmen...
DBA question Multiple SQL Server services are running and IntelliSense is turned on.Day12 What are aggregate functions (A.K.A. Group Functions)? (They perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING ...
Frequently Asked Question Any questions?We are here to help. Additional FAQ Are these videos, just interview question or its in-depth? Do I need to do any sign-up in QuestPond? What are the different types of subscriptions? After knowing details now how to became subscription holder...