IT articles

 

 

 

   SQL (Structured Query Language) is a powerful language used for managing and manipulating  relational databases. Some of the most common SQL commands are:   1.        SELECT : Retrieves data from one or more tables.   SELECT column1, column2 FROM table_name WHERE condition ; 2.        INSERT : Inserts new records into a table.   INSERT INTO table_name (column1, column2) VALUES (value1, value2); 3.        UPDATE : Modifies existing records in a table.   UPDATE table_name SET column1 = value1 WHERE condition ; 4.        DELETE : Removes records from a table.   DELETE FROM table_name WHERE condition ; 5.        CREATE TABLE : Creates a new table in the database.   CREATE TABLE table_name ( column1 datatype, column2 datatype...

Inter Part-I CS MCQ's Chapter 5 MCQ's our answer 1. Data and program not being used by computer are stored in: * Secondary storage Cache Primary storage Printer 2. A set of instructions that run the computer are: * Hardware Document CPU Software 3. The program that contains instructions to operate a device is called: * Device driver Device operator Device linking Device system 4. CPU is an example of: * Software A program Hardware Output device 5. The address of instruction under the processor execution is contained within: * Program counter Current instruction register Memory address register Memory buffer register 6. A computer derives its basic strength from: * Speed Memory Accuracy All of above 7. The ALU  perform the following actions: * Control computer operation Perform arithmatic operations Perform logical operations Both b and c 8. Which is a storage device: * CPU Clock Floppy disk Bus 9. Which component is responsible for comparing data * AU LU CU Memory 10. Which one...