how can do you the system monitoring?
Explain having clause?
How do you simulate a deadlock for testing purposes
Why use view instead of a table?
List the different normalization forms?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What are 3 ways to get a count of the number of records in a table?
Explain the third normal form(3nf)?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
What is the size of transaction log file?
What is a fill factor?
When multiple after triggers are attached to sql table, how to control the order of execution?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)