QUESTIONS INTERVIEW.IN

Sign Up | Sign In

Post a Question

Asked Questions

Interview Questions

- Computer Language

- Computer Database

- Data Structure

- Certifications

- Cost Accounting

- Common Interview Questions

Home >> Computer Database >> sql

Question

View Answer

=> What is a default TCP/IP socket assigned for SQL Server?

=> How to programmatically find out when the SQL Server service started?

=> What is the difference between cross product & Cartesian product?

=> Difference between decode and case. in which case we are using case and in which case we are using decode?with an example.

=> Difference between Store Procedure and Trigger

=> Which date function is used to find the difference between two dates?

=> What are the advantages and disadvantages of primary key and foreign key in SQL?

=> How we get second highest salary in database. Please show me this coding.

=> What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO');

=> what is the difference between replace and translate functions?

=> What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL;

=> What is the difference between TRUNCATE and DELETE commands?

=> Why does the following command give a compilation error? DROP TABLE &TABLE_NAME;

=> What is the use of CASCADE CONSTRAINTS?

=> What is a subselect? Is it different from a nested select?

=> What is a subselect? Is it different from a nested select?

=> What are the different ways of moving data/databases between servers and databases in SQL Server?

=> What are statistics, under what circumstances they go out of date, how do you update them?

=> As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

=> How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

Page: 1 2 3 4 5 6 7 8

Last

Latest sql Interview video

Latest Topic

How to Import sqlserver data to mysql?

Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given

Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array

HTTPS is invalid and might prevent it from being indexed

Deprecated: Required parameter $sql follows optional parameter $name in

Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null

Your account isn’t eligible for the Google Workspace Individual plan