Explain primary key and composite key.
No Answer is Posted For this Question
Be the First to Post Answer
what is difference between paging and fragmentation?
Which factors does not affect the size of the SGA ?
What is the structure of a database?
Explain snapshot replication.
Are Constraints exported through Export command?
What is bcnf?
What SYSTEM VARIABLE is used to refer DATABASE TIME ?
How do you open .db files?
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????
Why do we need foreign key?
How can we tune if buffer busy wait issue comes in oracle?
Explain a join between tables?
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)