Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Describe the four types of indexes in DBMS?
Home
DBMS
Describe the four types of indexes in DBMS?
0
votes
asked
Apr 2, 2020
in
DBMS
by
rajeshsharma
Describe the four types of indexes in DBMS?
#dbms-index-types
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Apr 2, 2020
by
amita rallin
A unique primary index is unique and is used to find and store a row. A nonunique
primary index is not unique and is used to find a row but also where to store a row
(based on its unique primary index). A unique secondary index is unique for each row
and used to find table rows. A nonunique secondary index is not unique and used to
find table rows.
https://madanswer.com/cassandra
https://madanswer.com/agile
Related questions
0
votes
Q: Briefly describe the three types of SQL commands in DBMS?
asked
Feb 28, 2020
in
DBMS
by
rahuljain1
#dbms-sql-command
0
votes
Q: Under what conditions should indexes be used in DBMS?
asked
Apr 2, 2020
in
DBMS
by
rajeshsharma
#dbms-indexes
+1
vote
Q: Describe the three levels of data abstraction in DBMS?
asked
Feb 28, 2020
in
DBMS
by
rahuljain1
#dbms-three-level-archietecture
0
votes
Q: Describe the difference between homogeneous and heterogeneous distributed database in DBMS?
asked
Feb 28, 2020
in
DBMS
by
rahuljain1
#dbms-hetrogeneous
0
votes
Q: Describe concurrency control in DBMS?
asked
Feb 28, 2020
in
DBMS
by
rahuljain1
#dbms-concurrency
0
votes
Q: How many types of relationship exist in database designing in DBMS?
asked
Mar 31, 2020
in
DBMS
by
amita rallin
#dbms-relationship
0
votes
Q: Name four applications for triggers.
asked
Mar 31, 2020
in
DBMS
by
amita rallin
#dbms-application-triggers
0
votes
Q: Describe the process of implementing and using secondary indexes in Azure Table Storage to improve query performance?
asked
Nov 17, 2023
in
Azure
by
GeorgeBell
azure-table-interview-questions-answers
0
votes
Q: dbms viva questions
asked
Aug 27, 2022
in
DBMS
by
Robin
dbms
questions
answers
viva
0
votes
Q: What is DBMS?
asked
Dec 13, 2020
in
DBMS
by
SakshiSharma
#what-is-dbms
#dbms
...