-
Secure Data
How to secure data in the SQL Server Database?
-
Unsort Query
How to write query to unsort while retrieving data?
psingla
- Mar 9th, 2010
No need to do so. the data fetched by the sql query returns the unsorted data unless the order by clause is not used.
-
What is the difference among "dropping a table”,” truncating a table" and deleting all records" from a table?
psingla
- Mar 8th, 2010
Truncate:Deletes all the record from the table.keeps no entry in log file.so rollback is not possiblefast in operation than delete.Its a DDL statementReset the identity column value to 1 (specific to ...
vasumathi.sridharan
- May 26th, 2009
Delete is a DML StatementTruncate is a DDL StatementDelete can be rolledbackTruncate cannot be rolledback The memory occupied by the table will be released in Truncate.That is Not the case with DeleteTruncate cannot use a where clauseDelete can use a where clauseTruncate is faster than Delete.
-
Difference between Primary Key and Aggregate Key?
psingla
- Mar 8th, 2010
primary key:is a key on ( 1 or group of columns) used to identify a record uniquely.builds clustered index automaticallyAlternate key:is a key which is a unique key but not a primary key.no...
khurram
- Aug 3rd, 2006
aggregate fact tables have two types of keys-composite key-serrogate key (system generated key)So aggregate-key is a primary key
-
What do we mean by Database Testing ? What is the exact meaning of Database Testing
I want to know what do we mean by Database Testing, as well as what role does a Database Tester plays meaning does he performs the similar role as a DBA does or what exactly?What things are performed in Database Testing?
psingla
- Mar 4th, 2010
Database is a backbone of any of the dynamic web site. It needs a through testing to make an efficient and almost error free site.Database Testing includes: Load testing ...
goksn
- Sep 23rd, 2009
There are various levels in database testing, starting from just seeing whether the database has correct value to 'SQL injection'.Generally database testing includes verification of-Accuracy o...
-
Table Name Alias
Why do we use alias for the table name? What is its importance?
psingla
- Mar 3rd, 2010
Alias is a alternate name given to a table for multiple purposes.The scope of the Alias is within the queryAlias is?used to give short name to the table.Used when same table is used n number of times in a query. Alias is used in such queries to give unique name to each table reference.?
goksn
- Sep 23rd, 2009
-is a shorthand notation-Will be used along with column name if same colum name present in more than one table (while joining those tables)-Must in self join
-
T-SQL
What is T-SQL means? How it is different from SQL?
psingla
- Mar 3rd, 2010
SQL/PL-SQL/T-SQLSQL(Structured Query Language): is a ANSI complinent languge to operate a database.It includes DDL(Create,alter,drop,truncate),DML(select,insert,delete,update) and DCL(Grant,revo...
ajitnayak
- Feb 28th, 2009
As the name indicates that T-SQL means transact SQL queries developed by Microsoft. It is a programming language and the difference between SQL and T-SQL is SQL is the base class for T-SQL and T-SQL is inherited from SQL having some extra features as compared to SQL.
-
How do you change column names in SQL Server ?
shabanabegum
- Dec 9th, 2009
Exec sp_rename 'oldtablename.oldcolmnname','newcolumnname'for example Exec sp_rename 'employee.DateofBirth','DOB'Thanks
-
Name of the class of SQL?
-
BCP Set of Rows
How do you BCP only a certain set of rows out of a large table?
snigd
- Oct 7th, 2009
WHERE cluase can be used with bcp commands and all the conditions can be mentioned in the query to generate the set of rows you want to copy.
-
What is the difference between Inner join and full outer join in terms of the Number of rows returned?
zeekhan
- Aug 12th, 2009
Inner Join returns matching records onlyA full outer join returns all rows in both the left and right tables
sa_dub
- May 4th, 2009
Inner Join is used to join two coloumns of the same table which have some same attributes but Outer Join used for join two coloumns of different tables which have unmached attributes.
-
Suppose you create a students record with 5 marks, total and average.How to filter the top 3 students which are getting high average.
-
SQL Server TCP/IP Port
Which TCP/IP port does SQL Server run on? How can it be changed?
sonalimajumdar
- Jul 17th, 2009
SQL server works on 1433 port and DAC (dedicated admin connection ) works on 1434 port. You can change the port number SQL server should use through SQL net configuration manager.
-
Database SQL Query
You are required to design a social networking site. Set of all those people who are friend of friends your friends would be consider to be in your network. Write a SQL query to print Number of people in your network. You need to create a profile of each user and store his/her photographs. How would you go about doing the same using database?
gudluck
- Jul 11th, 2009
Answer for ist part of the question:Create 2 tables mapidandnames and friendsTable:mapidandnamesid name-------------- 1 a 2 &n...
-
What are data objects?
Rekha
- Jan 15th, 2007
Stored procedures,views,tables,database diagrams are the data objects
-
What is the difference between "procedure" and "function"?
sushilmishra
- Jun 8th, 2009
* Stored procedure contains all DML stmt to perform operation With permanent table where user define function does not contain insert, update, delete stmt to modify the permanent table.* Stored proc...
praveen34.tit
- Apr 2nd, 2009
The major difference between procedure and function is that 1. Procedure can be compiled only once and vice versa. 2. Execution of procedure is faster then function 3. Function can be used in select Q...
-
What's the use of SQL Profiler?
jannani
- May 12th, 2009
SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.Use of SQL Profiler:Monitor the performance of an instance of SQL Server.Debug Transact-SQ...
ak
- Nov 29th, 2005
It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuni...
-
How to change rows into column and columns in to rows using sql query in MSSQL?
jjvetri
- May 8th, 2009
CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000
-
What are data objects?
-
What is the difference between windows authentication and sql server authentication
srialekhya
- Apr 22nd, 2009
Windows authentication is highly secure than SQL Server authentication why because we need not provide any login details. So the chance of tracing login details from code by the unauthorized?persons will be less. Windows?authentication uses the default windows login credentials.
sidver
- Jul 16th, 2008
Windows authentication will uses the credentials of the currently logged user to login in to the sql server database. Your application need not to supply the user name and password. for SQL server...
SQL Server Interview Questions
Ans