Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 16867

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 62283

What are inner join and outer join?

3 8674




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 62724

what are Triggers?

TCS,

5 8925

what are stored procedures?

TCS,

6 7206

what are indexes..how many types of index's are there and what are they?

TCS, Green Info Solutions,

7 12237

what are views?

TCS,

7 13770

what is web server?

Satyam,

3 8238

What are functions

3 6417

What are the different table present in MYsql?

3 8683

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 8527

what is the difference between oracle 81,91,11i

Oracle, i2,

2 15018

How client makes connection with server in client/server architecture?

CA,

1 2725

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 3290







Un-Answered Questions { Databases }

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1245


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

956


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

851


What is the recommended interval at which to run statspack snapshots, and why?

1685


WHAT IS CARDINALITIES OF JOIN?

1281






please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

6707


1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

890


What is normalization? Explain different levels of normalization?

54366


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2507


how report can be generated if we have the database designed in oracle 10g?

870


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

1278


How can we expand Parameter Form Canvas on Reports 6i?

1327


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.

1401


Is it possible to insert comments into sql statements return in the data model editor ?

1333


what is reindexing?

455