Database Interview Questions
- 0of 0 votes
AnswerIn mapreduce, which type of join is more efficient, map side join or reduce side join and why?
- dhaval0129 July 26, 2011| Report Duplicate | Flag | PURGE
Bloomberg LP Database - 0of 0 votes
AnswersSelect the option that represents the definition of network database model.
- ankit July 14, 2011
Attempts to bring closer interactivity between database administrators and application programmers
Represents the entire information content of the database in only one way
Organizes the data in the form of a tree of records, with each record having one parent record and many children records
Allows each record to have multiple parent and child records, thereby forming a lattice structure| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 1of 1 vote
AnswersWhich one of the following is NOT a referential integrity issue in a relational database where the DEPT column of the EMPLOYEE table is designated as a foreign key into the DEPARTMENT table?
- ankit July 14, 2011
Updating the value of DEPT in a row of EMPLOYEE with a value that is not the primary key of any of the rows in DEPARTMENT
Inserting a new row into DEPARTMENT with a primary key that is not the value of the DEPT column of any row in EMPLOYEE
Deleting a row of DEPARTMENT
Inserting a new row into EMPLOYEE with a DEPT whose value is not the primary key of any of the rows in DEPARTMENT| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 0of 0 votes
AnswersAn organization stores its employee records in a table, “Emp”. This table has various attributes such as First Name, Last Name, Designation and Salary. The organization stores details of the employee's children in another table, “EmpChildren”. The EmpChildren table has attributes like First Name, Last Name, and Birth Date. The Emp table is a parent table and EmpChildren table is a child table. An employee may have many children, but each child will have only one parent.
- ankit July 14, 2011
From the following options, select the type of database model depicted by the above scenario.
Relational model
Network model
Hierarchical model
Object database mode| Report Duplicate | Flag | PURGE
Oracle Developer Program Engineer Database - 0of 0 votes
AnswersI recently attended an interview of this company.
- Aspire April 23, 2011
I was given a problem & I was asked to come out with an approach to solve this problem. I failed to answer, but I wish to know your idea.
The problem is :
You are given 3 machines with same database schema. All the data in these 3 machines are to be copied to a master database.
I was not given any more inputs.
Can anyone share any idea about the approach?
TIA| Report Duplicate | Flag | PURGE
JDA Software Engineer / Developer Database - 0of 0 votes
AnswersFind the oldest customer in your database
- Guest April 20, 2011| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
Answers1st Round interview:
- Harsh April 16, 2011
Asked to write a query which would join 3 tables to query for rows.| Report Duplicate | Flag | PURGE
Goldman Sachs Software Engineer / Developer Database - 0of 0 votes
Answers1st Round interview:
- Harsh April 16, 2011
Stored Proc vs Normal Query. Which is faster and why?| Report Duplicate | Flag | PURGE
Goldman Sachs Software Engineer / Developer Database - 0of 0 votes
AnswersWhat different types of joins are there in SQL?
- A M April 12, 2011| Report Duplicate | Flag | PURGE
A9 Software Engineer / Developer Database - 1of 1 vote
AnswersDesign the ER diagram for a movie rental store.
- Anonymous February 16, 2011| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersYou have 2 entity which have many-to-many relationship. How would you implement tables? How many tables do you need?
- Anonymous February 05, 2011| Report Duplicate | Flag | PURGE
Software Engineer / Developer Database - 0of 0 votes
AnswersWhen you are asked to tune the performance of a SQL query, list the checklist you would do.
- hwei January 07, 2011
Note: you cannot use index.| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersFor any table, say order table, it was loaded some data double. Write a query to list the double loaded records with all columns and double primary key, but each double records only show once.
- hwei January 07, 2011| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersTable:
- hwei January 07, 2011
Order (OrderID, OrderDate)
OrderItem (ItemID, OrderID)
Query:
1. List all orders put yesterday.
2. How many items were ordered yesterday?
3. List all orders which order more than 3 items yesterday.
4. How many orders which order more than 3 items yesterday?| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersHow will you select all name,salary of all employees having 4th highest salary from Employee table.
- Anju December 17, 2010| Report Duplicate | Flag | PURGE
Nivio Technologies Testing / Quality Assurance Database - 0of 0 votes
AnswersWe have a table with two column name and marks. Write a query based on this table which returns grades like if marks if greater than 700, it will be 'A' if it is less than 700 and greater than 500, it will be 'B' OR it will be 'C'. Main point table has only two column.
- muskaan December 10, 2010
If possible please, give me whole query.
Thanks.| Report Duplicate | Flag | PURGE
VMWare Inc Software Engineer / Developer Database - 0of 0 votes
AnswersWrite an SQL query to select the nth row from a table.
- riderchap November 28, 2010
I asked the interviewer that, can I assume say the nth record is based on a primary/unique key column or any column, he said no, the question is just select the nth row.| Report Duplicate | Flag | PURGE
PayPal Database - 0of 0 votes
Answers1. Types of DB intexes
- Cartman October 19, 2010
2. what is index fragmentation| Report Duplicate | Flag | PURGE
Software Engineer / Developer Database - 0of 0 votes
AnswerWhat are joins.what is natural join.
- surath August 23, 2010| Report Duplicate | Flag | PURGE
Ebay Software Engineer / Developer Database - 0of 0 votes
Answersyou have table employee with salary as one column.there are n rows with maximum salary and x rows with minimum salary.(we dont know n and x). display the difference between total sum of minimum salary and total sum of maximum salary.
- surath August 23, 2010| Report Duplicate | Flag | PURGE
Ebay Software Engineer / Developer Database - 0of 0 votes
AnswersWhat would you do if your Stored Procedure starts performing badly overnight?
- Jig August 10, 2010| Report Duplicate | Flag | PURGE
Goldman Sachs Software Engineer / Developer Database - 0of 0 votes
AnswerWhat is normalization?
- Anonymous June 08, 2010
What is outer join?| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswerWhat are prepared statements? what is indexing and also what is sql injection and how do you prevent it.
- Chummi May 11, 2010| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersSQL in general, Having clause, Schema, ER, Denormalization.
- RanTexas April 08, 2010| Report Duplicate | Flag | PURGE
Akamai Software Engineer / Developer Database - 0of 0 votes
AnswerQuestions about - creating a view, what is a cursor used for, what is an index used for, how to create a procedure query
- nobody March 31, 2010| Report Duplicate | Flag | PURGE
USAA Software Engineer / Developer Database