Category Archives: Database

Programming phone screen questions

kSquared at GameDev community forums posted a list of phone screen questions from Google, with some answers that he attempted. You’ll have to head to GameDev to read the answers, but here’s the list of questions to ponder:

You are shrunk to the height of a nickel and your mass is proportionally reduced so as to [...]

Also posted in General, Puzzles | 18 Comments

SQL interview questions and answers

What are two methods of retrieving SQL?
What cursor type do you use to retrieve multiple recordsets?
What is the difference between a "where" clause and a "having" clause? - "Where" is a kind of restiriction statement. You use where clause to restrict all the data from DB.Where clause is using before result retrieving. But [...]

Also posted in Windows | 3 Comments

Amazon interview questions

Given a Binary Search Tree, write a program to print the kth smallest element without using any static/global variable. You can’t pass the value k to any function also.
What are the 4 basics of OOP?
Define Data Abstraction. What is its importance?
Given an array of size n. It contains numbers in the range 1 to n. [...]

Also posted in C++, General | 12 Comments

10 questions on MySQL speed-up and optimizations

Jay Pipes, author of Pro MySQL, on his blog posts 10 questions and answers dealing with MySQL speed optimizations.

Which will be faster out of these two queries - one with OR or one with IN?
Where does MyISAM cache table records?
Which will be faster out of queries with explicit INNER JOIN and implicit one?
Is InnoDB faster/better [...]

Also posted in Web dev | 1 Comment

MySQL management interview questions

How do you show the currently running queries? - SHOW FULL PROCESSLIST;
How do you kill a MySQL query? - See the ID of it from the question above, then KILL id. You can separate multiple IDs by space.
I need to find out how many client connections were aborted by MySQL server. - It’s displayed in [...]

Also posted in Unix/Linux | Leave a comment

DBA Interview Questions and Answers

Sean Hull wrote a few interview questions for Database Journal dealing mostly with Oracle:
- Why is a UNION ALL faster than a UNION?
- What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually?
- What are three rules of thumb to create good passwords? How would a DBA enforce those [...]

Posted in Database | 4 Comments

25 SAP ABAP interview questions with no answers

What are the various compoents of SAP XI?
Define Integaration Builder.
What is Software Component Version.
Explain IR and ID.
What is data type, message type, Message Interface, etc.
What is context handling?

Also posted in General, SAP ABAP | 6 Comments

SQL study notes

SQL
SQL is an English like language consisting of commands to store, retrieve, maintain & regulate access to your database.
SQL*Plus
SQL*Plus is an application that recognizes & executes SQL commands & specialized SQL*Plus commands that can customize reports, provide help & edit facility & maintain system variables.

Posted in Database | 2 Comments

EDS Visual Basic and SQL Server interview questions

What is the difference between modal and modaless form in VB?
Why we need a MDI form? How can we make a form as a mdichild form?
Specify technical & functional architecture of your last 2 projects.
What are the objects in ADODB?
What are different types of cursors in ADODB?
What are different types of locks in ADODB?
What is [...]

Also posted in VB, Windows | 25 Comments

11 advanced MySQL questions

Explain MySQL architecture. - The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party [...]

Posted in Database | Leave a comment

31 more MySQL questions

What is DDL, DML and DCL? - If you look at the large variety of SQL commands, they can be divided into three large subgroups. Data Definition Language deals with database schemas and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL. [...]

Posted in Database | 7 Comments

29 MySQL interview questions

How do you start and stop MySQL on Windows? - net start MySQL, net stop MySQL
How do you start MySQL on Linux? - /etc/init.d/mysql start
Explain the difference between mysql and mysqli interfaces in PHP? - mysqli is the object-oriented version of mysql library functions.
What’s the default port for MySQL Server? - 3306
What does tee command [...]

Posted in Database | 6 Comments