SQL

SQL Subjective Questions and Answers

More interview questions and answers

What are the advantages of using Stored Procedures?

Why we use Semicolon after SQL Statements?

What\'s the maximum size of a row?

What is a Scheduled Jobs or What is a Scheduled Tasks?

What is NOT NULL Constraint?

What is CHECK Constraint?

What is the STUFF function and how does it differ from the REPLACE function?

What do you mean by Table Sample?

What is PRIMARY KEY?

What is UNIQUE KEY constraint?

What is FOREIGN KEY?

What is the mean of The model?

What do u mean by The tempdb?

Define The msdb database?

What is Replication and Database Mirroring?

What does TOP Operator Do?

What are Sparse Columns?

What is CLR?

What is the ROW_NUMBER()?

What is the EXCEPT clause?

What is the Page Compression?

What is the mean of Dictionary Compression?

What is Pivot and Unpivote?

What is an Aggregate Function?

What is SQLCMD?

What is the Dirty Read?

What is the Filestream?

Explain Active/Active and Active/Passive cluster configurations?

What is denormalization and when would you go for it?

What are the Different methods of loading Dimension tables?

What is surrogate key?

What is the Referential Integrity?

What do you mean by Live Lock?

What do you mean by Deadlock?

What is the purpose of UPDATE STATISTICS?

What is the use of SCOPE_IDENTITY() function?

How do you transfer data from text file to database (other than DTS)?

What is a Join in SQL Server?

What is RAID and what are different types of RAID configurations?

What are the main attributes of database management system?

What are the main components of Database management systems software.

What is query optimization?

What is Oracle locking?

What Oracle lock modes do you know?

Describe TO_DATE function?

What is the Sql Wild card?

What are the difference between DDL, DML and DCL commands?

Which one is faster DELETE/TRUNCATE?

What is RDBMS?

What are different normalization forms?

What is normalization?

What is Stored Procedure

What is Trigger?

What is View?

What is Index?

What is SQL?

What are the components of physical database structure of Oracle database?

What are the components of logical database structure of Oracle database?

What is a tablespace?

What is SYSTEM tablespace and when is it created?

Explain the relationship among database, tablespace and data file.

What is schema?

What are Schema Objects?

Can objects of the same schema reside in different table spaces?

Can a tablespace hold objects from different schemes?

What is Oracle table?

What is an Oracle view?

Do a view contain data?

What is ACID ?

Define the Primary key?

What do you mean by Candidate key?

What is the Foriegn Key?

What are the use of Null?

What are the properties of the Relational tables?

What is De-Normalization?

What is the mean of Nested Trigger?

What is a Linked Server?

What is Cursor?

What is Collation?

What is Difference between Function and Stored Procedure?

What is the Sub-Query?And what is the properties of Sub-Query?

Give the list how many type of Joine?

Define : What is the Cross Join?

give us a definition of Inner Join?

What do you mean by Outer Join? and define also how many types of Outer Join?

Defeine : Self Join?

What is User Defined Functions?

What kind of User-Defined Functions can be created?

What is Identity?

What is DataWarehousing?

What are slowly changing dimensions (SCD)?

What is the clustered index?

What is the SCD1 ?

What do you mean by A non clustered index?

What are the different index configurations a table can have?

What are different types of Collation Sensitivity?

What is OLTP?

What do you mean by TRUNCATE?

What do you mean by DELETE command?

When is the use of UPDATE_STATISTICS command?

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

What are the properties of SUB-QUERY?

What are the type of SUB-QUERy?

What is SQL Profiler?

What are the authentication modes in SQL Server? How can it be changed?

What is SQL Server Agent?

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

What is Log Shipping?

What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

What is the mean of Local temporary table?

What do u mean by Global temporary table?

What is ER Diagram ?

What is BCP? When does it used?

What is the UNION?

What is an execution plan? When would you use it? How would you view the execution plan?

How to implement one-to-one,one-to-many and many-to-many relationships while designing tables?

What do you mean by The master database?

Define whats the mean by Resoure Database?

What is Service Broker?

What is Policy Management?

What is CTE?

What is MERGE Statement?

What is Filtered Index?

What are the Advantages of using CTE?

What are synonyms?

What is LINQ?

What is Isolation Levels?

What is the NOLOCK?

What is the RaiseError?

What is Xml Datatype?

What is Data Compression?

What is the mean of Row Compression?

What do you mean by DBCC Command?

What is Catalouge Views?

What is the Ranking functions?

What is the mean of ROW_NUMBER() OVER?

What is the RANK() OVER?

What is the DESK_RANK() OVER?

What is the mean of UNIONALL?

What is the mean of Root Node?

What do you mean by Branch Node?

What do you mean by Leaf Nodes?

What is lock escalation?

What do you mean by Snow schema?

What do you mean by Star schema?

What do you mean by SCD3 ?

What do you mean by SCD2?

What is RAID?

What is DTC?

What is DTS?

What are defaults? Is there a column to which a default can't be bound?

What do you mean by COLLATION?

When do you use SQL Profiler?

What is database replication? What are the different types of replication you can set up in SQL Server?

What do you mean by Distributed partitioned views.?

How many New Data types are in the SQL Server 2000?

What do you mean by INSTEAD OF and AFTER Triggers.?

What do you mean by Cascading Referential Integrity Constraints?

Whay do you mean by XML Support in Sql Server 2000?

What do you mean by Indexed Views>

Why we use Stored Procedure?

What is the use of union in Indexing?

What do you mean by Read Committed?

What is the basic difference between a join and a union?

What is a Cartesian product?

What do you mean by Read Uncommitted?

What do you mean by Repeatable Read?

What do you mean by Serialized?

Discuss about Disadvantages of cursors?

What does COMMIT do?

What databases do you know?

In what sequence SQL statement are processed?

Class members

What is use of \'in\' command?

I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?

SQL Subjective Questions and Answers