Enlist some commands of dcl?
No Answer is Posted For this Question
Be the First to Post Answer
Why its better to use files than a DBMS when there are multiple users to access the data
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 2nf and 3nf?
What is 'cross join'? Or what is cartesian product?
Explain 5nf?
What are the drawback of rdbms?
Explain the Surrogate Key in DBMS.
what is storage manager?
Explain the different types of join operations?
What are the Different Types of Joins and How do They Work?
Explain the terms database and dbms. Also, mention the different types of dbms.
where a Database Procedure is stored ?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)