Define the following terms
i. Inverted List ii. Candidate Key iii. B-Tree
iv. Foreign Key
Answer / 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 |
How does database replication work?
What are indexes in oracle?
Explain buffer manager?
how can you perform lookup range in lookup stage expalin in detail?
what is cardinality
Should I store images in database?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
Explain inner and outer joins with examples.
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is a database string?
What is sharded database?
Explain data independence & its types.
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)