How write primary and foreign key relationship between two
tables without using constraints? u can use any of
procedure/function/trigger and any sql?
What does seeding a database mean?
Can we use commit inside a trigger?
What is the use of primary key?
Can we join same table in sql?
What does count (*) mean in sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is cost in sql execution plan?
Where is all the data on the internet stored?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Explain the steps needed to create the scheduled job?
what is ref cursor in pl/sql?
what is the use of friend function? : Sql dba
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)