Databases Interview Questions
Questions Answers Views Company eMail

Explain about ur projets on teradata???

Wipro,

673

what is checksum in sql server.........???

TCS,

432

what is try_catch block in procedure

477




how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 620

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

351

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

651

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

United Healthcare,

407

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

ICICI,

3 996

how to write customizations in po

Ernst Young,

430

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

CTS,

1 526

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

Societe Generale,

1 1276

how to handle exceptions in post production

252

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

360

What is Lock table in SQL?

Wipro,

311

How to get maxsal , minsal, ename department wise in single query

278







Un-Answered Questions { Databases }

when MSQL8.0 is in market

892


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

962


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

1044


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

806


WHAT KIND OF TOOL BO IS?

1148






london school of science and technology has a software development unit,known as lsst solutions,which is responsible for developing and implementing software throughout the collegejames tristan keeps a record of all student details in the college including student id,name,and start date and phone number.There are many courses offered by LSST. For example MBA, MSc, BSc, BABS, DF, English etc. Each course id identified by course id, description, duration. Each course has many semesters. Each semester takes place during a particular term. Semester details and term details are required to be stored in the database. Each course has many subjects and same subject may be offered in many courses. For each subject many details such as Subject code, name, result and attendance are required to be stored. Every subject has mainly two assessments; one assignment and one exam. Assignment is worth of 30% and exam 70% respectively. You have been appointed as a database designer. Your job is to provide ERD with all possible entities and relationships. Note: Feel free to make necessary assumptions 3: Assignment Tasks. 1. Create an ERD for the above problem 2. Translate the ERD to Relational Data model (RDM) 3. Implement the RDM by creating the tables 4. Populate the database with your own data. 5. SQL Queries for the following tasks a. List all student details in each course along with course details b. Count and display number of students in each course. c. List student name, course name, assessment description, marks for all students.

1332


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

926


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

852


I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

541


what is difference between sql plus and sql*plus? (not sql and sql plus).

2607


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2196


Explain Capacity planning to create a database? and how to monitor it?

2884


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1049


where the connection string store in the database

858


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

1350