objective set 2

 

1.       In which normal form of database all the attributes of the non primary keys are fully dependent on primary key?

a.       First

b.       Second

c.       First and second

d.       All

2.       Which one of the following refers to the “ data about data”?

a.       Directory

b.       Data mining

c.       Metadata

d.       Data warehousing

3.       Which of the following statement is correct to display all the cities with the condition, temperature and humidity is in the range of 60 to 75 from the “ weather” table?

a.       SELECT * FROM weather WHERE humidity IN(60 TO 75);

b.       SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75;

c.       SELECT * FROM weather WHERE humidity NOT IN(60 TO 75);

d.       SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75;

4.       Which of the following is a file transfer service?

a.       ftp

b.       telnet

c.       smtp

d.       all

5.       which of the following is a server side scripting language?

a.       PHP

b.       MYSQL

c.       JAVASCRIPT

d.       SQL

6.       Which syntax is used for opening and closing a php script?

a.       <php>…..</php>

b.       <?php…………..?>

c.       ?php…………….?php

d.       <p>…..</p>

7.       What output will be obtained from the following javascript?

var a=15;

var b=0;

console.log(a/b);

a.       15 is printed

b.       0 is printed

c.       Infinity is printed

d.       Garbage value is printed

8.       The processing of deriving new class from base class is.

a.       Class

b.       Polymorphism

c.       Inheritance

d.       Data abstraction

9.       When can white box testing be started?

a.       After analysis

b.       After programming

c.       After designing.

d.       After installation

 solution

1. b. Second
2. c. Metadata
3. b. SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75;
4. a. ftp
5. a. PHP
6. b. <?php..........?>
7. c. Infinity is printed
8. c. Inheritance
9. b. After programming