What are the functions of functions key in Computer from F1 to F12?

What are the functions of functions key in Computer? F1 to F12

Answer:

Commonly known as "function keys", F1 through F12 may have a variety of different uses or no use at all. Depending on the installed operating system and the software program currently open will change how each of these keys operate. A program is capable of not only using each of the function keys, but also combining the function keys with the ALT and/or CTRL keys, for example, Microsoft Windows users can press ALT + F4 to close the program currently active.

Below is a short-listing of some of the common functions of the functions keys on computers running Microsoft Windows. As mentioned above not all programs support function keys and/or may perform different tasks then those mentioned below. If you are looking for more specific shortcut keys and function key examples we suggest seeing our shortcut key page.

F1

* Almost always used as the help key, almost every program will open the help screen when this key is pressed.

* Windows Key + F1 would open the Microsoft Windows help and support center.

* Open the Task Pane.

F2

* In Windows commonly used to rename a highlighted icon or file.

* Alt + Ctrl + F2 opens a new document in Microsoft Word.

* Ctrl + F2 displays the print preview window in Microsoft Word.

F3

* Often opens a search feature for many programs including Microsoft Windows.

* Shift + F3 will change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.

F4

* Open find window.

* Repeat the last action performed (Word 2000+)

* Alt + F4 will close the program currently active in Microsoft Windows.

* Ctrl + F4 will close the open window within the current active window in Microsoft Windows.

F5

* In all modern Internet browsers pressing F5 will refresh or reload the page or document window.

* Open the find, replace, and go to window in Microsoft Word.

* Starts a slideshow in PowerPoint.

F6

* Move the cursor to the Address bar in Internet Explorer and Mozilla Firefox.

* Ctrl + Shift + F6 opens to another open Microsoft Word document.

F7

* Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.

* Shift + F7 runs a Thesaurus check on the word highlighted.

* Turns on Caret browsing in Mozilla Firefox.

F8

* Function key used to enter the Windows startup menu, commonly use to get into Windows Safe Mode.

F9

* Opens the Measurements toolbar in Quark 5.0.

F10

* In Microsoft Windows activates the menu bar of an open application.

* Shift + F10 is the same as right-clicking on a highlighted icon, file, or Internet link.

F11

* Full-screen mode in all modern Internet browsers.

F12

* Open the Save as window in Microsoft Word.

* Shift + F12 save the Microsoft Word document.

* Ctrl + Shift + F12 prints a document in Microsoft Word.

Comparison Conditions

Comparison Conditions

=

>

>=

<

<=

<>

BETWEEN…AND…

IN(set)

LIKE

IS NULL

We can display rows based on a range of values using the BETWEEN range condition. The range that we specify contains a lower limit and an upper limit.

To test for values in a specified set of values, use the IN condition. The IN condition is also known as the membership condition.

We may not always know the exact value to search for. We can select rows that match a character pattern by using the LIKE condition. The character pattern-matching operation is referred to as a wildcard search. Two symbols can be used to construct the search string. Ie. %(zero or more characters) and _ (single character).

The NULL conditions include the IS NULL condition and the IS NOT NULL condition. The IS NULL condition tests for nulls. A null value means the value is unavailable, unassigned, unknown, or inapplicable. Therefore, we cannot test with = because a null cannot be equal or unequal to any value.

- select empno, ename,job, deptno from emp where deptno=20;

- select empno, ename, salary from emp where lastname=’Lama’;

- select * from emp where hiredate=’01-JAN-95’ and salary>=5000 and lastname=’Smith’;

- select ename,slary from emp where salary between 2300 and 3500;

- select empno,ename,salary,mgr from emp where deptno in(20,30,40);

- select ename,hiredate from emp where hiredate like ‘%95’;

- select ename from emp where ename like ‘_e%’;

- select ename,mgr from emp where mgr is null;

- select ename,salary,comm. from emp where comm. is null;

- select empno, ename,job,salary from emp where salary>=1000 and job like ‘SYS%’;

- select empno, ename,job,salary from emp where salary>=1000 or job like ‘SYS%’;

- select empno, ename from emp where job in (‘MANAGER’, ‘CLERK’, ‘PEON’);

The order of rows returned in a query result is undefined. The ORDER BY clause can be used to sort the rows. If we use the ORDER BY clause, it must be the last clause of the SQL statement. We can specify an expression, or an alias, or column position as the sort condition. Syntax:

SELECT expression

FROM table

WHERE conditions

ORDER BY columns [ASC|DESC];

If the ORDER BY clause is not used, the sort order is undefined, and the oracle server may not fetch rows in the same order for the same query twice. Use the ORDER BY clause to display the rows in a specific order.

To reverse the order in which rows are displayed, specify the DESC keyword after the column name in the ORDER BY clause.

- select ename, job, depatno, hiredate from emp order by hiredate;

- select ename, job ,deptno, hiredate from emp order by hiredate desc;

- select empno, ename, salary, salry*12 Annsal from emp order by annsal;

- select ename, deptno, salary from emp order by deptno,salary desc;

Primary key constraints

Primary key constraints

This constraint avoids duplication of rows and does not allow NULL values, when enforced in a column or set of columns. A a result it is used to identify a row. A table can have only one primary key. If a primary key constraint is assigned to more than one column(i.e) or combination of columns it is said to be a composite primary key (or simply a composite key), which can contain a maximum of 16 columns. Primary key constraint cannot be defined in an alter table command when the table contains rows having NULL values.

Run and Check your out put

- select * from emp;

- select deptno, dname, loc from dept;

- select empno, ename, salary, hiredate from emp;

- select ename,salary, salary+100 from emp;

- select ename, salary, (salary*12)+100 from emp;

- select ename,slary, (salary*12)+comm. from emp;

- select ename,salary, (salary*12)+nvl(comm,0) from emp;

- select ename “Full Name”, salary*12 “Annual Salary” from emp;

- select ename||job from emp;

- select ename||’ is a ‘||job “Emp Detail” from emp;

- select deptno from emp;

- select distinct deptno from emp;

- select distinct deptno, job from emp;

- In SQL, we can display the structure of a table using the DESCRIBE command. The command shows the column names and data types, as well as whether a column must contain data or not.

- desc emp;

- describe emp;

Hello, world!
]]>

How to make Diet Coke and Mentos Rocket

What happen when diet coke and mentos get mixed??

It forms boom which get exploid


myths and facts health tips diet management

Nepali comedy

nepali comedy nepali funny and smile nepal funny video in nepali comedy in nepali have fun in nepali what a joke in nepali nepali video

nepali jokes and fun

गाउँबाट भर्खरै शहर आएका एउटा केटा पसलमा गएछ:
केटा: साहुजी, यहाँ के-के पाइन्छ ?
साहुजी: यहाँ कोक, फेन्टा, पेप्सी... सबै पाइन्छ ।
केटा: त्यसोभए मलाई कोक र पेप्सी गरेर एक पाथी राख्दिनुस न ।

एउटा बालकले आफ्ना बाबासँग सोधेछन्:
बालक: बाबा, फेवाताल कहाँ छ ?
(हतारिँदै) बुबा: छोरा, घरको सबै कुरा तिम्रो आमालाई थाहा हुन्छ, उसैले कतै राखेकी होली ।


दुई प्रेमी प्रेमीका कोठामा बसिरहेका बेला प्रेमीले अकष्मात बत्ती निभाए:
प्रेमीका: तिमीले के गरेको यो ? बत्ती बाल मलाई डर लाग्छ ।
प्रेमी: तिमी नडराउन प्रिय, म छँदै छु नि ।
प्रेमीका: तिमी भएर त डराएको नि ।

नव विवाहित दम्पति शहर जान बस चढेछन्, बसमा भिँडभाँड भएकाले युवकले युवतीलाई अँगालो हालेर उभिएको थियो:
त्यो देखेर कण्डक्टरले भन्यो: ऐ दाई, बस्न नपाए पनि त्यो दिदीलाई राम्रोसँग उभिन त दिनुस् ।
युवक: अगि तपाँईले नै भनेको होईन, आफ्नो सामानको सुरक्षा आफैले गर्नु भनेर ?

श्यामे: मैले मोबाइलमा नम्बर डायल गर्‌यो कि एउटी केटीले मलाई जिस्क्याउँछे यार ।
रामे: हो र ? के भन्छे त ?
श्यामे: तिमी आफै सुन न ।
रामे ले सुन्छ “माफ गर्नुहोला तपाँईले सम्पर्क गर्नुभएको मोवाइलको सुईच अफ गरिएको छ ।“

nepali jokes

ग्राहक:-यदि मैले यो चिठ्ठी आज पोष्ट गरे भने पर्सी र पोखरा पुग्छ नि हैन?
पोष्ट मास्टर:- जरुर, किन नपुग्नु।
ग्राहक:-म बाजी राखछु यो पुग्दैन।
पोष्ट मास्टर:- किन पुग्दैन?
ग्राहक:- किनकि यसको ठेगाना काठमाण्डौको छ।


बाख्रा र सुङगुरको बस्ने ठाऊ नभएकोले गर्दा उनिहरुले शिवजीको तपस्या गरेछन्। शिवजी प्रसन्न भएर प्रकट हुनुभएछ र सोध्नु भयो:- मेरा प्यारा बालक, तिमीहरुलाई के आपत पर्यो?
सुङगुर:-हामीलाई बस्नको लागि खोर भएन। हामीलाई दया गर्नुहोस्।
शिवजी:- ल! मैले बनाइदिएको त्यत्रो खोर कै त?
बाख्रा:- त्यो त प्रकाश ओझाले भत्काइदियो नि।

शिक्षक:- तलाई गधा ! यति पनि आउदैन?
राम:- सर पनि खाली गधा गधा मात्र भन्नुहुन्छ, कहिले पनि राम भनेर बोलाउनुहुन्न।
(अर्को दिन सरको अगाडी डाक्टर लिएर आउछ)
नमस्ते सर!
शिक्षक:- अनिँ त गधाले चाँहि डाक्टर किन बोलाको नि?
राम:- के गर्नु सर तपाई मलाई गधा मात्र देख्नुहुन्छ, त्यहि भएर तपाईको आँखा देखाउन ल्याएको नि।


बिद्यार्थी:- सर मलाई जसरी भएपनि पास गराइदिनुहोस्। अहिले पास भइन भने मेरो त जहाजै डुब्छ।
शिक्षक:- स्कुल आउदा लुरुलुरु हिडेर आउछौ, साइकल त छैन तिम्रो जहाज डोब्छ भन्छौ?

जज:- तिमीलाई पटक पटक अदालतमा आउन लाज लाग्दैन?
चोर:- हजुर म त कहिले काही मात्र आउछु, तर तपाइ त दिनदनै आउनु हुन्छ, लाज त तपाईलाई लाग्नु पर्ने हो नि।

चौकीदार:- तँ आप चोर्छस् तेरो घरमा गएर तेरो बुबालाई भनिदिउ?
केटो:- बुबा घरमा भेटिनुहुन्न! बुबा पनि छिमेकीको आँप टिप्दै हुनुहुन्छ।


शिक्षक:- ल भन त दिपेश, राम किन वनबास गएका थिए?
दिपेश:- सर काठ चिर्न गएका होलान् नि त।


प्रेमिकाले प्रभावको छातीमा हात राखदै भनिछ:- तिम्रो दिल त पथ्थर जस्तै कडा रहेछ।
प्रेमी:- (हास्दै):- हिइन डार्लिङ तिम्रो हात त मेरो गोजीमा भएको लाइटरमा छ।


दुईजना मन्त्रीहरु हेलिकप्टरमा बसेर बाढीग्रस्त क्षेत्रको निरिक्षण गरिरहेका थिए।
पहिलो मन्त्री:- यदि मैले यहाँबाट ५०० को नोट फ्याके भने ति पिडित जनताहरु कति खुसी होलान् हगि?
दोस्रो मन्त्री:- मैले पि यहाँबाट १००० को नोट फ्याँके भने झन् जनता कति खुसी होलान्।
(दुबै मन्त्रीको कुरा सुनेर पाइलटलाई ज्यादै रिस उठेछ र झोकिदैँ) भनेछ:- यदि मैले तपाईहरु दुबैलाई यहाबाट फ्याकेँ भने ति जनताहरु सबैभन्दा बढि खुसी होलान्।


कृष्ण :- मलाई आज भोली निन्द्रा नै लाग्दैन यार ।
रमेश :- अँ..!, त्यसो भए तिमी एउटा उपाय गर ।
कृष्ण :- के छ त्यस्तो उपाय ?
रमेश :- तिमी राती जहिल्यै आधा-आधा घण्टामा हुस्की पिउने गर ।
कृष्ण :- किन नि ?
रमेश :- तिमी कमसे कम आधा घण्टा त सुत्न पाउँछौ ।


बिरामी : डाक्टरसाप ! मेरो आँखाको अगाडि दाग देखाईदिनुस न ।
डाक्टर : किन, तिम्रो चश्माले राम्रो देखिरहेको छैन ?
बिरामी : हैन सर ! मेरो चश्माले दागलाई पनि सफा बनाएर देखाईरहेको छ ।


एउटा मानिस रेष्टुरामा बसेर पिउदै थियो। उ जति पिउदै जान्थ्यो उति नै पर्सबाट आफ्नो स्वास्नीको फोटो निकाल्दै
हेर्थ्यो। एक पेग स्वाट्ट पार्थ्यो अनि फेरी पर्सबाट आफ्नो स्वास्नीको फोटो निकालेर हेर्थ्यो। त्यो अघी देखी हेरिरहेको मान्छेले अचम्ममा पर्दै सोध्यो:- किन तिमी एक पेग लिन्छौ, अनि फोटो हेर्छौ, अनि फेरी पिउन सुरु गर्छौ, यो के गरेको?
पिउने मान्छे:- वास्तबमा यो मेरो स्वास्नीको फोटो हो, जब मलाई उ राम्री लाग्छे अनि मात्र म घर जान्छु।


एक बृद्दा अस्पतालमा चेकअप गर्न गईन र एउटा जवान डाक्टरले उनीलाई क्याबिन मा लगेर चेकअप गर्न थाल्यो तर अचानक बृद्दा चिच्याउदै बाहिर आई। त्यो देखेर सिनियर डाक्टरले सबै कुरा बुझ्न चाहयो र त्यसपछि जवान डाक्टरलाई हकार्दै भन्यो:- तपाईको दिमाग ठिक मा त छ, तपाई ६५ बर्षको बृद्दालाई गर्भवति भन्दै हुनु हुन्छ?
जुनियर डाक्टर:- सर म कर गरु, उहाको बाडुली रोक्ने अर्को उपाया नै मसँग थिएन।


आमा:- हेर छोरी त यती राम्री छस् कि म तेरो बिहे कुनै ठुलो घरमा गरिदिन्छु।
छोरी:- आमा मेरो बिहे सानो घरमा नै गरिदिनु, आखिरमा सफा त मैले नै गर्नु पर्छ नि हैन।


ग्राहक चकित हुदै:- तिमिले कसरी म यो होटलमा पहिलो चोटी आएको हो भनेर थहा पायौ?
वेटर:- यहा जो एक चोटी खाना खाएर जान्छ दोस्रो पल्ट फर्केर कहिल्लै आउदैन।


पसलमा एउटा मान्छे आएर कहिले यो सामान त कहिले त्यो सामान उठाएर हेर्दै राखछ। त्यो देखेर साउजीलाई वाक्क लाग्छ ।पसलेले:- आखिर तपाईलाई के चाहिएको हो?
मान्छे:- मौका


पुत्र (पितासँग):- पिता जि मलाई एउटा ढोल किनिदिनुहोस न।
पिता:- हुदैन छोरा, तैले मलाई ढोल बजाएर वाक्क लगाउछस्।
पुत्र :- लगाउदिन बुबा, म तपाई निदाएको बेला बजाउछु नि।


पत्नी:- यदि तपाइ मसँग सपिङको लागी जानु हुन्छ भने, म पनि जान्न ।
पति (खुसी हुदै):- किन र तिमीलाई मेरो साथ जान रमाइलो लाग्छ हो?
पत्नी:- मलाई त्यस्तो रमाइलो समाइलो हैन कि , त्यहा सपिङ सेन्टरमा सामान उठाउने कोही पनि हुदैन।

Earn online

1
Online Jobs for Indians.Online Data Entry Jobs.Earn Rs.50000

monthly !No Investment. Free to Join !
ONLY FOR INDIANS

http://www.netjobs4all.com/

2
http://www.cashfiesta.com/php/join.php?ref=rupaknpl

The easiest way to make more money is to let others make them for you. Cashfiesta pays you for your referrals up to the 8^th level. See for yourself how much you can earn, click on the Fiesta Calculator

An A-Z Index of the SQL Server 2005 database

An A-Z Index of the SQL Server 2005 database
Aggregate
- CREATE AGGREGATE
- DROP AGGREGATE
Application Role
- CREATE APPLICATION ROLE
- ALTER APPLICATION ROLE
- DROP APPLICATION ROLE
Assembly
- CREATE ASSEMBLY
- ALTER ASSEMBLY
- DROP ASSEMBLY

ALTER AUTHORIZATION

BACKUP
BACKUP CERTIFICATE
BEGIN [DIALOG [CONVERSATION]]

Certificate - ALTER CERTIFICATE
- CREATE CERTIFICATE
- DROP CERTIFICATE
CHECKPOINT
COMMIT
Contract - CREATE CONTRACT
- DROP CONTRACT
Credential - CREATE CREDENTIAL
- ALTER CREDENTIAL
- DROP CREDENTIAL

Database - CREATE DATABASE
- ALTER DATABASE
- DROP DATABASE
DBCC CHECKALLOC - Check consistency of disk allocation.
DBCC CHECKCATALOG - Check catalog consistency
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.
DBCC CHECKDB - Check allocation, and integrity of all objects.
DBCC CHECKFILEGROUP - Check all tables and indexed views in a filegroup.
DBCC CHECKIDENT - Check identity value for a table.
DBCC CHECKTABLE - Check integrity of a table or indexed view.
DBCC CLEANTABLE - Reclaim space from dropped variable-length columns.
DBCC dllname - Unload a DLL from memory.
DBCC DROPCLEANBUFFERS - Remove all clean buffers from the buffer pool.
DBCC FREE... CACHE - Remove items from cache.
DBCC HELP - Help for DBCC commands.
DBCC INPUTBUFFER - Display last statement sent from a client to a database instance.
DBCC OPENTRAN - Display information about recent transactions.
DBCC OUTPUTBUFFER - Display last statement sent from a client to a database instance.
DBCC PROCCACHE - Display information about the procedure cache
DBCC SHOW_STATISTICS - Display the current distribution statistics
DBCC SHRINKDATABASE - Shrink the size of the database data and log files.
DBCC SHRINKFILE - Shrink or empty a database data or log file.
DBCC SQLPERF - Display transaction-log space statistics. Reset wait and latch statistics.
DBCC TRACE... - Enable or Disable trace flags
DBCC UPDATEUSAGE - Report and correct page and row count inaccuracies in catalog views
DBCC USEROPTIONS - Return the SET options currently active
DBCC deprecated commands
DECLARE
Default - CREATE DEFAULT
- DROP DEFAULT
DELETE
DENY - DENY Object permissions
- DENY User/Role permissions
Endpoint - CREATE ENDPOINT
- ALTER ENDPOINT
- DROP ENDPOINT
Event - CREATE EVENT NOTIFICATION
- DROP EVENT NOTIFICATION
EXECUTE
EXECUTE AS

Fulltext Catalog - CREATE FULLTEXT CATALOG
- ALTER FULLTEXT CATALOG
- DROP FULLTEXT CATALOG
Fulltext Index - CREATE FULLTEXT INDEX
- ALTER FULLTEXT INDEX
- DROP FULLTEXT INDEX
Function - CREATE FUNCTION
- ALTER FUNCTION
- DROP FUNCTION

GO
GRANT - GRANT Object permissions
- GRANT User/Role permissions

Index - CREATE INDEX
- ALTER INDEX
- DROP INDEX
INSERT
iSQL -U user -P password -i script.sql -o logfile.log

Key - CREATE ASYMMETRIC KEY - ALTER ASYMMETRIC KEY
- DROP ASYMMETRIC KEY
- CREATE SYMMETRIC KEY
- OPEN SYMMETRIC KEY - CLOSE SYMMETRIC KEY
- ALTER SYMMETRIC KEY
- DROP SYMMETRIC KEY
KILL
KILL QUERY NOTIFICATION
KILL STATS JOB

Login - CREATE LOGIN
- ALTER LOGIN
- DROP LOGIN

Master Key - CREATE MASTER KEY
- ALTER MASTER KEY - BACKUP MASTER KEY
- DROP MASTER KEY
- RESTORE MASTER KEY
- ALTER SERVICE MASTER KEY - BACKUP SERVICE MASTER KEY
- RESTORE SERVICE MASTER KEY
Message Type - CREATE MESSAGE TYPE
- ALTER MESSAGE TYPE
- DROP MESSAGE TYPE

Partition Function - CREATE PARTITION FUNCTION
- ALTER PARTITION FUNCTION
- DROP PARTITION FUNCTION
Partition Scheme - CREATE PARTITION SCHEME
- ALTER PARTITION SCHEME
- DROP PARTITION SCHEME
Procedure - CREATE PROCEDURE
- ALTER PROCEDURE
- DROP PROCEDURE

Queue - CREATE QUEUE
- ALTER QUEUE
- DROP QUEUE

Remote Service Binding - CREATE REMOTE SERVICE BINDING
- ALTER REMOTE SERVICE BINDING
- DROP REMOTE SERVICE BINDING

RESTORE - RESTORE DATABASE Complete
RESTORE DATABASE Partial
RESTORE DATABASE Files
RESTORE LOGS
RESTORE DATABASE_SNAPSHOT
RESTORE FILELISTONLY - List database and log files
RESTORE HEADERONLY - List backup header info
RESTORE LABELONLY - Media info
RESTORE REWINDONLY - Rewind and close tape device
RESTORE VERIFYONLY
REVERT
REVOKE - REVOKE Object permissions
- REVOKE User/Role permissions
Role - CREATE ROLE
- ALTER ROLE
- DROP ROLE
ROLLBACK
Route - CREATE ROUTE
- ALTER ROUTE
- DROP ROUTE

Schema - CREATE SCHEMA
- ALTER SCHEMA
- DROP SCHEMA
SELECT
SEND
SERVERPROPERTY
Service - CREATE SERVICE
- ALTER SERVICE
- DROP SERVICE
SESSION_USER
SESSIONPROPERTY
SET @local_variable
SET
SHUTDOWN
Signature - ADD SIGNATURE
- DROP SIGNATURE
Statistics - CREATE STATISTICS
- UPDATE STATISTICS
- DROP STATISTICS

Synonym - CREATE SYNONYM
- DROP SYNONYM

Table - CREATE TABLE
- ALTER TABLE
- DROP TABLE
- TRUNCATE TABLE
Transaction - BEGIN DISTRIBUTED TRANSACTION
- BEGIN TRANSACTION
- COMMIT TRANSACTION
Trigger - CREATE TRIGGER
- ALTER TRIGGER - ENABLE TRIGGER - DISABLE TRIGGER
- DROP TRIGGER
Type - CREATE TYPE
- DROP TYPE

UNION
UPDATE
User - CREATE USER
- ALTER USER
- DROP USER
USE

View - CREATE VIEW
- ALTER VIEW
- DROP VIEW

XML Schema Collection - CREATE XML SCHEMA COLLECTION
- ALTER XML SCHEMA COLLECTION
- DROP XML SCHEMA COLLECTION