Most voted questions in Database

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,027 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 • 1,905 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 • 601 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 • 3,346 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,613 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 • 9,808 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,240 points • 1,037 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,240 points • 736 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,240 points • 614 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,240 points • 515 views
0 votes
1 answer

Fetch first 5 characters of the string

There are a lot of ways to ...READ MORE

Oct 22, 2018 in Database by DataKing99
 • 8,240 points • 5,567 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,240 points • 2,603 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,240 points • 1,508 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 • 7,968 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 • 696 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,240 points • 22,838 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,240 points • 1,533 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 • 966 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,586 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,240 points • 5,015 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,240 points • 1,157 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 • 823 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,740 points • 2,089 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 • 608 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,240 points • 455 views
0 votes
2 answers

Advantages and Disadvantages of Stored Procedure

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

Apr 29, 2019 in Database by anonymous
 • 19,771 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,240 points • 474 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,240 points • 1,057 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 • 17,559 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 • 515 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,574 views
0 votes
1 answer

Different subsets of SQL

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

Sep 28, 2018 in Database by Sahiti
 • 6,370 points • 26,605 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,240 points • 392 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,240 points • 1,414 views
0 votes
1 answer

What does recursive stored procedure?

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

Sep 27, 2018 in Database by Sahiti
 • 6,370 points • 14,715 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 27, 2018 in Database by Sahiti
 • 6,370 points • 11,619 views
0 votes
2 answers

Write a SQL query to find the names of employees that begin with ‘S’

Select ename From emp Where ename like"s%"; READ MORE

Oct 7, 2021 in Database by anonymous
 • 25,540 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

Aug 20, 2020 in Database by Okugbe
 • 280 points • 3,622 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,512 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,240 points • 3,395 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,240 points • 4,462 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,390 points • 3,023 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,390 points • 1,040 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,740 points • 481 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

Sep 11, 2018 in Database by CodingByHeart77
 • 3,740 points • 28,523 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,073 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 Sahiti
 • 6,370 points • 12,662 views
0 votes
2 answers

Different types of SQL Joins

There are 4 types of joins in ...READ MORE

Dec 9, 2020 in Database by bhavani
 • 1,791 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,240 points • 964 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,240 points • 1,321 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.