Databases Interview Questions
Questions Answers Views Company eMail

Explain about ur projets on teradata???



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



what is try_catch block in procedure


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


What is AUTH_ID and AUTH_USER in pl/sql ?



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,


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


3 996

how to write customizations in po

Ernst Young,


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


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


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


What is Lock table in SQL?



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


Un-Answered Questions { Databases }

when MSQL8.0 is in market


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


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


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.




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.


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


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


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


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


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.


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


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


where the connection string store in the database


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?