Most viewed questions in Database

0 votes
2 answers

Advantages and Disadvantages of Stored Procedure

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

Apr 29 in Database by anonymous
4,394 views
+1 vote
1 answer

Difference between cross join and natural join

The cross join produces the cross product ...READ MORE

Oct 12, 2018 in Database by DataKing99
• 8,130 points
2,393 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 darklord
• 6,170 points
2,348 views
0 votes
2 answers

MySQL "Could not create connection to database serve" error

When I am trying to connect netbeans ...READ MORE

Apr 14 in Database by anonymous

edited Apr 15 by Kalgi 2,106 views
0 votes
1 answer

Different subsets of SQL

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

Sep 28, 2018 in Database by darklord
• 6,170 points
1,932 views
0 votes
1 answer

Difference between primary key a composite key

Primary key is that column of the table ...READ MORE

Sep 5, 2018 in Database by CodingByHeart77
• 3,690 points
1,612 views
0 votes
3 answers

What is Phantom deadlock?

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

Feb 13 in Database by Ravi kumar
1,455 views
0 votes
2 answers

Durable Writes in Cassandra

When Cassandra write: 1. memtable (in memory) 2. commit ...READ MORE

Nov 25, 2018 in Database by Amit
• 180 points
1,339 views
0 votes
1 answer

What does recursive stored procedure?

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

Sep 26, 2018 in Database by darklord
• 6,170 points
1,298 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,810 points
1,119 views
0 votes
1 answer

What are VDL and SDL?

VDL(View Definition Language): Represents user views and ...READ MORE

Nov 13, 2018 in Database by DataKing99
• 8,130 points
1,015 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,260 points
807 views
0 votes
1 answer

Difference between STUFF & REPLACE function

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

Oct 10, 2018 in Database by CodingByHeart77
• 3,690 points
725 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,260 points
642 views
0 votes
1 answer

What are the manipulation functions in SQL?

There are three case manipulation functions in ...READ MORE

Oct 11, 2018 in Database by DataKing99
• 8,130 points
602 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,360 points
536 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,260 points
522 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,130 points
434 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,130 points
394 views
0 votes
1 answer

What is DML Compiler?

DML compiler translates DML statements in a ...READ MORE

Nov 9, 2018 in Database by darklord
• 6,170 points
388 views
0 votes
1 answer

Install DB2 on windows

Hey @Alok, follow these instructions: On the DB2 ...READ MORE

Mar 20 in Database by Kavyashri
383 views
0 votes
1 answer

What is DDL interpreter?

DDL Interpreter interprets the DDL statements and ...READ MORE

Nov 8, 2018 in Database by DataKing99
• 8,130 points
359 views
0 votes
1 answer

What is Index hunting?

Index hunting is the process of boosting ...READ MORE

Nov 9, 2018 in Database by DataKing99
• 8,130 points
358 views
+1 vote
1 answer

What are the features of MySQL?

The features of MySQL are as follows: Ease ...READ MORE

Dec 12, 2018 in Database by DataKing99
• 8,130 points
326 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 26, 2018 in Database by darklord
• 6,170 points
316 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 darklord
• 6,170 points
310 views
0 votes
1 answer

What are the advantages of SQL?

Simple SQL queries can be used to ...READ MORE

Nov 8, 2018 in Database by DataKing99
• 8,130 points
295 views
0 votes
1 answer

MSSQL installation fails at mssql-conf setup

Hi @Denis!  The problem has occurred due to the ...READ MORE

Mar 21 in Database by Omkar
• 67,600 points
292 views
0 votes
1 answer

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by darklord
• 6,170 points
292 views
0 votes
1 answer

Table design approach Hbase

Tall-Narrow and Flat-Wide are the two HBase ...READ MORE

Jul 10, 2018 in Database by Data_Nerd
• 2,360 points
264 views
0 votes
1 answer

Unable to uninstall MongoDB

Try apt-get --reinstall install mongodb This will pretend that ...READ MORE

Mar 15 in Database by Jobin
263 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

Oct 25, 2018 in Database by Frankie
• 9,810 points
252 views
0 votes
1 answer

What is subquery in SQL?

A subquery is a query inside another ...READ MORE

Oct 12, 2018 in Database by DataKing99
• 8,130 points
235 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,690 points
222 views
0 votes
1 answer

What are set operations used in database?

There are mainly three set operations: UNION, ...READ MORE

Nov 19, 2018 in Database by darklord
• 6,170 points
218 views
0 votes
1 answer

Delete row in HBase

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

Jul 23, 2018 in Database by kurt_cobain
• 9,260 points
204 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,690 points
200 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 darklord
• 6,170 points
189 views
+1 vote
2 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

Sep 25 in Database by gautham
185 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

Dec 14, 2018 in Database by DataKing99
• 8,130 points
180 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,690 points
175 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,260 points
162 views
0 votes
1 answer

Database Repair Options in Cassandra

Anti Entropy: Anti-entropy Repair is a process of ...READ MORE

Jun 28, 2018 in Database by kurt_cobain
• 9,260 points
160 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,690 points
158 views
0 votes
1 answer

Python Stress Test

Cassandra comes with a popular utility called ...READ MORE

Jun 29, 2018 in Database by Data_Nerd
• 2,360 points
154 views
0 votes
1 answer

Different types of SQL Joins

The 4 main kinds of Joins present ...READ MORE

Sep 7, 2018 in Database by DataKing99
• 8,130 points
151 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,130 points
145 views
0 votes
1 answer

What are the different types of index?

There are three types of index namely: Unique ...READ MORE

Oct 17, 2018 in Database by darklord
• 6,170 points
138 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,130 points
131 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,690 points
123 views