Most voted questions in Database

0 votes
1 answer

Is SELECT * harmful in Database?

There are really three major reasons: Inefficiency in ...READ MORE

Sep 7, 2018 in Database by DataKing99
 • 8,250 points • 832 views
0 votes
1 answer

What are stored procedures in database?

A stored procedure is a collection of ...READ MORE

Sep 6, 2018 in Database by CodingByHeart77
 • 3,750 points • 1,065 views
0 votes
2 answers

Difference between primary key a composite key

candidate  key: It is the collection of ...READ MORE

Oct 14, 2020 in Database by anonymous
 • 31,172 views
0 votes
1 answer

What is checkpoint in Database?

Checkpoint declares a point before which all ...READ MORE

Sep 4, 2018 in Database by Sahiti
 • 6,370 points • 1,812 views
0 votes
1 answer

Fragmentation in Database

Fragmentation is a feature which controls the ...READ MORE

Sep 4, 2018 in Database by Sahiti
 • 6,370 points • 532 views
0 votes
1 answer

Explain Data Dictionary

Data dictionary is a set of information ...READ MORE

Aug 30, 2018 in Database by CodingByHeart77
 • 3,750 points • 715 views
0 votes
1 answer

Data Independence & it's types

Data Independence refers to the ability to ...READ MORE

Aug 30, 2018 in Database by CodingByHeart77
 • 3,750 points • 5,636 views
0 votes
1 answer

Buckets in HIVE

There are two main reasons for performing bucketing ...READ MORE

Aug 30, 2018 in Database by kurt_cobain
 • 9,390 points • 735 views
0 votes
1 answer

External and Managed Table : HIVE

The metadata information along with the table ...READ MORE

Aug 30, 2018 in Database by kurt_cobain
 • 9,390 points • 572 views
0 votes
1 answer

Hcatalog in HIVE

HCatalog supports reading and writing files in ...READ MORE

Aug 30, 2018 in Database by kurt_cobain
 • 9,390 points • 1,511 views
0 votes
1 answer

Common Hive Services

The following are commonly used services of ...READ MORE

Aug 30, 2018 in Database by kurt_cobain
 • 9,390 points • 955 views
0 votes
3 answers

What is Phantom deadlock?

To understand phantom deadlock, you need an ...READ MORE

Feb 13, 2019 in Database by Ravi kumar
 • 9,320 views
0 votes
1 answer

Ways to improve query performance using Index hunting

Index hunting help in improving query performance ...READ MORE

Aug 29, 2018 in Database by CodingByHeart77
 • 3,750 points • 2,186 views
0 votes
1 answer

components of Hbase

Apache HBase Consists of the following main ...READ MORE

Aug 28, 2018 in Database by kurt_cobain
 • 9,390 points • 742 views
0 votes
1 answer

What are stored procedures?

The stored procedure is a collection of ...READ MORE

Aug 23, 2018 in Database by CodingByHeart77
 • 3,750 points • 1,266 views
0 votes
1 answer

Atomicity and Aggregation in Database

Atomicity is the condition where either all the ...READ MORE

Aug 22, 2018 in Database by DataKing99
 • 8,250 points • 2,952 views
0 votes
1 answer

What is Data partitioning?

This is the process of partitioning tables, ...READ MORE

Aug 22, 2018 in Database by DataKing99
 • 8,250 points • 7,092 views
0 votes
1 answer

Secondary index in Cassandra

Secondary indexes are indexes built over column ...READ MORE

Aug 21, 2018 in Database by kurt_cobain
 • 9,390 points • 880 views
0 votes
1 answer

Cassandra Data Model

Cassandra Data Model consists of four main ...READ MORE

Aug 21, 2018 in Database by kurt_cobain
 • 9,390 points • 751 views
0 votes
1 answer

Management Tools in Cassandra

DataStaxOpsCenter: internet-based management and monitoring solution for ...READ MORE

Aug 21, 2018 in Database by kurt_cobain
 • 9,390 points • 1,022 views
0 votes
1 answer

Tunable Consistencies in Cassandra

Tunable Consistency is a phenomenal characteristic that ...READ MORE

Aug 21, 2018 in Database by kurt_cobain
 • 9,390 points • 989 views
0 votes
1 answer

TRIGGERS used in MySQL tables

The following TRIGGERS are allowed in MySQL:  BEFORE ...READ MORE

Aug 21, 2018 in Database by CodingByHeart77
 • 3,750 points • 574 views
0 votes
1 answer

Types of tables in MySQL

MyISAM is the default table that is ...READ MORE

Aug 21, 2018 in Database by CodingByHeart77
 • 3,750 points • 1,534 views
0 votes
1 answer

Clustered vs Non-clustered Indexes

Clustered indexes - The indexes according to ...READ MORE

Aug 20, 2018 in Database by DataKing99
 • 8,250 points • 534 views
0 votes
1 answer

Indexes in Database

The index is a data structure that ...READ MORE

Aug 20, 2018 in Database by DataKing99
 • 8,250 points • 905 views
0 votes
1 answer

What is schema?

The description of a database is called ...READ MORE

Aug 17, 2018 in Database by CodingByHeart77
 • 3,750 points • 765 views
0 votes
1 answer

What is Proactive/Retroactive/Simultaneous Update

Proactive Update: The updates that are applied ...READ MORE

Aug 17, 2018 in Database by CodingByHeart77
 • 3,750 points • 3,552 views
0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

Aug 17, 2018 in Database by zombie
 • 3,790 points • 2,746 views
0 votes
1 answer

What is Data Redundancy?

Duplication of data in the database is ...READ MORE

Aug 17, 2018 in Database by Sahiti
 • 6,370 points • 1,199 views
0 votes
2 answers

SQL vs NoSQL

Well, it depends on what you are ...READ MORE

Aug 11, 2018 in Database by slayer
 • 29,370 points • 1,091 views
0 votes
1 answer

When is the functional dependency known as fully functional dependency?

The criteria of fully functional dependency, is ...READ MORE

Aug 10, 2018 in Database by DataKing99
 • 8,250 points • 2,472 views
0 votes
1 answer

What is Functional dependency?

A relation is said to be in ...READ MORE

Aug 10, 2018 in Database by DataKing99
 • 8,250 points • 794 views
0 votes
2 answers

Database Lock and its types.

Hello Dataking99, A database lock is used to ...READ MORE

Apr 20, 2020 in Database by Niroj
 • 82,880 points • 18,177 views
0 votes
1 answer

Data Models operations HBase

Put Method – To store data in ...READ MORE

Aug 9, 2018 in Database by kurt_cobain
 • 9,390 points • 491 views
0 votes
1 answer

Modify schema in HBase using Programs

HBase schemas can be created or updated ...READ MORE

Aug 9, 2018 in Database by kurt_cobain
 • 9,390 points • 1,033 views
0 votes
1 answer

Access HFile without using Hbase

Yes, it's very much possible to access ...READ MORE

Aug 9, 2018 in Database by kurt_cobain
 • 9,390 points • 672 views
0 votes
1 answer

Thrift in Hbase

Apache Thrift is written in C++ but ...READ MORE

Aug 9, 2018 in Database by kurt_cobain
 • 9,390 points • 821 views
0 votes
1 answer

Failure of moveChunks - MongoDB

No, chunk moves are consistent and deterministic. ...READ MORE

Aug 3, 2018 in Database by kurt_cobain
 • 9,390 points
edited Jun 1, 2023 by Srinath • 650 views
0 votes
1 answer

Connection Mongos check - MongoDB

The following command needs to be used ...READ MORE

Aug 3, 2018 in Database by kurt_cobain
 • 9,390 points
edited Jun 1, 2023 by Srinath • 992 views
0 votes
1 answer

Filters in HBase

ColumnPrefixFilter: takes a single argument, a column ...READ MORE

Jul 31, 2018 in Database by kurt_cobain
 • 9,390 points • 6,881 views
0 votes
1 answer

Compaction HBase

Compaction is a process which is used ...READ MORE

Jul 31, 2018 in Database by kurt_cobain
 • 9,390 points • 588 views
0 votes
1 answer

Locking or Transactions MongoDB

MongoDB does not use conventional locking with ...READ MORE

Jul 24, 2018 in Database by shams
 • 3,670 points • 1,201 views
0 votes
1 answer

Why is MongoDB preferred?

MongoDB is considered to be best NoSQL ...READ MORE

Jul 24, 2018 in Database by shams
 • 3,670 points
edited Jun 1, 2023 by Srinath • 742 views
0 votes
1 answer

Delete row in HBase

In Hbase, whatever you write will be ...READ MORE

Jul 24, 2018 in Database by kurt_cobain
 • 9,390 points • 1,762 views
0 votes
1 answer

Key Components of HBase

Zookeeper: It does the co-ordination work between client ...READ MORE

Jul 24, 2018 in Database by kurt_cobain
 • 9,390 points • 1,528 views
0 votes
1 answer

Using Real Time flume Data for Analysis

By using MorphlineSolrSink we can extract, transform ...READ MORE

Jul 17, 2018 in Database by kurt_cobain
 • 9,390 points • 741 views
0 votes
1 answer

Data model operations in Hbase

1. Get(returns attributes for a specified row, Gets ...READ MORE

Jul 16, 2018 in Database by Data_Nerd
 • 2,390 points • 816 views
0 votes
1 answer

HLog and WAL in Hbase.

All edits in the HStore are stored ...READ MORE

Jul 16, 2018 in Database by Data_Nerd
 • 2,390 points • 3,875 views
0 votes
1 answer

Connection in Hbase

Following code is used to open a ...READ MORE

Jul 11, 2018 in Database by Data_Nerd
 • 2,390 points • 595 views
0 votes
1 answer

Standalone Mode in Hbase

It is a default mode of HBase. ...READ MORE

Jul 11, 2018 in Database by kurt_cobain
 • 9,390 points • 1,444 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.