How do you performance tune a database?

484

What do you understand by data redundancy?

492

How can you perform pattern matching in sql?

538

How to retrive a single data from a database

579

How do I add a file to a database?

465

Differentiate between ‘cluster’ and ‘non-cluster’ index.

478

What are functions in database?

511

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????

1550

What is a key in dbms?

487

What are the main components of a database in healthcare?

446

What is difference between database and dbms?

480

Mention the differences between union and union all

495

Compare non-clustered and clustered index

478

What are the ways to controlling cursor behavior?

480

What are the various kinds of interactions catered by dbms?

1696