SQL Interview Questions

1. Q. What does SQL stand for?
A. Structured Query Language

2. Q. How do you select all records from the table?
A. Select * from table_name;

3. Q. What is a join?
A. Join is a process of retrieve pieces of data from different sets (tables) and returns them to the user or program as one “joined†collection of data.

4. Q. What kinds of joins do you know? Give examples.
A. We have self join, outer joint (LEFT, RIGHT), , cross-join ( Cartesian product n*m rows returned)
Exp:
outer joint
SELECT Employee.Name, Department. DeptName
FROM Employee, Department
WHERE Employee.Employee_ID = Department.Employee_ID;

cross-join
SELECT * FROM table1, table2;

self join
SELECT e1.name | |’ ‘ | | e2.ename FROM emp e1, emp e2 WHERE e1. emp_no = e2.emp_no;

The following summarizes the result of the join operations:

The result of T1 INNER JOIN T2 consists of their paired rows where the
join-condition is true.
The result of T1 LEFT OUTER JOIN T2 consists of their paired rows where
the join-condition is true and, for each unpaired row of T1, the
concatenation of that row with the null row of T2. All columns derived
from T2 allow null values.
The result of T1 RIGHT OUTER JOIN T2 consists of their paired rows
where the join-condition is true and, for each unpaired row of T2, the
concatenation of that row with the null row of T1. All columns derived
from T1 allow null values.
The result of T1 FULL OUTER JOIN T2 consists of their paired rows and,
for each unpaired row of T2, the concatenation of that row with the null
row of T1 and, for each unpaired row of T1, the concatenation of that row
with the null row of T2. All columns derived from T1 and T2 allow null
values.

5. Q. How do you add record to a table?
A. INSERT into table_name VALUES (‘ALEX’ , 33 , ‘M’);


6. Q. How do you add a column to a table?
A. ALTER TABLE Department
ADD (AGE, NUMBER);

7. Q. How do you change value of the field?
A. UPDATE EMP_table
set number = 200 where item_munber = ‘CD’;

update name_table set status = 'enable' where phone = '4161112222';

update SERVICE_table set REQUEST_DATE = to_date ('2006-03-04 09:29', 'yyyy-mm-dd hh24:MI') where phone = '4161112222';

8. Q. What does COMMIT do?
A. Saving all changes made by DML statements

9. Q. What is a primary key?
A. The column (columns) that has completely unique data throughout
the table is known as the primary key field.

10. Q. What are foreign keys?
A. Foreign key field – is a field that links one table
to another table’s primary or foreign key.

11. Q. What is the main role of a primary key in a table?
A. The main role of a primary key in a data table is to maintain the internal integrity of a data table.

12. Q. Can a table have more than one foreign key defined?
A. A table can have any number of foreign keys defined. It can have only
one primary key defined.

13. Q. List all the possible values that can be stored in a BOOLEAN data field.
A. There are only two values that can be stored in a BOOLEAN data field:
-1(true) and 0(false).

14 Q. What is the highest value that can be stored in a BYTE data field?
A. The highest value that can be stored in a BYTE field is 255. or from -128
to 127. Byte is a set of Bits that represent a single character.
Usually there are 8 Bits in a Byte, sometimes more, depending on how
the measurement is being made. Each Char requires one byte of memory
and can have a value from 0 to 255 (or 0 to 11111111 in binary).

15. Q. How many places to the right of the decimal can be stored in a
CURRENCY data field?
A. The CURRENCY data type can store up to four places to the right of the
decimal. Any data beyond the fourth place will be truncated by Visual
Basic without reporting an error.

16. Q. What is a stored procedure?
A. A procedure is a group of PL/SQL statements that can be called by
a name. Procedures do not return values they perform tasks.

17. Q. Describe how NULLs work in SQL?
A. The NULL is how SQL handles missing values.
Arifthmetic operation with NULL in SQL will return a NULL.

18. Q. What is Normalization?
A. The process of table design is called normalization.

19. Q. What is referential integrity constraints?
A. Referential integrity constraints are rules
that are partnof the table in a database schema.

20. Q. What is Trigger?
A. Trigger will execute a block of procedural code
against the database when a table event occurs.
A2. A trigger defines a set of actions that are performed in response
to an insert, update, or delete operation on a specified table. When
such an SQL operation is executed, in this case the trigger has been
activated.

21. Q. Which of the following WHERE clauses will return only rows
that have a NULL in the PerDiemExpenses column?
A. WHERE PerDiemExpenses <>
B. WHERE PerDiemExpenses IS NULL
C. WHERE PerDiemExpenses = NULL
D. WHERE PerDiemExpenses NOT IN (*)

A. B is correct � When searching for a NULL value in a column, you must
use the keyword IS. No quotes are required around the keyword NULL.

22. Q. You issue the following query:SELECT FirstName FROM
StaffListWHERE FirstName LIKE'_A%'Which names would be
returned by this query? Choose all that apply.
A. Allen
B. CLARK
C. JACKSON
D. David

A. C is correct � Two wildcards are used with the LIKE operator.
The underscore (_) stands for any one character of any
case, and the percent sign (%) stands for any number of
characters of any case including none. Because this string
starts with an underscore rather than a percent sign, it won't
return Allen or Clark because they represent zero and two
characters before the "A". If the LIKE string had been "%A%",
both of these values would have been returned.
David was not returned because all non-wild card characters
are case sensitive. Therefore, only strings
with an uppercase "A" as their second letter are returned


23. Q. Write a SQL SELECT query that only returns each city only once from Students table?
Do you need to order this list with an ORDER BY clause?


A. SELECT DISTINCT City
FROM Students;

The Distinct keyword automatically sorts all data
in ascending order. However, if you want the data
sorted in descending order, you have to use an ORDER BY clause

24. Q. Write a SQL SELECT sample of the concatenation operator.

A. SELECT LastName ||',' || FirstName, City FROM Students;

25. Q. How to rename column in the SQL SELECT query?

A. SELECT LastName ||',' || FirstName
AS "Student Name", City AS "Home City"
"FROM StudentsORDER BY "Student Name"

26. Q. Write SQL SELECT example how you limiting the rows returned with a WHERE clause.

A. SELECT InstructorID, Salary FROM Instructors
WHERE Salary > 5400 AND Salary < 6600;

27. Q. Write SQL SELECT query that returns the first and
last name of each instructor, the Salary,
and gives each of them a number.

A. SELECT FirstName, LastName, Salary,
ROWNUM FROM Instructors;

28. Q. Which of the following functions can be used only with numeric values?
(Choose all that apply.)
A. AVG
B. MIN
C. LENGTH
D. SUM
E. ROUND

A. A and D � Only A and D are correct. The MIN function
works with any character, numeric, or date datatype.
The LENGTH function is a character function that returns
the number of letters in a character value. The ROUND
function works with both numeric and date values.

29. Q. Which function do you use to remove all padded characters
to the right of a character value in a column with a char datatype?
A. RTRIM
B. RPAD
C. TRIM

A. C � The TRIM function is used to remove padded spaces.
LTRIM and RTRIM functions were included in earlier versions
of Oracle, but Oracle 8i has replaced them with a single
TRIM function

30. Q. Which statement do you use to eliminate padded spaces
between the month and day values in a function TO_CHAR(SYSDATE,'Month, DD, YYYY') ?

A. To remove padded spaces, you use the "fm"
prefix before the date element that contains the spaces.
TO_CHAR(SYSDATE,'fmMonth DD, YYYY')

31. Q. Is the WHERE clause must appear always before the GROUP BY clause in SQL SELECT ?

A. Yes.
The proper order for SQL SELECT
clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
Only the SELECT and FROM clause are mandatory.

32. Q. How Oracle executes a statement with nested subqueries?

A. When Oracle executes a statement with nested subqueries,
it always executes the innermost query first. This query passes its
results to the next query and so on until it reaches the outermost query.
It is the outermost query that returns a result set.

33. Q. Which operator do you use to return all of the rows
from one query except rows are returned in a second query?

A. You use the MINUS operator to return all rows from one query except
where duplicate rows are found in a second query. The UNION operator
returns all rows from both queries minus duplicates. The UNION ALL operator
returns all rows from both queries including duplicates.
The INTERSECT operator returns only those rows that exist in both queries.

34. Q. How you will create a column alias? (Oracle 8i)

A. The AS keyword is optional when specifying a column alias.
You must enclose the column alias in double quotes when the alias
contains a space or lowercase letters. If you specify an alias in l
owercase letters without double quotes, the alias will appear in uppercase.

35 Q. Which of the following statements are Data Manipulation Language commands?
A. INSERT
B. UPDATE
C. GRANT
D. TRUNCATE
E. CREATE

A. A and B � The INSERT and UPDATE statements are
Data Manipulation Language (DML) commands.
GRANT is a Data Control Language (DCL) command.
TRUNCATE and CREATE are Data Definition Language (DDL) commands

36. Question. What is Oracle locking?
A. Oracle uses locking mechanisms to protect data from
being destroyed by concurrent transactions.

37. Question. What Oracle lock modes do you know?
A. Oracle has two lock modes: shared or exclusive.
Shared locks are set on database resources so that many transactions
can access the resource.
Exclusive locks are set on resources that ensure
one transaction has exclusive access to the database resource

38. Question. What is query optimization?
A. Query optimization is the part of the query
process in which the database system compares
different query strategies and chooses the one with
the least expected cost

39. Question. What are the main components of Database management systems software.
A. The database management system software includes
components for storage management, concurrency control, transaction
processing, database manipulation interface, database definition interface,
and database control interface.

40. Question. What are the main attributes of database management system?
A. A database management system is composed of five elements: computer hardware, software, data, people (users), and operations procedures.

41. Question. What is transaction?
A. A transaction is a collection of applications
code and database manipulation code bound into an indivisible unit of execution.
it consists from:
BEGIN-TRANSACTION Name
Code
END TRANSACTION Name

42. Question. What databases do you know?
Informix
DB2
SQL
Oracle

43. Question. Explain SQL SELECT example:
select j.FILE_NUM
from DB_name.job j, DB_name.address a
where j.JOB_TYPE ='C'
AND j.COMPANY_NAME = 'TEST6'
AND j.OFFICE_ID = '101'
AND j.ACTIVE_IND = 'Y'
AND a.ADDRESS_STATUS_ID = 'H'
AND a.OFFICE_ID = '101'
AND a.FILE_NUM = j.FILE_NUM order by j.FILE_NUM;

Answer: j and a aliases for table names. this is outer joint select statament from two tables.


44. Q. Describe some Conversion Functions that you know

A. TO_CHAR converts a number / date to a string.
TO_DATE converts a string (representing a date) to a date.

TO_NUMBER converts a character string containing digits to a numeric data type, it accepts one parameter which is a column value or a string literal

45. Q. Describe some Group Functions that you know

A. 1) The COUNT function tells you how many rows were in the result set.
SELECT COUNT(*) FROM TESTING.QA


2) The AVG function tells you the average value of a numeric column.
SELECT MAX(SALARY) FROM TESTING.QA


3) The MAX and MIN functions tell you the maximum and minimum value of a numeric column.
SELECT MIN(SALARY) FROM TESTING.QA


4) The SUM function tells you the sum value of a numeric column.
SELECT SUM(SALARY) FROM TESTING.QA


46. Question. What does DML stand for?
A. DML is Data Manipulation Language statements. (SELECT)

47. Question. What does DDL stand for?
A. DDL is Data Definition Language statements. (CREATE)

48. Question. What does DCL stand for?

A. DCL is Data Control Language statements. (COMMIT)

49. Question: Describe SQL comments.

A. SQL comments are introduced by two consecutive hyphens
(--) and ended by the end of the line.

50. Q. In what sequence SQL statement are processed?

A. The clauses of the subselect are processed in the following sequence (DB2):
1. FROM clause
2. WHERE clause
3. GROUP BY clause
4. HAVING clause
5. SELECT clause
6. ORDER BY clause
7. FETCH FIRST clause

51. Q. Describe TO_DATE function.

A. The TO_DATE function returns a timestamp from a character string
that has been interpreted using a character template.
TO_DATE is a synonym for TIMESTAMP_FORMAT.

52. Question:
In the domain table we have status as a numeric value from 01 to 04 and we
have text definition of these values in the design document.
Write SQL query to see the result as a text definitions that is corresponded
to these values. (DB2)
A. select TB1.member_id, TB1.bu_id, TB1.program, TB2.num,
case TB1.status
when '01' then 'Auto renew'
when '02' then 'Expired'
when '03' then 'Sold'
when '04' then ‘Terminated’

else TB_name.status
end
from DB_name.TB_name1 TB1,
DB_name.TB_name2 TB2
where
TB1.program in ('com', 'org')
and TB1.member_role = '100'
order by TB1.member_id
fetch first 30 rows only

FIFA 09

FIFA09 is coming to you by Electronic Arts. It has got 250 improvements. It has been given a release date of October 2008 for North America and September 2008 for the United Kingdom.

Official Site

Sony Ericsson C905

It`s a camera or a phone..? This new sony ericsson C905 is equipped with 8.1MP camera and design..? Hot !!!

Specifications:
~^~^~^~^~^~^~^~
Size

* 104.0 x 49.0 x 18.0 mm
* 4.1 x 1.9 x 0.7 inches

Weight

* 136.0 g
* 4.8 oz

Available colours

* Night Black
* Ice Silver
* Copper Gold

Screen

* 240x320 pixel
* 262,144 color TFT QVGA

Memory

* Memory Stick Micro™ (M2™) support (2GB M2 in box)
* Phone memory 160MB*

Actual free memory may vary due to phone pre-configuration

Networks

* GSM 850
* GSM 900
* GSM 1800
* GSM 1900
* EDGE
* UMTS 2100
* HSDPA

Camera

* Auto focus
* BestPic™
* Camera - 8.1 megapixel
* Digital Zoom - up to 16x
* Image stabiliser
* PhotoFix
* Picture blogging
* Red-eye reduction
* Video light
* Video record
* Video stabiliser
* Xenon flash

Music

* Album art
* Bluetooth™ stereo (A2DP)
* Media Player
* Music tones - MP3, AAC
* PlayNow™
* TrackID™

Internet

* Access NetFront™ Web Browser

Entertainment

* 3D games
* Java
* Media
* Radio - FM radio RDS
* Video Clip
* Video streaming

Connectivity

* aGPS
* Bluetooth™ technology
* Modem
* Synchronisation PC
* USB mass storage
* USB support

Messaging

* Email:
* Exchange ActiveSync®
* Instant messaging
* Predictive text input
* SMS long (Text Messaging)
* Sound recorder

Communication

* Polyphonic ringtones
* Speaker phone
* Vibrating Alert
* Video call

Design

* Navigation key
* Picture wallpaper

Organiser

* Alarm clock
* Calculator
* Calendar
* Flight mode
* Notes
* Phone book
* Stopwatch
* Tasks
* Timer

Mega Bass™, Memory Stick Duo™, Memory Stick PRO Duo™, Memory Stick Micro™ and M2™ are trademarks of Sony Corporation.

SONY Ericsson C905

Airtel Introduces HTC Touch Diamond and Apple iPhone in India

Now Airtel a leading mobile operator in india introduces the new popular handsets HTC Touch Diamond and Apple iPhone in India...

HTC Touch Diamond the most stylish phone with a seducing menu looks enhanced by TouchFLO 3D technology, come to you by airtel at an attractive price Rs. 27,500...

Apple iPhone the another stylish phone with a faster browsing enhanced with 3G technology, come to you by airtel and vodaphone at a cost of Rs. 31,000 and Rs. 36,000 for 8GB(Black) and 16GB(Black/White) models...

Airtel | HTC | Apple

New Opera 9.50 beta 2 released

Now, they've made the fastest browser in the world even faster. Opera’s new beta is quicker to start, faster at loading Web pages and better at running your favorite Web applications.

Apple - iPhone - 3G

Phone, iPod, Internet, and more.







Introducing iPhone 3G. With fast 3G wireless technology, GPS mapping, support for enterprise features like Microsoft Exchange, and the new App Store, iPhone 3G puts even more features at your fingertips. And like the original iPhone, it combines three products in one — a revolutionary phone, a widescreen iPod, and a breakthrough Internet device with rich HTML email and a desktop-class web browser. iPhone 3G. It redefines what a mobile phone can do — again. Click Here for Features.


iPhone 3G arrives soon in dozens of countries worldwide. And since iPhone 3G is a UMTS/HSDPA and GSM world phone, it works practically anywhere on the planet. Choose your country from the list for more information on rate plans and where to buy iPhone 3G. Click Here.


Click Here for more Technical Specifications.


Click Here for 360 View.

Microsoft Windows SHORTCUT KEYS

Shortcut keys help provide an easier and usually quicker method of
navigating and using computer software programs.

Command Prompt:
~^~^~^~^~^~^~^~

ANSI.SYS Defines functions that change display graphics, control cursor
movement, and reassign keys.
APPEND Causes MS-DOS to look in other directories when editing a file or
running a command.
ARP Displays, adds, and removes arp information from network devices.
ASSIGN Assign a drive letter to an alternate letter.
ASSOC View the file associations.
AT Schedule a time to execute commands or programs.
ATMADM Lists connections and addresses seen by Windows ATM call manager.
ATTRIB Display and change file attributes.
BATCH Recovery console command that executes a series of commands in a file.
BOOTCFG Recovery console command that allows a user to view, modify, and
rebuild the boot.ini
BREAK Enable / disable CTRL + C feature.
CACLS View and modify file ACL's.
CALL Calls a batch file from another batch file.
CD Changes directories.
CHCP Supplement the International keyboard and character set information.
CHDIR Changes directories.
CHKDSK Check the hard disk drive running FAT for errors.
CHKNTFS Check the hard disk drive running NTFS for errors.
CHOICE Specify a listing of multiple options within a batch file.
CLS Clears the screen.
CMD Opens the command interpreter.
COLOR Easily change the foreground and background color of the MS-DOS
window.
COMP Compares files.
COMPACT Compresses and uncompress files.
CONTROL Open control panel
icons from
the MS-DOS prompt.
CONVERT Convert FAT to NTFS.
COPY Copy one or more files to an alternate location.
CTTY Change the computers input/output devices.
DATE View or change the systems date.
DEBUG Debug utility to create assembly programs to modify hardware settings.
DEFRAG Re-arrange the hard disk drive to help with loading programs.
DEL Deletes one or more files.
DELETE Recovery console command that deletes a file.
DELTREE Deletes one or more files and/or directories.
DIR List the contents of one or more directory.
DISABLE Recovery console command that disables Windows system services
or drivers.
DISKCOMP Compare a disk with another disk.
DISKCOPY Copy the contents of one disk and place them on another disk.
DOSKEY Command to view and execute commands that have been run in the past.
DOSSHELL A GUI to help with early MS-DOS users.
DRIVPARM Enables overwrite of original device drivers.
ECHO Displays messages and enables and disables echo.
EDIT View and edit files.
EDLIN View and edit files.
EMM386 Load extended Memory Manager.
ENABLE Recovery console command to enable a disable service or driver.
ENDLOCAL Stops the localization of the environment changes enabled by
the setlocal command.
ERASE Erase files from computer.
EXIT Exit from the command interpreter.
EXPAND Expand a M*cros*ft Windows file back to it's original format.
EXTRACT Extract files from the M*cros*ft Windows cabinets.
FASTHELP Displays a listing of MS-DOS commands and information about them.
FC Compare files.
FDISK Utility used to create partitions on the hard disk drive.
FIND Search for text within a file.
FINDSTR Searches for a string of text within a file.
FIXBOOT Writes a new boot sector.
FIXMBR Writes a new boot record to a disk drive.
FOR Boolean used in batch files.
FORMAT Command to erase and prepare a disk drive.
FTP Command to connect and operate on a FTP server.
FTYPE Displays or modifies file types
used in file
extension associations.
GOTO Moves a batch file to a specific label or location.
GRAFTABL Show extended characters in graphics mode.
HELP Display a listing of commands and brief explanation.
IF Allows for batch files to perform conditional processing.
IFSHLP.SYS 32-bit file manager.
IPCONFIG Network command to view network adapter settings and assigned
values.
KEYB Change layout of keyboard.
LABEL Change the label of a disk drive.
LH Load a device driver in to high memory.
LISTSVC Recovery console command that displays the services and drivers.
LOADFIX Load a program above the first 64k.
LOADHIGH Load a device driver in to high memory.
LOCK Lock the hard disk drive.
LOGON Recovery console command to list installations and enable
administrator login.
MAP Displays the device name of a drive.
MD Command to create a new directory.
MEM Display memory on system.
MKDIR Command to create a new directory.
MODE Modify the port or display settings.
MORE Display one page at a time.
MOVE Move one or more files from one directory to another directory.
MSAV Early M*cros*ft Virus scanner.
MSD Diagnostics utility.
MSCDEX Utility used to load and provide access to the CD-ROM.
NBTSTAT Displays protocol statistics and current TCP/IP connections
using NBT
NET Update, fix, or view the network or network settings
NETSH Configure dynamic and static network information from MS-DOS.
NETSTAT Display the TCP/IP network protocol statistics and information.
NLSFUNC Load country specific information.
NSLOOKUP Look up an IP address of a domain
or host on a
network.
PATH View and modify the computers path location.
PATHPING View and locate locations of network latency.
PAUSE Command used in batch files to stop the processing of a command.
PING Test / send information to another network computer or network device.
POPD Changes to the directory or network path stored by the pushd command.
POWER Conserve power with computer portables.
PRINT Prints data to a printer port.
PROMPT View and change the MS-DOS prompt.
PUSHD Stores a directory or network path in memory so it can be returned
to at any time.
QBASIC Open the QBasic.
RD Removes an empty directory.
REN Renames a file or directory.
RENAME Renames a file or directory.
RMDIR Removes an empty directory.
ROUTE View and configure windows network route tables.
RUNAS Enables a user to execute a program on another computer.
SCANDISK Run the scandisk utility.
SCANREG Scan registry and recover registry from errors.
SET Change one variable or string to another.
SETLOCAL Enables local environments to be changed without affecting
anything else.
SETVER Change MS-DOS version to trick older MS-DOS programs.
SHARE Installs support for file sharing and locking capabilities.
SHIFT Changes the position of replaceable parameters in a batch program.
SHUTDOWN Shutdown the computer from the MS-DOS prompt.
SMARTDRV Create a disk cache in conventional memory or extended memory.
SORT Sorts the input and displays the output to the screen.
START Start a separate window in Windows from the MS-DOS prompt.
SUBST Substitute a folder on your computer for another drive letter.
SWITCHES Remove add functions from MS-DOS.
SYS Transfer system files to disk drive.
TELNET Telnet to another computer / device from the prompt.
TIME View or modify the system time.
TITLE Change the title of their MS-DOS window.
TRACERT Visually view a network packets route across a network.
TREE View a visual tree of the hard disk drive.
TYPE Display the contents of a file.
UNDELETE Undelete a file that has been deleted.
UNFORMAT Unformat a hard disk drive.
UNLOCK Unlock a disk drive.
VER Display the version information.
VERIFY Enables or disables the feature to determine if files have been
written properly.
VOL Displays the volume information about the designated drive.
XCOPY Copy multiple files, directories, and/or drives from one location
to another.
TRUENAME When placed before a file, will display the whole directory in
which it exists
TASKKILL It allows you to kill those unneeded or locked up applications

Run Commands To Access The Control Panel:
~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~

Add/Remove Programs control appwiz.cpl
Date/Time Properties control timedate.cpl
Display Properties control desk.cpl
FindFast control findfast.cpl
Fonts Folder control fonts
Internet Properties control inetcpl.cpl
Keyboard Properties control main.cpl keyboard
Mouse Properties control main.cpl
Multimedia Properties control mmsys.cpl
Network Properties control netcpl.cpl
Password Properties control password.cpl
Printers Folder control printers
Sound Properties control mmsys.cpl sounds
System Properties control sysdm.cpl

Run Commands:
~^~^~^~^~^~^~

compmgmt.msc - Computer management
devmgmt.msc - Device manager
diskmgmt.msc - Disk management
dfrg.msc - Disk defrag
eventvwr.msc - Event viewer
fsmgmt.msc - Shared folders
gpedit.msc - Group policies
lusrmgr.msc - Local users and groups
perfmon.msc - Performance monitor
rsop.msc - Resultant set of policies
secpol.msc - Local security settings
services.msc - Various Services
msconfig - System Configuration Utility
regedit - Registry Editor
msinfo32 _ System Information
sysedit _ System Edit
win.ini _ windows loading information(also system.ini)
winver _ Shows current version of windows
mailto: _ Opens default email client
command _ Opens command prompt

Windows XP Shortcuts:
~^~^~^~^~^~^~^~^~^~

ALT+- (ALT+hyphen) Displays the Multiple Document Interface (MDI) child
window's System menu
ALT+ENTER View properties for the selected item
ALT+ESC Cycle through items in the order they were opened
ALT+F4 Close the active item, or quit the active program
ALT+SPACEBAR Display the System menu for the active window
ALT+TAB Switch between open items
ALT+Underlined letter Display the corresponding menu
BACKSPACE View the folder one level up in My Computer or Windows
Explorer
CTRL+A Select all
CTRL+B Bold
CTRL+C Copy
CTRL+I Italics
CTRL+O Open an item
CTRL+U Underline
CTRL+V Paste
CTRL+X Cut
CTRL+Z Undo
CTRL+F4 Close the active document
CTRL while dragging Copy selected item
CTRL+SHIFT while dragging Create shortcut to selected iteM
CTRL+RIGHT ARROW Move the insertion point to the beginning of the next word
CTRL+LEFT ARROW Move the insertion point to the beginning of the
previous word
CTRL+DOWN ARROW Move the insertion point to the beginning of the next
paragraph
CTRL+UP ARROW Move the insertion point to the beginning of the previous
paragraph
SHIFT+DELETE Delete selected item permanently without placing the item
in the Recycle Bin
ESC Cancel the current task
F1 Displays Help
F2 Rename selected item
F3 Search for a file or folder
F4 Display the Address bar list in My Computer or Windows Explorer
F5 Refresh the active window
F6 Cycle through screen elements in a window or on the desktop
F10 Activate the menu bar in the active program
SHIFT+F10 Display the shortcut menu for the selected item
CTRL+ESC Display the Start menu
SHIFT+CTRL+ESC Launches Task Manager
SHIFT when you insert a CD Prevent the CD from automatically playing
WIN Display or hide the Start menu
WIN+BREAK Display the System Properties dialog box
WIN+D Minimizes all Windows and shows the Desktop
WIN+E Open Windows Explorer
WIN+F Search for a file or folder
WIN+F+CTRL Search for computers
WIN+L Locks the desktop
WIN+M Minimize or restore all windows
WIN+R Open the Run dialog box
WIN+TAB Switch between open items

Windows Explorer Shortcuts:
~^~^~^~^~^~^~^~^~^~^~^~

ALT+SPACEBAR - Display the current window's system menu
SHIFT+F10 - Display the item's context menu
CTRL+ESC - Display the Start menu
ALT+TAB - Switch to the window you last used
ALT+F4 - Close the current window or quit
CTRL+A - Select all items
CTRL+X - Cut selected item(s)
CTRL+C - Copy selected item(s)
CTRL+V - Paste item(s)
CTRL+Z - Undo last action
CTRL+(+) - Automatically resize the columns in the right hand pane
TAB - Move forward through options
ALT+RIGHT ARROW - Move forward to a previous view
ALT+LEFT ARROW - Move backward to a previous view
SHIFT+DELETE - Delete an item immediately
BACKSPACE - View the folder one level up
ALT+ENTER - View an item's properties
F10 - Activate the menu bar in programs
F6 - Switch between left and right panes
F5 - Refresh window contents
F3 - Display Find application
F2 - Rename selected item

Internet Explorer Shortcuts:
~^~^~^~^~^~^~^~^~^~^~^~

CTRL+A - Select all items on the current page
CTRL+D - Add the current page to your Favorites
CTRL+E - Open the Search bar
CTRL+F - Find on this page
CTRL+H - Open the History bar
CTRL+I - Open the Favorites bar
CTRL+N - Open a new window
CTRL+O - Go to a new location
CTRL+P - Print the current page or active frame
CTRL+S - Save the current page
CTRL+W - Close current browser window
CTRL+ENTER - Adds the
SHIFT+CLICK - Open link in new window
BACKSPACE - Go to the previous page
ALT+HOME - Go to your Home page
HOME - Move to the beginning of a document
TAB - Move forward through items on a page
END - Move to the end of a document
ESC - Stop downloading a page
F11 - Toggle full-screen view
F5 - Refresh the current page
F4 - Display list of typed addresses
F6 - Change Address bar and page focus
ALT+RIGHT ARROW - Go to the next page
SHIFT+CTRL+TAB - Move back between frames
SHIFT+F10 - Display a shortcut menu for a link
SHIFT+TAB - Move back through the items on a page
CTRL+TAB - Move forward between frames
CTRL+C - Copy selected items to the clipboard
CTRL+V - Insert contents of the clipboard
ENTER - Activate a selected link
HOME - Move to the beginning of a document
END - Move to the end of a document
F1 - Display Internet Explorer Help

Accessibility Shortcuts
~^~^~^~^~^~^~^~^~^

Tap SHIFT 5 times - Toggles StickyKeys on and off.
Press down and hold the right SHIFT key for 8 seconds - Toggles
FilterKeys on and off.
Press down and hold the NUM LOCK key for 5 seconds - Toggles ToggleKeys
on and off.
Left ALT+left SHIFT+NUM LOCK - Toggles MouseKeys on and off.
Left ALT+left SHIFT+PRINT SCREEN - Toggles High Contrast on and off.

Microsoft Office Keyboard Shortcut Keys
Important Word Shortcuts
~^~^~^~^~^~^~^~^~^~^~

All Caps - CTRL+SHIFT+A
Annotation - ALT+CTRL+M
Auto Format - ALT+CTRL+K
Auto Text - F3 or ALT+CTRL+V
Bold - CTRL+B or CTRL+SHIFT+B
Bookmark - CTRL+SHIFT+F5
Copy - CTRL+C or CTRL+INSERT
Copy Format - CTRL+SHIFT+C
Copy Text - SHIFT+F2
Create Auto Text - ALT+F3
Date Field - ALT+SHIFT+D
Delete Back Word - CTRL+BACKSPACE
Delete Word - CTRL+DELETE
Dictionary -
ALT+SHIFT+F7
Do Field Click - ALT+SHIFT+F9
Doc Maximize - CTRL+F10
Doc Move - CTRL+F7
Doc Restore - CTRL+F5
Doc Size - CTRL+F8
Grow Font - CTRL+SHIFT+.
Grow Font One Point - CTRL+]Hanging Indent - CTRL+T
Header Footer Link - ALT+SHIFT+R
Help - F1
Hidden - CTRL+SHIFT+H
Hyperlink - CTRL+K
Indent - CTRL+M
Italic - CTRL+I or CTRL+SHIFT+I
Justify Para - CTRL+J
Left Para - CTRL+L
Line Up Extend - SHIFT+UP
List Num Field - ALT+CTRL+L
Outline - ALT+CTRL+O
Outline Collapse - ALT+SHIFT+- or ALT+SHIFT+NUM -
Outline Demote - ALT+SHIFT+RIGHT
Outline Expand - ALT+SHIFT+=
Outline Expand - ALT+SHIFT+NUM +
Outline Move Down - ALT+SHIFT+DOWN
Outline Move Up - ALT+SHIFT+UP
Outline Promote - ALT+SHIFT+LEFT
Outline Show First Line - ALT+SHIFT+L
Lock Fields - CTRL+3 or CTRL+F11
Web Go Back - ALT+LEFT
Web Go Forward - ALT+RIGHT
Word Left - CTRL+LEFT
Word Left Extend - CTRL+SHIFT+LEFT
Word Right - CTRL+RIGHT

Excel Time saving Shortcuts
~^~^~^~^~^~^~^~^~^~^~^~

Move to next cell in row - Tab
Move to previous cell in row - Shift + Tab
Up one screen - Page Up
Down one screen - Page Down
Move to next worksheet - Ctrl + Page Down
Move to previous worksheet - Ctrl + Page Up
Go to first cell in data region - Ctrl + Home
Go to last cell in data region - Ctrl + End
Bold toggle for selection - Ctrl + B
Italic toggle for selection - Ctrl + I
Underline toggle for selection - Ctrl + U
Strikethrough for selection - Ctrl + 5
Change the font - Ctrl + Shift + F
Change the font size - Ctrl + Shift + P
Apply outline borders - Ctrl + Shift + 7
Remove all borders - Ctrl + Shift + Underline
Wrap text in same cell - Alt + Enter
Format cells - Ctrl + 1
Select font - Ctrl + Shift + F
Select point size - Ctrl + Shift + P
Format as currency - Ctrl + Shift + 4
Format as general - Ctrl + Shift + # (hash sign)
Format as percentage - Ctrl + Shift + 5
Format as number - Ctrl + Shift + 1
Autosum a range of cells - Alt + Equals Sign
Insert the date - Ctrl +; (semi-colon)
Insert the time - Ctrl + Shift +; (semi-colon)
Insert columns/rows - Ctrl + Shift + + (plus sign)
Insert a new worksheet - Shift + F11
Read Monitor Cell One - Alt + Shift + 1
Read Monitor Cell Two - Alt + Shift + 2
Read Monitor Cell Three - Alt + Shift + 3
Read Monitor Cell Four - Alt + Shift + 4
List Visible Cells With Data - Ctrl + Shift + D
Lists Data In Current Column - Ctrl + Shift + C
List Data In Current Row - Ctrl + Shift + R
Select Hyperlink - Ctrl + Shift + H
Move To Worksheet Listbox - Ctrl + Shift + S
Move To Monitor Cell - Ctrl + Shift + M
Select Worksheet Objects - Ctrl + Shift + O
List Cells At Page Breaks - Ctrl + Shift + B
Options Listbox - Insert + V

Easy move through Powerpoint
~^~^~^~^~^~^~^~^~^~^~^~^~

Apply subscript formatting - CTRL+EQUAL SIGN (=)
Apply superscript formatting - CTRL+PLUS SIGN (+)
Bold - CTRL+B
Capitalize - SHIFT+F3
Copy - CTRL+C
Delete a word - CTRL+BACKSPACE
Demote a paragraph - ALT+SHIFT+RIGHT ARROW
Find - CTRL+F
Insert a hyperlink - CTRL+K
Insert a new slide - CTRL+M
Italicize - CTRL+I
Make a duplicate of the current slide - CTRL+D
Open - CTRL+O
Open the Font dialog box - CTRL+T
Paste - CTRL+V
Print - CTRL+P
Promote a paragraph - ALT+SHIFT+LEFT ARROW
Repeat your last action - F4 or CTRL+Y
Save - CTRL+S
Select all - CTRL+A
Start a slide show - F5
Switch to the next pane (clockwise) - F6
Switch to the previous pane - SHIFT+F6
Undo - CTRL+Z
View guides - CTRL+G

New HTC Touch Pro

The HTC Touch Pro™ brings together elegant touch screen response with the direct precision of keyboard entry… leaving out nothing to deliver a powerhouse communication tool in a beautiful, compact design.

The 2.8-inch VGA touch screen provides four times the resolution of most smart devices, making email, documents and web pages sharper and easier to work with than ever before.

HTC’s rich, touch-responsive interface, TouchFLO™ 3D, provides a stunningly intuitive way to zip through common tasks like messaging, calendar checks or making calls. Delve a little deeper to find that playing media files, searching for contacts and surfing the web are also responsive to your touch.

The web browser puts the full Internet in the palm of your hand. Websites look just like they do on a PC, and TouchFLO™ 3D makes it easy to pan around and zoom in on exactly the information you’re looking for. If you need a wide screen, simply tilt the Touch Pro sideways and the page switches to landscape view.

Slide out the 5-row QWERTY keyboard to make light work of typing-intensive tasks like composing email or working on Microsoft Office® documents… perfect for when your day takes a serious turn.

High speed connectivity will keep you in touch with colleagues and contacts wherever you are. Integrated GPS can be used with maps software for a full turn-by-turn satellite navigation experience.

Built-in Wi-Fi and TV-out functionality* mean you can hook up to the local wireless hot spot to surf, then deliver the perfect PowerPoint® presentation without a laptop in sight.

A beautiful angle on business, the HTC Touch Pro introduces effortless presence to enterprise-standard communications.

Highlights :
~^~^~^~^~^~^

* Mobile Internet features - surf and download at broadband speed with HSDPA and Wi-Fi®
* 2.8-inch touch screen, with four times the resolution of most phones.
* Vibrant TouchFLOTM 3D user interface.
* Five-row QWERTY keyboard for quick and easy text entry.
* Surf and download at broadband speed with HSDPA and Wi-Fi®:
* 3.2 megapixel auto-focus camera with flash light for quality stills and video.
* microSD™ slot for expandable storage.
* Integrated GPS can be used with maps software for a full turn-by-turn navigation experience.


Specification :
~^~^~^~^~^~^~^~

Processor Qualcomm® MSM7201A™ 528 MHz
Operating System Windows Mobile® 6.1 Professional
Memory ROM: 512 MB
RAM: 288MB
Dimensions 102 mm (L) X 51 mm (W) X 18.05 mm (T)
Weight 165 g (with battery)
Display 2.8-inch TFT-LCD flat touch-sensitive screen with VGA resolution
Network HSDPA/WCDMA:

*
Europe/Asia: 900/2100 MHz
*
Up to 384 kbps up-link and 7.2 Mbps down-link speeds

Tri-band GSM/GPRS/EDGE:

*
Europe/Asia: 900/1800/1900 MHz

(Band frequency and data speed are operator dependent.)
Device Control TouchFLO™ 3D
Touch-sensitive navigation control
Keyboard Slide-out 5-row QWERTY keyboard
GPS GPS and A-GPS ready
Connectivity Bluetooth® 2.0 with EDR
Wi-Fi®: IEEE 802.11 b/g
HTC ExtUSB™ (11-pin mini-USB 2.0, audio jack, and TV Out* in one)
Camera

Main camera: 3.2 megapixel color camera with auto focus and flash light
Second camera: VGA CMOS color camera
Audio Built-in microphone, speaker and FM radio with RDS
Ring tone supported formats:

*
MP3, AAC, AAC+, WMA, WAV, and AMR-NB
*
40 polyphonic and standard MIDI format 0 and 1 (SMF)/SP MIDI

Battery Rechargeable Lithium-ion or Lithium-ion polymer battery
Capacity: 1340 mAh

Talk time:

*
Up to 397 minutes for WCDMA
*
Up to 485 minutes for GSM

Standby time:

*
Up to 503 hours for WCDMA
*
Up to 406 hours for GSM

Video call time: Up to 201 minutes for WCDMA
(The above are subject to network and phone usage.)
Expansion Slot microSD™ memory card (SD 2.0 compatible)
AC Adapter Voltage range/frequency: 100 ~ 240V AC, 50/60 Hz
DC output: 5V and 1A

* HTC TV Out cable needed.

My name is Khan

"My Name Is Khan / माई नेम इज़ खान" is the working title for an upcoming Hindi movie starring Shahrukh Khan and Kajol, directed by Karan Johar. The movie is scheduled to start shooting in mid - 2008. The script for the movie has been kept under - wraps, but some sources reveal it will be about a Muslim guy (Shahrukh Khan) living in New York, with his wife (Kajol) during the 9/11 attacks.

External Links:
www.mynameiskhan.co.in
IMDB

Everything made easy, Just download and have fun . . .

Download MP3, PC-Games, PS2 Games, PSP Games, XBOX Games and XBOX 360 Games right here.

Say bye to wi-fi...

Now WiMax(Worldwide Interoperability for Microwave Access) is introduced in India by Reliance Communications. Now it`s available in Bangalore. Bangaloreans surf at speeds 150Kbps to 2Mbps Hi Speed Wireless Internet.

WiMAX, the Worldwide Interoperability for Microwave Access, is a telecommunications technology aimed at providing wireless data over long distances in a variety of ways, from point-to-point links to full mobile cellular type access. It is based on the IEEE 802.16 standard, which is also called WirelessMAN. The name "WiMAX" was created by the WiMAX Forum, which was formed in June 2001 to promote conformance and interoperability of the standard. The forum describes WiMAX as "a standards-based technology enabling the delivery of last mile wireless broadband access as an alternative to cable and DSL" (and also to HSPA).

Currently, Pakistan has the largest fully functional nationwide Wimax network in the world. Wateen Telecom installed the network in seventeen cities throuhout Pakistan using Motorola hardware.

The terms "fixed WiMAX", "mobile WiMAX", "802.16d" and "802.16e" are frequently used incorrectly. Correct definitions are:

* 802.16-2004 is often called 802.16d, since that was the working party that developed the standard. It is also frequently referred to as "fixed WiMAX" since it has no support for mobility.

* 802.16e-2005 is an amendment to 802.16-2004 and is often referred to in shortened form as 802.16e. It introduced support for mobility, amongst other things and is therefore also frequently called "mobile WiMAX".

Reliance WiMax Broadband

WiMAX - Wikipedia

Listen to Online Songs and Download them . . .

Then catch them right here for Malayalam, Telugu, Tamil, Kannada, Hindi and Carnatic...
Just click me here.

New HTC Diamond

Product Overview:
~^~^~^~^~^~^~^~^~
2.8-inch touch screen, with four times the pixels of most phones.

Vibrant TouchFLO 3D user interface, responding perfectly to your finger gestures when scrolling through contacts, browsing the web, and launching media… all vividly displayed as photos and artwork powered by the 3D graphics processor.

HTC Weather - providing a constant view of weather at home and abroad.

Surf and download at broadband speed with HSDPA internet connectivity.

3.2 megapixel auto-focus camera for quality stills and video.

4GB of internal storage to preserve more photos, music, files and exchanged data than ever before.

Integrated GPS for use with maps software for a full turn-by-turn satellite navigation experience.

Specifications:
~^~^~^~^~^~^~^~
Processor : Qualcomm® MSM7201A™ 528 MHz

Operating System : Windows Mobile® 6.1 Professional

Memory ROM : 256 MB

RAM : 192 MB DDR SDRAM

Internal storage : 4 GB

Dimensions : 102 mm (L) X 51 mm (W) X 11.35 mm (T)

Weight : 110 g (with battery)

Display : 2.8-inch TFT-LCD flat touch-sensitive screen with VGA resolution

Network : HSDPA/WCDMA:

* Europe/Asia: 900/2100 MHz
* Up to 384 kbps up-link and 7.2 Mbps down-link speeds

Tri-band GSM/GPRS/EDGE:

* Europe/Asia: 900/1800/1900 MHz
(Band frequency & data speed are operator dependent.)

Device Control : TouchFLO™ 3D
Touch-sensitive navigation control

GPS : GPS and A-GPS ready

Connectivity : Bluetooth® 2.0 with EDR
Wi-Fi® : IEEE 802.11 b/g
HTC ExtUSB™ (11-pin mini-USB 2.0 and audio jack in one)

Camera Main camera : 3.2 megapixel color camera with auto focus

Second camera : VGA CMOS color camera

Audio : Built-in microphone, speaker and FM radio with RDS

Ring tone
supported formats : * MP3, AAC, AAC+, WMA, WAV, and AMR-NB
* 40 polyphonic and Standard MIDI format 0 and 1 (SMF)/SP MIDI

Battery : Rechargeable Lithium-ion or Lithium-ion polymer battery

Capacity : 900 mAh

Talk time : * Up to 270 minutes for WCDMA
* Up to 330 minutes for GSM

Standby time : * Up to 396 hours for WCDMA
* Up to 285 hours for GSM

Video call time : Up to 145 minutes for WCDMA
(The above are subject to network and phone usage.)
AC Adapter
Voltage range/frequency : 100 ~ 240V AC, 50/60 Hz

DC output : 5V and 1A