Explain the term entity set in dbms?
What is 1nf in database?
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 an optimization and performance tuning and how does it really work in practical projects?
Can a DIALOG WINDOW have scroll bar attached to it ?
Can I concurrently access a firebird database with embedded and with regular server?
what is s/w lifecycle?
What is stored in a database?
What are the characteristics of database management system?
Can you explain the select into statement?
what are the different kinds of indexing?
Can we assign Explicitly transaction to a rollback segment
When does checkpoint occur?