Define primary and unique key?
No Answer is Posted For this Question
Be the First to Post Answer
What are Stored Procedures and When would we Use Them?
Explain the difference between a primary key and a unique key?
What are database functions?
Define a relation schema and a relation.
Can the SNAPSHOTS be refreshed automatically ?
How to Ensure Data Integrity in a Relational Database?
Describe the types of keys?
Describe the Process of ETL (Extract, Transform, Load).
What is implicit cursor in dbms?
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????
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
What is the biggest advantage of rdbms?
Oracle (3259)
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)