What is difference between oltp and olap?
No Answer is Posted For this Question
Be the First to Post Answer
what types of replication are supported in sql server? : Sql server database administration
Explain the types of indexes.
Do you know the capabilities of cursors?
How optimize sql query with multiple joins in sql server?
How to find the date and time of last updated table?
What is model database in sql server?
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
how we can store the value like that 001,003,023 etc in sql server 2005
What are the purposes and advantages stored procedure?
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
is it important for a database administrator to understand the operating system and file access? : Sql server administration
how to improve the speed of SQL database server and how to avoid dead lock?
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)