Most answered questions in Database

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 • 764 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 • 709 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,207 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 • 792 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 • 651 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 Sahiti
 • 6,370 points • 3,680 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

Nov 19, 2018 in Database by Sahiti
 • 6,370 points • 6,051 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 • 662 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,174 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,130 points • 2,170 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 • 919 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 • 1,008 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,241 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,250 points • 10,960 views
0 votes
1 answer

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

Record is the collection of fields, possibly ...READ MORE

Oct 6, 2021 in Database by Adebayo fikayo
edited Mar 5 • 22,490 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 • 5,109 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 • 4,808 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,250 points • 6,050 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,250 points • 5,777 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,325 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,379 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 • 868 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 • 4,025 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,928 views
0 votes
1 answer

How to schedule a job for SQL query to run daily?

down voteaccepted Expand the SQL Server Agent node ...READ MORE

Oct 25, 2018 in Database by Frankie
 • 9,830 points • 10,314 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,401 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,080 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 • 850 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 • 713 views
0 votes
1 answer

Fetch first 5 characters of the string

Select StudentID, StudentName, Class, Division from Student order ...READ MORE

Jun 4, 2021 in Database by Dheeraj
edited Mar 5 • 5,999 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,875 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 • 2,023 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 Sahiti
 • 6,370 points • 8,430 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 • 895 views
0 votes
1 answer

Which operator is used in the query for pattern matching?

LIKE operator is used for pattern matching, ...READ MORE

Oct 15, 2018 in Database by DataKing99
 • 8,250 points • 24,137 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 • 2,124 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,250 points • 16,722 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,233 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,971 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 • 5,621 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,599 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,078 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,494 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 • 914 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 • 700 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 • 779 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,318 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,374 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 • 838 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,953 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.