Surrogate key-primary key
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
Expert
The ideal primary key is numeric, short and fixed. A surrogate key is an exclusive, DBMS-supplied identifier intended to be employed as the primary key of a table. Furthermore, the DBMS will not permit the value of a surrogate key to be modified. The values of a surrogate key have no meaning to the users and are generally hidden on forms and reports. By design, they are numeric, short and fixed and therefore meet the definition of the ideal primary key.
Which type of pointer will be use to implement the heterogeneous linked list in C language?
What do you understand by the termed dependency graph in DBMS?
Explain and compare OBE and SQL?
Explain several of the products of Sybase?
Explain the hot backup in case of Oracle.
Who can create up a database or system team? Give a short demonstration of each.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Explain the term Contexts?
Give a brief introduction of term the conformed fact?
Why do not you utilize GNU SCONS or autoconf for building?
18,76,764
1953041 Asked
3,689
Active Tutors
1414943
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!