Explain database normalization?
No Answer is Posted For this Question
Be the First to Post Answer
There 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?
What is extended stored procedures?
What is role playing dimension with two examples? : sql server analysis services, ssas
How would you Update the rows which are divisible by 10, given a set of numbers in column?
What is not null constraint?
What is data file in computer?
how to select 5 to 7 rows from a table, which contains 10 rows?
What is an execution plan?
Tell me what is de-normalization and what are some of the examples of it?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
when would you go for denormalization? : Sql server database administration
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)