SQL Interview Questions
- What is SQLPlus?
- What is deadlock?
- What is reference cursor?
- Explain about SQL related to RDBMS?
- What are the two components of ODBC?
- What are two methods of retrieving SQL?
- How to test data loading in database testing?
- How to store directory structure in a database?
- What are the various uses of database triggers?
- How can variables be passed to a SQL routine?
- Does SQL SERVER Supports “Finally” block?
- Difference between VARCHAR and VARCHAR2?
- What is a join? Explain the different types of joins?
- What is the difference between varchar & varchar2?
- What is the fastest way of accessing a row in a table?
- What is the difference between SQL and SQL Server?
- What are the disadvantages of the client/server model?
- How to find out the 10th highest salary in SQL query?
- Can we call user defined packages in SQL statements?
- How you define which session run and how long time?
- What description of a data source is required for ODBC?
- What is a default TCP/IP socket assigned for SQL Server?
- What is normalization and different kinds of normalization?
- What is the difference between file server and a database server?
- Which of the following statements is true about implicit cursors?
- Explain the concept of joins and list out the different type of joins?
- Which date function is used to find the difference between two dates?
- What are steps required tuning this query to improve its performance?
- How to find out the database name from SQL*PLUS command prompt?
- What are the privileges that can be granted on a table by a user to others?
- How to write a Sql statement to find the first occurrence of a non zero value?
- When size of database is long then how we can divide it into more databases?
- What is the main difference between the IN and EXISTS clause in sub queries?
- What are the advantages and disadvantages of primary key and foreign key in SQL?
- Which system tables contain information on privileges granted and privileges obtained?
- Why do we use cache and no cache in sequences? What is the benefit we have in using them?
- You want to include a carriage return/linefeed in your output from a SQL script, how can you do this?
- Why is it better to use an integrity constraint to validate data in a table than to use a stored procedure?
- Can we connect two different relational tables from different data sources and get the output as one flat file?
- How to get the first day of the week, last day of the week and last day of the month using T-SQL date functions?