What is database management system(dbms)?
What are five main functions of a database administrator?
What is bcnf standard form in dbms?
What is database in simple language?
Describe concurrency control.
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 GET_BLOCK property ?
What is the main purpose of normalization?
Explain what are super servers?
what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).
What is db driver?
5) Which acid property will effect when we use commit in trigger?
What are the different levels of abstraction in the dbms?