What is trigger in dbms?

905

What are the lock types?

945

What are the types of tables in database?

989

What is the rdbms concept in sql?

981

Explain the terms database and dbms?

905

When we will denormalize data?

1005

Why is data modelling important?

851

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2608

How many types of database language exist?

1034

Explain the terms specialization and generalization.

941

What's the difference between clustered and non-clustered indexes?

965

What are the types of database lock?

1038

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1919

What is the difference between star flake and snow flake schema?

928

What is normalization in database with example?

902