Trending questions in Database

0 votes
1 answer

What is ANY operator?

Similar to the ALL operator, the ANY ...READ MORE

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

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

Oct 29, 2018 in Database by Sahiti
 • 6,370 points • 2,751 views
0 votes
1 answer

What is HAVING Clause in MySQL?

Since the WHERE keyword cannot be used with aggregate ...READ MORE

Nov 21, 2018 in Database by Sahiti
 • 6,370 points • 1,751 views
0 votes
1 answer

Comments in MySQL

Like any other programming language, there are ...READ MORE

Nov 26, 2018 in Database by DataKing99
 • 8,250 points • 1,529 views
0 votes
1 answer

What is Database transaction?

The sequence of operation performed which changes ...READ MORE

Nov 14, 2018 in Database by Sahiti
 • 6,370 points • 2,027 views
0 votes
1 answer

What do you understand by Database Triggers?

A set of commands that automatically get ...READ MORE

Nov 14, 2018 in Database by Sahiti
 • 6,370 points • 1,968 views
0 votes
1 answer

Which one is suitable for real time big database- Primary Key or Unique Index?

What is a unique index? A unique index ...READ MORE

Oct 12, 2018 in Database by Frankie
 • 9,830 points • 3,381 views
0 votes
1 answer

Can someone tell me what is IS NULL operator

Since it is not possible to test ...READ MORE

Nov 20, 2018 in Database by DataKing99
 • 8,250 points • 1,598 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 • 5,498 views
0 votes
1 answer

List the ways in which Dynamic SQL can be executed

Following are the ways in which dynamic ...READ MORE

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

What are nested queries?

Nested queries are those queries which have an ...READ MORE

Nov 15, 2018 in Database by DataKing99
 • 8,250 points • 1,589 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 • 5,068 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 • 3,411 views
0 votes
1 answer

Different Types Of Index

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

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

What is the need of MERGE statement?

This statement allows conditional update or insertion of ...READ MORE

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

How to connect to MySQL Database?

using MySql.Data; using MySql.Data.MySqlClient; namespace Data { ...READ MORE

Oct 12, 2018 in Database by Frankie
 • 9,830 points • 2,587 views
0 votes
1 answer

What is a Relationship and what are they?

Relation or links are between entities that ...READ MORE

Oct 23, 2018 in Database by DataKing99
 • 8,250 points • 2,076 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 • 2,972 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 • 3,787 views
0 votes
1 answer

What is a Foreign key?

Foreign key maintains referential integrity by enforcing ...READ MORE

Oct 26, 2018 in Database by Sahiti
 • 6,370 points • 1,805 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 • 4,773 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 • 2,527 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 • 2,959 views
0 votes
1 answer

Is there any boolean type in Oracle database?

Nope. I don't think there is one But ...READ MORE

Oct 10, 2018 in Database by Neha
 • 6,300 points • 2,338 views
0 votes
1 answer

What is a covered Index?

A covering index is an index that contains all ...READ MORE

Oct 10, 2018 in Database by Frankie
 • 9,830 points • 2,242 views
0 votes
1 answer

What is an ALIAS command?

The ALIAS name can be given to ...READ MORE

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

What is Denormalization?

Denormalization refers to a technique which is ...READ MORE

Oct 17, 2018 in Database by Sahiti
 • 6,370 points • 1,794 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 • 3,858 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 • 2,113 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 • 3,300 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 • 3,187 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 • 1,837 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 • 5,398 views
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 • 1,659 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 • 3,127 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 • 2,744 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 • 1,794 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,750 points • 3,219 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 • 3,783 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 • 2,884 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 • 2,485 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 • 2,208 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 • 2,428 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 • 2,981 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 • 2,729 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 • 2,710 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 • 2,206 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 • 2,565 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 • 2,690 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 • 2,213 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.