Trending questions in Database

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 • 938 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 • 3,999 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 • 843 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 • 476 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 • 1,200 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 • 1,074 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 • 2,808 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 • 2,289 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 • 704 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 • 1,085 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 • 737 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 • 767 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 • 796 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 • 675 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 • 813 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 • 1,087 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 • 716 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 • 578 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 • 709 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 • 679 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 • 1,089 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 • 1,852 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 • 695 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 • 651 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 • 2,410 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 • 886 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 • 598 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 • 786 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,490 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 • 1,902 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 • 556 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,250 points • 1,977 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 • 1,230 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 • 1,331 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 • 1,892 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 • 1,016 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 • 1,519 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 • 800 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,770 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 • 3,764 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 • 783 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 • 1,852 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 • 1,155 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 • 669 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,258 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 • 870 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,626 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,335 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 • 1,004 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,075 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.