Most answered questions in Database

0 votes
1 answer

Auto Increment in SQL

Auto increment keyword allows the user to ...READ MORE

Sep 28, 2018 in Database by DataKing99
• 8,240 points
419 views
0 votes
1 answer

STUFF and REPLACE function in SQL

STUFF Function: This function is used to ...READ MORE

Sep 28, 2018 in Database by DataKing99
• 8,240 points
1,462 views
0 votes
1 answer

What does recursive stored procedure?

Recursive stored procedure refers to a stored ...READ MORE

Sep 27, 2018 in Database by Sahiti
• 6,370 points
14,816 views
0 votes
1 answer

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

Sep 27, 2018 in Database by Sahiti
• 6,370 points
11,856 views
0 votes
1 answer

ACID property in a database

ACID stands for Atomicity, Consistency, Isolation, Durability. It ...READ MORE

Oct 8, 2018 in Database by Sahiti
• 6,370 points
1,589 views
0 votes
1 answer

IN vs OR in the SQL WHERE Clause

I assume you want to know the ...READ MORE

Sep 24, 2018 in Database by DataKing99
• 8,240 points
3,509 views
0 votes
1 answer

Reset a sequence in Oracle

You can try out something like this create ...READ MORE

Sep 24, 2018 in Database by DataKing99
• 8,240 points
4,559 views
0 votes
1 answer

Logical and Physical Plan : PIG Script

Logical and Physical plans are created during ...READ MORE

Sep 12, 2018 in Database by kurt_cobain
• 9,390 points
3,147 views
0 votes
1 answer

Debugging tools: PIG

explain utility is helpful for Hadoop developers ...READ MORE

Sep 12, 2018 in Database by kurt_cobain
• 9,390 points
1,094 views
0 votes
1 answer

Can different databases use different name quotes?

This use of quotes is called delimited ...READ MORE

Sep 11, 2018 in Database by CodingByHeart77
• 3,740 points
519 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

Sep 11, 2018 in Database by CodingByHeart77
• 3,740 points
28,836 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,119 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

Sep 10, 2018 in Database by Sahiti
• 6,370 points
12,715 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

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

Difference between Inner Join & Outer Join

The difference is as follows: INNER JOIN: Returns all those ...READ MORE

Sep 7, 2018 in Database by DataKing99
• 8,240 points
1,407 views
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,240 points
691 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,740 points
964 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,738 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
420 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,740 points
629 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,740 points
5,489 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
622 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
457 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,387 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
849 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,740 points
1,991 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
657 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,740 points
1,126 views
+1 vote
1 answer

DELETE vs TRUNCATE vs DROP command

After the execution of ‘DELETE’ operation, COMMIT ...READ MORE

Aug 23, 2018 in Database by CodingByHeart77
• 3,740 points
1,879 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,240 points
2,573 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,240 points
6,970 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
798 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
593 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
887 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
805 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,740 points
517 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,740 points
1,439 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,240 points
459 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,240 points
704 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,740 points
649 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,740 points
3,219 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,095 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,240 points
2,358 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,240 points
691 views
+1 vote
1 answer

Cursor and Its Types

The cursor is a temporary work area ...READ MORE

Aug 9, 2018 in Database by CodingByHeart77
• 3,740 points
686 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
419 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
894 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
577 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
705 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 449 views