Define the following terms
i. Inverted List ii. Candidate Key iii. B-Tree
iv. Foreign Key
Answer Posted / karikalan.s
Candidate key - Candidate key is one that can identify each
row of a table uniquely.
Foreign key - Foreign keys are attributes , one table having
matching values in a primary key in another table, allow the
relationship between the tables.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
How do I manually create a database?
Display the employees whose salary is less than average salary.
How heap is implemented in database?
What is the importance of database partitioning?
What is dialect in database?
How to implement database security?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
List various types of log-based recovery in DBMS.
Explain the table term used in database.
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
What do you mean by cluster and non cluster index?
How does database replication work?