JAMB Computer Science Past Questions & Answers - Page 38

186.

.......... provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data

A.

Tables

B.

DBMS

C.

Production passwords

D.

Database

Correct answer is B

The Database Management System or DBMS helps to tackle issues as these

187.

In SQL, which command is used to remove a stored function from the database?

A.

REMOVE Function

B.

DELETE function

C.

DROP function

D.

ERASE Function

Correct answer is C

DROP FUNCTION removes the definition of an existing function. To execute this command the user must be the owner of the function. The argument types to the function must be specified, since several different functions can exist with the same name and different argument lists

188.

In Boolean algebra, the bar sign (-) indicates ....................

A.

OR operation

B.

AND operation

C.

NOT operation

D.

None of the above

Correct answer is C

In modern Boolean algebra, we use the plus (+) symbol to mean OR, the dot (•) symbol to mean AND, and a bar above a variable to mean NOT

189.

When an input signal 1 is applied to a NOT gate, the output is ..................

A.

0

B.

1

C.

Either 0 & 1

D.

None of the above

Correct answer is A

In a NOT gate, no output (0) is there when an input (1) is there

190.

Destruction of files for malicious reasons such as access by fraudulent people is classified as being

A.

modified

B.

accessed

C.

destroyed

D.

unauthorized access

Correct answer is D

Access to an information system or network that violates the owner or operator's stated security policy is considered unauthorized access