Databases Interview Questions
Questions Answers Views Company eMail

What is the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 9999

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1764

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 8655

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2016

how can we view column head in first page but not in remaining pages?

TCS,

1597

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 2519

What is the sql query to find the employee who has Nth maximum salary?

2 4265

how can we store any pdf file in oracle

1630

ow to bring suspect mode datbase online from scratch

1395

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1527

When do we create bitmap indexes

CTS,

2 8828

if i want to display the name of students such that to which city they belong must have count greaer than two

Atos Origin,

1770

How to read and create .LDC data files which are used by linguatic dictionary.

2047

define sql

Zensar,

3 5074

wat new abt truncate in sql server

HCL, HP,

2 5539


Un-Answered Questions { Databases }

How many columns can exist together per table?

699


Can we store images in mysql database?

470


Which function is used to return remainder in a division operator in sql?

574


how to extract a unit value from a date and time? : Sql dba

546


Why we need sql server?

546






Explain force logging feature in 9i.

284


What is oracle rowcount?

564


How to join two tables in a single query in ms sql server?

530


What is set serveroutput on in pl sql?

563


Why do we use the mysql database server?

526


What is rank in database?

494


Explain drop constraint oracle?

585


What is crud in mongodb?

1


what are the types of subquery? : Sql dba

577


What is the difference between pl and sql?

535