Interested to Buy Any Domain ? << Click Here >> for more details...
Post New Answer View All Answers
Who proposed the relational model?
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????
What is write ahead logging in DBMS?
What is the use of drop command and what are the differences between drop, truncate and delete commands?
What is foreign key in database?
Why do we need foreign key?
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?
Explain the different types of languages that are available in the dbms?
Describe the difference between homogeneous and heterogeneous distributed database.
How can you get the alternate records from the table in the sql?
How do you performance tune a database?
Enlist the various relationships of database.
What do you mean by dml compiler?
What is acid property in dbms?
What are the applications of database?
