Most voted questions in Database

0 votes
1 answer

Collation in Database

Collation is defined as a set of ...READ MORE

Oct 9, 2018 in Database by DataKing99
 • 8,250 points • 765 views
0 votes
2 answers

Advantages and Disadvantages of Stored Procedure

https://www.quora.com/What-are-the-advantages-of-using-an-SQL-store ...READ MORE

Apr 29, 2019 in Database by anonymous
 • 20,635 views
0 votes
1 answer

Clause in SQL

SQL clause helps to limit the result ...READ MORE

Oct 8, 2018 in Database by DataKing99
 • 8,250 points • 848 views
0 votes
1 answer

What is Normalization of database?

Normalization is the process of organizing data ...READ MORE

Oct 8, 2018 in Database by DataKing99
 • 8,250 points • 1,408 views
0 votes
1 answer

ORA-12514 TNS:listener does not currently know the service requested in connect descriptor

I had this issue and the fix ...READ MORE

Oct 8, 2018 in Database by Frankie
 • 9,830 points • 18,556 views
0 votes
1 answer

How do I enable Oracle automatically on systemboot?

To enable the database service to start ...READ MORE

Oct 5, 2018 in Database by Frankie
 • 9,830 points • 930 views
0 votes
1 answer

Difference between clustered and non clustered index in SQL

The differences between the clustered and non ...READ MORE

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

Different subsets of SQL

The various subsets of SQL are as ...READ MORE

Sep 28, 2018 in Database by Sahiti
 • 6,370 points • 27,530 views
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,250 points • 769 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,250 points • 1,847 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 • 15,689 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 • 13,443 views
0 votes
2 answers

Write a SQL query to find the names of employees that begin with ‘S’

Select ename From emp Where ename like"s%"; READ MORE

Oct 7, 2021 in Database by anonymous
 • 28,220 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

Aug 20, 2020 in Database by Okugbe
 • 280 points • 4,375 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,968 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,250 points • 4,429 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,250 points • 5,377 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,350 points • 3,739 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,350 points • 1,600 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,750 points • 856 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,750 points • 30,209 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,555 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 • 13,206 views
0 votes
2 answers

Different types of SQL Joins

There are 4 types of joins in ...READ MORE

Dec 9, 2020 in Database by bhavani
 • 2,326 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,250 points • 1,527 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,250 points • 1,987 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,250 points • 1,096 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,343 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,794 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 • 2,053 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 • 764 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 • 1,102 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 • 6,057 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,350 points • 1,084 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,350 points • 819 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,350 points • 1,723 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,350 points • 1,169 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
 • 10,274 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,660 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,350 points • 1,134 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,675 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 • 3,451 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,407 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,350 points • 1,272 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,350 points • 1,184 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,350 points • 1,288 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,350 points • 1,379 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 • 803 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,906 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 • 787 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.