What is limit in dbms?

972

how to Return total number of rows.

969

how would you convert a secondary server into a primary server ?

177

How to apply filtering criteria at group level with the having clause in ms sql server?

959

Explain index covering? List its merits.

889

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

942

Explain the difference between triggers and constraints?

933

What is RAID? What are the different types of RAID configurations?

1073

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

541

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

947

What is wal in postgresql?

811

How to create software using microsoft access?

894

What are the different types of functions in sql?

1010

Explain alias?

1088

What is an inner join sql?

967