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) As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
HCL,
1 8474What are statistics, under what circumstances they go out of date, how do you update them?
HCL,
2 9050What are the different ways of moving data/databases between servers and databases in SQL Server?
HCL,
3 15100Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
HCL,
2 10621What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 25607There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
HCL,
1 5294how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
2096
What is progress actional?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Explain the benefits of user-defined functions?
How to delete duplicate rows from table except one?
What do you mean by checkpoints in dbms?
What is difference between stored function and application function?
what is sql server? : Sql server database administration
What are four major operators that can be used to combine conditions on a where clause?
What are all the Common SQL Function?
Differentiate pl/sql and sql?
Where in ms sql server is ’100’ equal to ‘0’?
What is wal in postgresql?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What is unique key in mysql?
What is a system database and what is a user database? : sql server DBA