Why de-normalization required?
No Answer is Posted For this Question
Be the First to Post Answer
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
What are the different normalization forms?
Explain the cursor lock types?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Why transaction is important?
How do we know if any query is retrieving a large amount of data or very little data?
How to execute a sql statement using mssql_query()?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is the difference between 2-Tier architecture and 3-Tier architecture
15 Answers CTS, MCN Solutions, Oracle,
What is difference between stored procedure and user defined function?
What are commonly used odbc functions in php?
What is named query? : sql server analysis services, ssas
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)