Ch-1 Database Management System (DBMS)
1. A relational database consists of a collection of .... a. Tables b. Fields c. Records d. Keys 2. A term ____ is used to refer to a row. a. Attribute b. Tuple c. Field d. Instance 3. The term attribute refers to a ____ of a table. a. Record b. Column c. Tuple d. Key 4. CREATE TABLE employee(name VARCHAR, ID INTEGER); What type of statement is this? a. DML b. DDL c. View d. Integrity Constraint 5. In the given query , which of the keyword has to be inserted? INSERT INTO employee _____ (4,Alex,2000); a. Table b. Values c. Relation d. Field 6. In the ____ normal form, a composite attribute is converted to individual attributes. a. First b. Second c. Third d. Fourth 7. With SQL, how do you slect all the records from a table named "persons" where the value of the column "FirstName" ends with an "a"? a. SELECT * FROM Persons WHERE FirstName='a' b. SELECT * FROM Persons WHERE FirstName LIKE 'a%' c. SELECT * FROM Persons WHERE FirstName LIKE '%a' d. SELECT * FROM Persons WHERE FirstName='%a%' 8. The UPDATE SQL clause can _____ a. update only one row at a time b. update more than one row at a time c. delete more than one row at a time d. delete only one row at a time 9. Which SQL keyword is used to retrieves a maximum value? a. MOST b. TOP c. MAX d. UPPER 10. Which of the following is not a DDL command? a. UPDATE b. TRUNCATE c. ALTER d. None of the above
Ch-2 Data Communication & Networking
1) What are the five elements of basic communication system? a) Data, Sender, Receiver, Medium and Message b) Message, Sender, Receiver, Rules and Protocols c) Message, Sender, Receiver, Medium and Protocols d) Message, Sender , Receiver , Software and Protocols 2) Which of the following are communication modes? a) Simplex b) Half Duplex c) Full Duplex d) All of above 3) Which of the following is simplex mode of communication system? a) Newspaper b) Radio c) Keyboard to computer d) All of above 4) Which of the following is example of half duplex mode? a) Walkie –Talkie b) Radio c) Mobile Phone d) None of above 5) Example of full duplex mode is ______ a) Newspaper b) Radio c) Walkie-Talkie d) Telephone / Mobile 6) What is the maximum length of typical type of LAN? a) 1KM b) 3 KM c) 10 KM d) 100 KM 7) Cabling structure of a network is called _______ a) Topology b) Arrangements c) Physical Structure d) None 8) Physical Layout of a network is called _______ a) Layout b) Topology c) Structure d) None 9. a. b. c. d. 10. a. b. c. d.
Ch-3 Web Technology II
1. Which of the following language is not web scripting language? a. HTML b. CSS c. JavaScript d. C Language 2. Which of the following statement is not true? a. HTML is standard language for development webpages b. HTML helps to embed text, graphics, audio, video and animation on webpage c. HTML is also used to store database in websites d. HTML also defines a link to traverse from one page to another 3. An example of client-side scripting language is .... a. PHP b. JSP c. ASP d. JavaScript 4. JavaScript was originally developed by ...... a. Google b. Microsoft c. Sun microsystem d. Netscape 5. What are the basic three types of data in JavaScript? a. Numbers, Strings and Boolean b. Numbers Strings and Bytes c. Integer, Character and Boolean d. Numbers, Strings and Array 6. Grater than equal to >= is an example of a. Assignement b. Comparaison c. Logical d. Conditional 7. Which of the following statement is not a type of looping statement? a. do while b. for c. switch case d. while 8. Which of the following is not an example of object? a. Array b. String c. Image d. Number 9. Which of the following statement is not true? a. PHP is open-source scripting language b. PHP is client site scripting language c. PHP can be integrated with database like MYSQL, Oracle, Sybase and MS SQL Server d. PHP syntax is same as C language 10. What are the two method of form access? a. get/post b. give/take c. input/output d. get/set 11. In PHP in order to access MYSQL database you will use: a mysqlconnect() function b. mysql-connect() function c. mysql_connect() function d. sql_connect[) function 12. The .... statement is used to delete a table. a. DROP TABLE b. DELETE TABLE c. DEL TABLE d. REMOVE TABLE 13. Which Program Copies The Databases From One Server To Another? a. Mysqlcopydb b. Mysqldbcopy c. Mysqlflushdb d. Mysqldbflush 14. Which among the following have the maximum bytes? a. varchar b. char c. Both varchar and char d. Text Type 15. The "father" Of MYSQL...... a. Bill Joy b. Michael Widenius c. Bill Gates d. Stephanie Wall
Ch-4 Programming Concept - C II
1. Which of the following are themselves a collection of different data types? a. string b. structures c. char d. all of above 2. Which of the following can not be a structure member? a. Another structure b. Functions c. Array d. None of above 3. Presence of code like "s.t.b=10" indicates ______ a. Synatx Error b. Structure c. double data type d. An ordinary varaible name 4. Which of the following is a correct format for declaration of function? a. return-type function-name(argument type); b. return-type function-name(argument type){} c. return-type (argument type) function-name; d. all of above 5. Which of the following function declaration is illegal? a. int 1bhk(int); b. int 1bhk(int a); c. int 2bhk(int *, int []); d. all of above 6. Which among the following is the odd one out? a. printf b. fprintf c. putchar d. scanf 7. For a typical program, the input is taken using ____ a. scanf b. files c. command-line d. all of above 8. What will fopen will return, if there is any error while openeing a file? a. nothing b. EOF c. NULL d. Depends on compiler 9. When a C program is started, OS environment is responsible for opeing file and providing pointer for that file? a. standrard input b. standard output c. standard error d. all of above 10. What is meant by 'a' in the following C operation? fp=fopen('random.txt","a"); a. attach b. append c. apprehend d. add
Ch-5 Object Oriented Programming (OOP)
1. a. b. c. d. 2. a. b. c. d. 3. a. b. c. d. 4. a. b. c. d. 5. a. b. c. d. 6. a. b. c. d. 7. a. b. c. d. 8. a. b. c. d. 9. a. b. c. d. 10. a. b. c. d.
Ch-6 Software Process Model
1. a. b. c. d. 2. a. b. c. d. 3. a. b. c. d. 4. a. b. c. d. 5. a. b. c. d. 6. a. b. c. d. 7. a. b. c. d. 8. a. b. c. d. 9. a. b. c. d. 10. a. b. c. d. 11. a. b. c. d. 12. a. b. c. d.
Ch-7 Recent Trends in Technology
1. a. b. c. d. 2. a. b. c. d. 3. a. b. c. d. 4. a. b. c. d. 5. a. b. c. d. 6. a. b. c. d. 7. a. b. c. d. 8. a. b. c. d. 9. a. b. c. d. 10. a. b. c. d. 11. a. b. c. d. 12. a. b. c. d. 13. a. b. c. d. 14. a. b. c. d. 15. a. b. c. d. 16. a. b. c. d. 17. a. b. c. d. 18. a. b. c. d.