Cracking the Coding Interview: 70 Database Questions and by Chinmoy Mukherjee

Posted by

By Chinmoy Mukherjee

We current 70 fascinating database interview questions and solutions for readers to perform and crack any database interview. The reader is inspired to aim to resolve those questions himself/herself prior to checking the solutions.

Show description

Read Online or Download Cracking the Coding Interview: 70 Database Questions and Answers PDF

Similar hacking books

Hacking for dummies

Excellent intro to tools/methods used for simple hacking. no longer entire for CEH prep, as they do not speak about IDS/IPS or different protecting measures any. No coding, essentially instruments and their utilization. An easy-to-read primer.

eBay Hacks: 100 Industrial-Strength Tips and Tools

Need to know how most sensible to exploit eBay? even if you are a newcomer or longtime consumer, eBay Hacks will educate you to develop into effective as either a purchaser and vendor. you will find a variety of themes, from tracking the bidding strategy, getting refunds, and solving pictures in order that sale goods glance their most sensible, to in-depth suggestions for working a enterprise on eBay and writing scripts that automate one of the most tedious initiatives.

Google Maps Hacks

Are looking to locate each pizza position inside of a 15-mile radius? the place the puppy parks are in a brand new city? the main principal assembly position in your category, membership or workforce of neighbors? the most cost effective fuel stations on a day by day foundation? the site of convicted intercourse offenders in a space to which you will be contemplating relocating?

Additional info for Cracking the Coding Interview: 70 Database Questions and Answers

Example text

Write SQL query to fetch all bank account details whose name starts with “Shyam” Answer: Select * from account where name LIKE ‘%Shyam%’; Database Interview Question-33. Write SQL query to fetch top 3 accounts having highest balance Answer: SYBASE: select top 3 * from account order by balance desc; MYSQL: select * from employee order by salary desc limit 1,3 Oracle: select * from employee order by salary where rownum < 3 Database Interview Question-34. Write SQL query to fetch bottom 3 accounts having lowest balance Answer: SYBASE: select top 3 * from account order by balance asc; MYSQL: select * from employee order by salary asc limit 1,3 Oracle: select * from account order by balance asc where rownum<3; Database Interview Question-35.

A. DELETE * FROM SalesData B. DELETE FROM SalesData C. DELETE SalesData D. DELETE ALL SalesData Answer: B Database Interview Question-45. Which of the following SQL clauses is used to select data from 2 or more tables? A. HAVING B. WHERE C. JOIN Answer: JOIN Database Interview Question-46. The INNER JOIN clause… A. returns all rows that have matching value in the field on which the 2 tables are joined. B. returns all rows from 2 tables. C. returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

Deletes all rows from a table C. deletes the table Answer: B Database Interview Question-48. The table columns are also known as Attributes Fields Records Answer: B Database Interview Question-49. The UNION SQL clause can be used with… the SELECT clause only the UPDATE clause only the DELETE and UPDATE clauses none of the other three Answer: A Database Interview Question-50. The HAVING clause can be used only with JOIN clause. INSERT clause SELECT clause DELETE clause. Answer: C Database Interview Question-51.

Download PDF sample

Rated 4.66 of 5 – based on 21 votes