Sharma Guides

SQL Commands With Example (Image by - Sharma Guides | Subham232330) ALTER TABLE ALTER TABLE lets you add columns to a table in a database. ALTER TABLE table_name ADD column_name datatype; AND AND is an operator that combines two conditions. Both conditions must be true for the row to be included in the result set. SELECT column_name(s)  FROM table_name  WHERE column_1 = value_1  AND column_2 = value_2; WITH WITH clause lets you store the result of a query in a temporary table using an alias. You can also define multiple temporary tables using a comma and with one instance of the WITH keyword. WITH temporary_name AS ( SELECT  FROM table_name)  SELECT *  FROM temporary_name  WHERE column_name operator value; WHERE WHERE is a clause that indicates you want to filter the result set to include only rows where the following condition is true. SELECT column_name(s)  FROM table_name  WHERE column_name operator value; SELECT DISTINCT SELECT DISTINCT s...

JavaScript Short Notes JavaScript Arrays Destructuring Assigning array items to variable const [a, b, c] = [123, 'second', true]; //a => 123 //b => 'second' //c => true Skipping items const [, b] = [123, 'second', true]; //b => 'second' Assigning the first value, storing the rest together const [a, b, ...rest] = [123, 'second', true, false, 42]; //a => 123 //b => 'second' //c => [true, false, 42] Swapping variables let x = true; let y = false; [x, y] = [y, x] //x => false //y => true

200 Computer QnA in Hindi 1) पहला लैपटॉप कब और किस कंपनी द्वारा पेश किया गया था? ➫ 1981 में, एप्सन कंपनी। 2) कंप्यूटर का आविष्कार किसने किया? ➫ हॉवर्ड ऐकिन। 3) कंप्यूटर का जनक किसे कहा जाता है? ➫ चार्ल्स बैबेज को। 4) आईसी (IC) चिप से बना पहला कंप्यूटर कौन सा है? ➫ अल्टेयर - 8880। 5) पहला डिजिटल कंप्यूटर का क्या नाम है ? ➫ मार्क-1 . 6) पहला कंप्यूटर प्रोग्रामर कौन है? ➫ एडा अगस्ता (एडा लवलेस)। 7) दुनिया के पहले इलेक्ट्रॉनिक कंप्यूटर का नाम क्या है? ➫ ENIAC. 8) आधुनिक कंप्यूटर का जनक किसे कहा जाता है? ➫ जॉन वॉन न्यूमैन को। 9) एक नैनोसेकंड क्या है? ➫ एक सेकंड का सौ करोड़वाँ भाग। 10) विश्व का एकमात्र कंप्यूटर संग्रहालय कहाँ स्थित है? ➫ संयुक्त राज्य अमेरिका में। 11) बांग्लादेश में स्थापित पहले कंप्यूटर का नाम क्या है? ➫ आईबीएम - 1620 सीरीज। 12) बांग्लादेश में पहला इंटरनेट किस वर्ष शुरू किया गया था? ➫ 1996 में। 13) माइक्रोसॉफ्ट का पहला प्रोग्राम कौन सा है? ➫ एमएस डॉस (MS DOS)। 14) संरचना और संचालन के सिद्धांत के आधार पर कंप्यूटर को कितने भागों में विभाजित किया जा सकता है? ➫ ती...

INDIA Some Current Changes You Should Know * PRESIDENT OF INDIA - DRAUPADI MURMU * VICE PRESIDENT OF INDIA - JAGDEEP DHANKHAR * PRIME MINISTER OF INDIA - NARENDRA MODI * CHIED JUSTICE OF INDIA - DY CHANDRACHUD * LOK SABHA SPEAKER - OM BIRLA * HOME MINISTER - AMIT SHAH * DEFENCE MINISTER - RAJNATH SINGH * FINANCE MINISTER - NIRMALA SITHARAMAN * HEALTH MINISTER - MANSUKH MANDAVIYA * RAILWAY MINISTER - ASHWINI VAISHNAW * EDUCATION MINISTER - DHARMENDRA PRADHAN * EXTERNAL AFFAIRS MINISTER - SUBRAMANYAM JAISHANKAR * RBI GOVERNOR - SHAKTIKANTA DAS * NATIONAL SECURITY ADVISOR - AJIT DOVAL * ATTORNEY GENERAL - R VENKATARAMANI * CABINET SECRETARY - RAJIV GAUBA * CHAIRMAN OF UPSC - MANOJ SONI * CHIEF ELECTION COMMISSIONER - RAJIV KUMAR * CHIEF OF ARMY STAFF - GENERAL MANOJ PANDE * CHIEF OF AIR STAFF - ACM VIVEK RAM CHAUDHARI * IEF OF NAVAL STAFF - ADMIRAL R. HARI KUMAR

NSQF IT & ITES 2023 Answer Objective Type Questions 1. By default, a macro is saved in the  Standard library. 2. In the database, a column is also called Attribute . 3. Primary key uniquely identifies a row in a table. 4. Raw facts constitute Data . 5. Ingress is a D.B.M.S. system. 6. The output of the query may be displayed in the form of Reports . 7. In writer, using frames, a document can be organized in  Sections . 8. In image filter, Invert tool inverts the colour values of image. 9. In image filter, Aging tool simulates the effect of time on picture. 10. Bring to front image arrangement tool place image on top of all objects. 11. Full form of RSI is Repetitive Strain Injury . 12. The physical parts of computer are called Hardware . 13. Full form of BIOS is Basic Input Output System . 14. Goals are set of dreams with a deadline to get them. 15. Ubuntu is an Operating System. 16. A verb is a word that describes Action . 17. Page up is a Na...

Computer Basic MCQ MULTIPLE CHOISE QUESTION 1. In order to tell Excel that we are entering a formula in a cell we must begin with an operator such as:     A. $     B. @     C. Equal Sign (=) Answer: C. Equal Sign (=) 2. In application software (MS Excel), there is __________ immediately below the title bar.     A. Standard toolbar     B. Scroll bar     C. Menu bar Answer: C.  Menu bar 3. This is not a function category in Excel     A. Data Series     B.  Text     C. Logical Answer: C.  Logical 4. Excel can display up to __________ fields of a data form.     A. 16     B. 32     C. 64 Answer:  B. 32 5. Excel uses another name for the database. It is called:     A. Listing     B. Organizer     C. List Answer:  C. List 6. Which of the following is not a valid data type in Excel?     A. Number   ...