Databases Interview Questions
Questions Answers Views Company eMail

What is the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 10027

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?

1771

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 8689

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2024

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

TCS,

1603

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

1 2549

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

2 4285

how can we store any pdf file in oracle

1638

ow to bring suspect mode datbase online from scratch

1403

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?

1534

When do we create bitmap indexes

CTS,

2 8843

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

Atos Origin,

1778

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

2060

define sql

Zensar,

3 5098

wat new abt truncate in sql server

HCL, HP,

2 5568


Un-Answered Questions { Databases }

What is dba in dbms?

539


What is the difference between the implicit and explicit cursors?

523


Why functions are used in sql server?

502


What is bcnf normalization form?

659


What is pl sql variable?

502






What are the informix isolation levels?

35


How do I connect to pgadmin server?

421


What are the advantages of stored procedure in sql server?

463


As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

617


What is microsoft access made up of?

440


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

611


How to drop an existing table in oracle?

589


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

555


how will add additional conditions in sql?

574


How can windows applications connect to oracle servers?

518