Saturday, 25 March 2017

IT Officer-3

Q1: A table joined with itself is called:
(A) Join
(B) Self Join
(C) Outer Join
(D) Equi Join
Answer: (B): Self-Join
(A self-join is a query in which a table is joined (compared) to itself. Self-joins are used to compare values in a column with other values in the same column in the same table. One practical use for self-joins)



Q 2 : Which two files are used during operation of the DBMS?
A) Query languages and utilities
B) DML and query language
C) Data dictionary and transaction log
D) Data dictionary and query language

Answer:  C) Data dictionary and transaction log

(Data dictionary is otherwise names as metadata repository, which contains the information about the data such as relationship, meaning, datatypes used etc. During the operation of a database, this data dictionary will be always checked.)

(Transaction log means the history of actions done by the DBMS software.)



Q 3:  Which of the following is the acronym that refers to home-office workers?
A. SOHO
B. SOHOM
C. HOMEO
D. HOMOF
Answer: A (SOHO)
(Small office/home office (or single office/home office; SOHO) refers to the category of business that involves from 1 to 10 workers.)



Q 4: What types of virus uses computers hosts to reproduce itself?
(A) Worm
(B) Time Bomb
(C) Melissa Virus
(D) Micro Virus
(E) Macro Virus
Answer: (A) Worm
(In a computer, a worm is a self-replicating virus that does not alter files but resides in active memory and duplicates itself.)


Q 5 :  The internet has resulted in a(n) .... communication costs.
(A) freeze of
(B) lowering of
(C) status quo of
(D) increase in
(E) elimination of
Answer : (B) lowering of
(It’s clear ... Now a days ... we use whats-app etc. with help of which we can communicate cheaply) 



Q 6:    Which of the following terms applies to software that is written especially for a particular type of business?
A. Integrated business software
B. Business-specific software
C. Vertical market software
D. Business-oriented software
Answer: (C) Vertical market software
(Vertical market software is software aimed at a particular vertical market and can be contrasted with horizontal market software (such as word processors and spreadsheet programs) that can be used in a cross-section of industries.)


Q 7:   HTML commands such as <H1> are known as....?
(A) Browser Requests
(B) Labels
(C) Tags
(D) Tickets
Answer: (C) Tags
(An HTML tag is a code that describes how a Web page is formatted. HTML tags are defined by the characters < and >)


Q 8:  Today, the main use for a parallel port is to:
(A) Facilitate communication between peripherals and software.
(B) Connect a printer to your system unit.
(C) Connect an infrared mouse to your computer.
(D) Send and receive data one bit at a time.
Answer: (B) Connect a printer to your system unit.
(Parallel port is a parallel interface for connecting an external device such as a printer. It is also known as a printer port.)


Q9:  The type of memory that must have a constant power supply is:
(A) SDRAM.
(B)  PROM.
(C) ROM.
(D) EEPROM.
Answer: (A) SDRAM.
(Synchronous dynamic random access memory (SDRAM) has a synchronous interface, meaning that it waits for a clock signal before responding to control inputs and is therefore synchronized with the computer's system bus.)


Q 10:  To free up space on your desk, choose a computer that has a small ______.
(A) Footprint
(B) Chipset
(C) Word size
(D) Instruction set
Answer: (A) Footprint
(In information technology, a footprint is the amount of space a particular unit of hardware or software occupies.) 

No comments:

Post a Comment