What is database Configuration assistant ?
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
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 Distributed database ?
What do you understand by data independence?
What do you understand by intension and extension?
Define entity.
What is index and also explain types of indexing in dbms?
What is openedge workgroup rdbms?
What are the different stages in 'data warehousing'?
Differentiate between nested loop, hash loop and merge join.
Can you drop all the columns of a table ?
Should database table names be capitalized?