What is the difference between case version and decode version?

1091

What is the type of image in database?

916

What is the advantage of using preparedstatement?

995

How to handle data if f table are more than one and each table contain thousands of entries?

2111

Explain what are triggers and rules?

969

Why do we study dbms?

999

Explain armstrong rules? How they are complete and/or sound?

953

What do you mean by query evaluation engine?

1036

What is bcnf?

1080

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

1982

How to reorder the table columns (fields)?

1160

How do databases help businesses?

931

Briefly describe the three types of sql commands.

1065

Explain the difference between primary and foreign key?

1141

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

982