Objective 1

Tick the correct answer. 

1. Which of the statements are used in DML statement?

a) Select, drop, where     b) Select, insert, delete     c) Select, drop, update         d ) Select, insert, drop

2. With SQL, how do you select all the records from a table named "employee" where the value of column "ename" is "john"?

a) Select * from employee where ename is exactly john;

 b)Select * from employee where ename is equal to john ;

c) Select * from employee where ename='john';

d)Select * from employee where ename is not in john;

3. What is the first step in the software development lifecycle?

a) System design                 b) System testing             c) Coding                     d) System analysis

4. What is the minimum number of functions to be present in a C program?

a. 1                              b. 2                             c. 3                                 d. 4

5. What kind of transmission medium is most appropriate for carry data in a computer network that is exposed to electrical interference?

1. Unshielded twisted pair b. Optical fiber c. Coaxial cable d. Microwave.

6. What should be the correct syntax to write a PHP code?

a. <php>                  b <?php ?>                                 c. <? ?>                                 d. Php

7. Which jQuery method is used to hide selected elements?

a. hidden                     b. display(none)                         c. hide                                         d. visible(false)

8. Which Key is used to uniquely identify a record?

a. Primary key         b. Foreign Key                 c. Both a. and b.                 d. None of the mentioned

9. Which of the following is not an unguided communication media?

a. Twisted pair wire                 b. Satellite                 c. Microwave                 d. Bluetooth

10. What is the full form of SaaS?

a. Software as a service

b. System as a service

c. Security as a service

d. Storage as a service

11Which of the following is not a DDL command?

a. Update b. Truncate c. Alter d. None

12. In hierarchical model, records are organized as a. Table b. List c. Link d. Tree

13. In which topology devices are connected through the hub? a. Star topology b. Mesh topology c. Ring topology d. Bus topology

14. Write output Main() { Char *p; P=”Nepal”; Printf(“%c”,*&*p);}

a. Nepal b. N c. Some address will be printed d. None of the above

15. What are the two method of form access? a. Get/Post b. Get/Set c. Post/Set d. Give/Post

16. The context diagram is known as the…………..? a. Level-0 DFD b. Level-1 DFD c. Level-2 DFD d. Level-3 DFD

17. In OOP, what is the difference between a class and an object? a. A class is a blueprint for creating objects, while an object is a specific instance of a class. b. A class and an object are the same thing. c. A class is an object, and an object is a class. d. A class represents data, while an object represents behavior.

18. Which of the following is true for first normal form?

    a. Eliminate repeating group.

    b. Eliminate partial functional dependency.

    c. Eliminate transitive dependency

    d. Eliminate multi value dependency.

19. Which of the following is true for Second normal form?

    a. Eliminate repeating group.

    b. Eliminate partial functional dependency.

    c. Eliminate transitive dependency

    d. Eliminate multi value dependency.

20.Which of the following is true for Third normal form?

    a. Eliminate repeating group.

    b. Eliminate partial functional dependency.

    c. Eliminate transitive dependency

    d. Eliminate multi value dependency.

1. b) Select, insert, delete
2. c) Select from employee where ename='john
3. d) System analysis
4. b. 1
5. b. Optical fiber
6. b, <?php ?>
7. c. hide
8. a. Primary key
9. a. Twisted pair wire
10.  a. Software as a Service
11. a. Update
12. d. Tree
13. a. Star topology
14. b. N
15. a. Get/Post
16. a. Level-0 DFD
17. a. A class is a blueprint for creating objects, while an object is a specific instance of a class.
18. a. eliminate repeating groups
19. b. eliminate partial functional dependency
20. c. eliminate transitive dependency