Trending questions in Database

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 Sahiti
• 6,370 points
5,979 views
0 votes
0 answers

How to install Oracle DB on ubuntu?

Can anyone help me with the step ...READ MORE

Feb 28, 2019 in Database by Sukanya Rajput
1,645 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,250 points
6,232 views
+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

Dec 12, 2018 in Database by DataKing99
• 8,250 points
4,631 views
0 votes
0 answers

define storing process

Feb 21, 2019 in Database by anonymous
1,532 views
0 votes
1 answer

What is DML Compiler?

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

Nov 9, 2018 in Database by Sahiti
• 6,370 points
5,836 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

Jan 4, 2019 in Database by Priyaj
• 58,020 points
3,005 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,250 points
6,643 views
0 votes
0 answers

Different between mongoDB and Postgresql

Any one can you explain different between ...READ MORE

Feb 8, 2019 in Database by Ajay
1,462 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,250 points
3,719 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
8,321 views
0 votes
1 answer

Can I have multiple primary keys in a single table?

A Table can have a Composite Primary Key which ...READ MORE

Oct 25, 2018 in Database by Frankie
• 9,830 points
5,226 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,350 points
8,844 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
6,454 views
0 votes
0 answers

What are the most common types Of Datawarehouse?

Jan 16, 2019 in Database by hemant
• 5,790 points
1,196 views
+1 vote
1 answer

What is the AND operator?

The AND operator is used to filter ...READ MORE

Dec 1, 2018 in Database by Sahiti
• 6,370 points
3,080 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
5,943 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,991 views
0 votes
1 answer

DateTime serialization best practices in .NET 3.5

One of the best ways to do ...READ MORE

Dec 17, 2018 in Database by DataKing99
• 8,250 points
2,198 views
0 votes
1 answer

What is the NOT Operator in MySQL?

NOT operator displays a record when the ...READ MORE

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

Accessing connection from different class in Java / MySQL?

You should just instantiate DoComms with every ...READ MORE

Nov 14, 2018 in Database by nirvana
• 3,090 points
3,312 views
0 votes
0 answers

How to secure email ?

do you think how to secure email ...READ MORE

Dec 21, 2018 in Database by hill
• 120 points

edited Jan 7, 2019 by hill 1,752 views
0 votes
1 answer

What are the advanced MySQL Wokrbench capabilities?

Advanced MySQL Capabilities Provides an extension system that ...READ MORE

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

What are the steps performed by Migration Wizard while migrating a database to MySQL?

The following are the steps  performed by ...READ MORE

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

What are the various MySQL Workbench editions?

MySQL Workbench is mainly available in three ...READ MORE

Dec 6, 2018 in Database by CodingByHeart77
• 3,750 points
2,073 views
0 votes
1 answer

What is the EXISTS operator?

Exists operator is used to test if ...READ MORE

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

Aggregate Functions in MySQL

The aggregate functions are as follows: MIN() Function This ...READ MORE

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

What are the MySQL Enterprise Backup operations available from MySQL Workbench?

There are mainly two MySQL Enterprise Backup ...READ MORE

Dec 6, 2018 in Database by CodingByHeart77
• 3,750 points
1,950 views
0 votes
1 answer

What are the various levels of constraints

Constraints are the representation of a column ...READ MORE

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

MySQL Workbench Functionalities

The functionalities of MySQL Workbench are as ...READ MORE

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

List all the types of user-defined functions

There are three types of user-defined functions, ...READ MORE

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

What is the syntax of SELECT statement?

This statement is used to select data ...READ MORE

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

What are Joins?

JOINS are used to combine rows from ...READ MORE

Dec 14, 2018 in Database by DataKing99
• 8,250 points
1,323 views
0 votes
1 answer

What is MySQL Workbench?

MySQL Workbench is a designing or a ...READ MORE

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

what is the syntax of OR statement in MySQL?

The OR operator displays those records which ...READ MORE

Dec 1, 2018 in Database by Sahiti
• 6,370 points
1,760 views
0 votes
1 answer

What is the syntax of USE statement in MySQL?

The USE statement is used to mention ...READ MORE

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

What is the UPDATE command in MySQL?

This statement is used to modify the ...READ MORE

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

What is a Join in terms of database?

JOINS are used to combine rows from ...READ MORE

Nov 13, 2018 in Database by DataKing99
• 8,250 points
2,424 views
0 votes
1 answer

What is SELECT DISTINCT statement

This statement is used to return only ...READ MORE

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

Constraints Used In Database

Refer to the image below: READ MORE

Nov 15, 2018 in Database by DataKing99
• 8,250 points
2,239 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,830 points
3,118 views
0 votes
1 answer

What is the ALTER command in MySQL?

ALTER The ALTER command is used to add, ...READ MORE

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

What is the ORDER BY statement in MySQL?

This statement is used to sort the ...READ MORE

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

What is GRANT in MySQL?

This command is used to provide user ...READ MORE

Nov 23, 2018 in Database by Sahiti
• 6,370 points
1,783 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
4,772 views
0 votes
1 answer

What is GROUP BY statement in MySQL?

This statement is used with the aggregate ...READ MORE

Nov 23, 2018 in Database by Sahiti
• 6,370 points
1,614 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,750 points
3,508 views
0 votes
1 answer

Different types of a subquery

There are two types of subquery namely, ...READ MORE

Oct 18, 2018 in Database by DataKing99
• 8,250 points
3,161 views
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,736 views
0 votes
1 answer

What is REVOKE in MySQL?

This command is used to withdraw user’s ...READ MORE

Nov 23, 2018 in Database by Sahiti
• 6,370 points
1,627 views