DB/OS/DS/Networking/HTML - 11

1)   What must reside in the main memory under all situations in a resident - OS computer?

a. Linker
b. Loader
c. Assembler
d. Compiler
Answer  Explanation 

ANSWER: Loader

Explanation:
No explanation is available for this question!


2)   Match the following list1 with list2:

a. DMA I/O -------------------------------------- 1. High speed RAM
b. Cache ---------------------------------------- 2. Disk
c. Interrupt I/O --------------------------------- 3. Printer
d. Condition code register ------------------- 4. ALU


a. a – 2, b – 1, c – 3, d - 4
b. a – 4, b – 1, c – 3, d - 2
c. a – 2, b – 3, c – 1, d - 4
d. a – 3, b – 4, c – 2, d - 1
Answer  Explanation 

ANSWER: a – 2, b – 1, c – 3, d - 4

Explanation:
No explanation is available for this question!


3)   What is the use of thrashing?

a. It improves system performance
b. It implies excessive page I/O
c. It decreases the degree of multiprogramming
d. It reduces page I/O
Answer  Explanation 

ANSWER: It decreases the degree of multiprogramming

Explanation:
No explanation is available for this question!


4)   What will happen when we format a floppy disk?

a. Identification information is written on all tracks and sectors
b. The system area is deleted
c. Data is written
d. Data is arranged on the disk in contiguous fashion
Answer  Explanation 

ANSWER: Data is arranged on the disk in contiguous fashion

Explanation:
No explanation is available for this question!


5)   What should be the size of ROM if it is used to store the table for multiplication of two 8 - bit unsigned integers?

a. 64k x 8
b. 64k x 16
c. 4k x 8
d. 64k x 16
Answer  Explanation 

ANSWER: 64k x 8

Explanation:
No explanation is available for this question!


6)   In which of the following OS is Internet Packet Exchanger (IPX) / Sequence Package Exchanger (SPX) used?

a. MS-DOS
b. Mac OS
c. Windows 95
d. Novell's Netware Network
Answer  Explanation 

ANSWER: Novell's Netware Network

Explanation:
No explanation is available for this question!


7)   Which of the following VTP mode allows to make change in the VLAN information on the switch?

a. STP
b. Transparent
c. Server
d. Client
Answer  Explanation 

ANSWER: Server

Explanation:
No explanation is available for this question!


8)   Which of the following is / are the advantages of VLAN?

a. It can increase the network security.
b. It allows logical grouping of users by function.
c. All of the above
d. None of the above
Answer  Explanation 

ANSWER: All of the above

Explanation:
No explanation is available for this question!


9)   Which of the following switching technologies reduces the size of the broadcast domain?

a. VLAN
b. ISL
c. STP
d. ARP
Answer  Explanation 

ANSWER: VLAN

Explanation:
No explanation is available for this question!


10)   Which of the following is / are the state of the links in CSS?

a. a:link
b. a:visited
c. a:hover
d. a:active
e. All of the above.
Answer  Explanation 

ANSWER: All of the above.

Explanation:
No explanation is available for this question!


11)   Which CSS property is used for controlling the layout?

a. header
b. display
c. footer
d. none of the above
Answer  Explanation 

ANSWER: display

Explanation:
No explanation is available for this question!


12)   Which CSS property sets the stack order of an element?

a. z-index
b. position
c. overflow
d. clip
Answer  Explanation 

ANSWER: z-index

Explanation:
No explanation is available for this question!


13)   A CSS combinator is the one which explains the relationship between the selectors.

a. True
b. False


Answer  Explanation 

ANSWER: True

Explanation:
No explanation is available for this question!


14)   Pseudo-classes in CSS ________.

a. match a specified element
b. select the active links
c. are used to define a special state of an element
d. are used to select all the visited links
Answer  Explanation 

ANSWER: are used to define a special state of an element

Explanation:
No explanation is available for this question!


15)   Which linear structure has a provision of Last-In-First-Out (LIFO) mechanism for its elements?

a. Stack
b. Queue
c. Both a & b
d. None of the above
Answer  Explanation 

ANSWER: Stack

Explanation:
No explanation is available for this question!


16)   How are the elements with the same priority get processed according to the Priority Queue mechanism?

a. Before the processing of other elements with lower priority
b. After the processing of other elements with highest priority
c. On the basis of 'First-Come-First Served' priority
d. None of the Above
Answer  Explanation 

ANSWER: On the basis of 'First-Come-First Served' priority

Explanation:
No explanation is available for this question!


17)   Which of the following ' C ' functions is precise to verify the emptiness of a Queue?

a.
int empty(Q*P)
{
if (P->R==-1)
return (1);
return(0);
}
b.
int full (Q*P)
{
if(P->R==MAX-1)
return(1);
return(0);
}
c.
int empty (Q*P)
{
if (P<-R==-1)
return(0);
return(1);
}
d.
int full (Q*P)
{
if(P<-R==MAX-1)
return(0);
return(1);
}
Answer  Explanation 

ANSWER:
int empty(Q*P)
{
if (P->R==-1)
return (1);
return(0);
}

Explanation:
No explanation is available for this question!


18)   Where the elements are stored in accordance to the representation of Queue by a Linked Structure?

a. mesh
b. node
c. both a & b
d. none of the above
Answer  Explanation 

ANSWER: node

Explanation:
No explanation is available for this question!


19)   Which among the below specified condition is applicable if the Queue is non - empty?

a. rear > front
b. rear < front
c. rear = front
d. Unpredictable
Answer  Explanation 

ANSWER: rear > front

Explanation:
No explanation is available for this question!


20)   What should be the value of rear (end) if the queue is full (elements are completely occupied )?

a. 1
b. - 1
c. MAX + 1
d. MAX - 1
e. zero (null)
Answer  Explanation 

ANSWER: MAX - 1

Explanation:
No explanation is available for this question!


21)   Which value is assigned/set at front and rear ends during the Initialization of a Queue?

a. 0
b. 1
c. - 1
d. infinity
Answer  Explanation 

ANSWER: - 1

Explanation:
No explanation is available for this question!


22)   Which among the below mentioned entities is / are essential for an Array Representation of a Queue?

a. An array to hold queue elements
b. A variable to hold the index of front element
c. A variable to hold the index of rear element
d. All of the above
Answer  Explanation 

ANSWER: All of the above

Explanation:
No explanation is available for this question!


23)   From where does the insertion and deletion of elements get accomplished in Queues?

a. Front & Rear ends respectively
b. Rear & Front ends respectively
c. Only Front ends
d. Only Rear ends
Answer  Explanation 

ANSWER: Rear & Front ends respectively

Explanation:
No explanation is available for this question!


24)   What is Degree of relationships?

a. number of participating entity types
b. number of participating relations
c. number of participating attribute types
d. number of participating constraints
Answer  Explanation 

ANSWER: number of participating entity types

Explanation:
No explanation is available for this question!


25)   How is specialization denoted in an ER Diagram?

a. Triangle labeled IS A
b. Rectangle labeled IS A
c. Rectangle Labeled HAS A
d. Triangle labeled HAS A
Answer  Explanation 

ANSWER: Triangle labeled IS A

Explanation:
No explanation is available for this question!


26)   A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction.

a. Partially committed
b. Committed
c. Aborted
d. Failed
Answer  Explanation 

ANSWER: Aborted

Explanation:
No explanation is available for this question!


27)   An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null is called __________.


a. Secondary Key
b. Super key
c. Candidate Key
d. Foreign Key
Answer  Explanation 

ANSWER: Foreign Key

Explanation:
No explanation is available for this question!


28)   Which is not the relational algebra operator?

a. Set difference
b. Cartesian product
c. Rename
d. Join
Answer  Explanation 

ANSWER: Set difference

Explanation:
No explanation is available for this question!


29)   The problem caused by independent multivalued dependencies is eliminated in which of the normal form?

a. 3NF
b. BCNF
c. 4NF
d. 5NF
Answer  Explanation 

ANSWER: 4NF

Explanation:
No explanation is available for this question!


30)   What is the responsibility of the buffer manager?


a. Fetching data from disk storage into main memory, and deciding what data to cache in main memory.
b. Allocation of space on disk storage and the data structures used to represent information stored on disk.
c. Storing details such as how many users, which user has which permissions etc.
d. None of the above
Answer  Explanation 

ANSWER: Fetching data from disk storage into main memory, and deciding what data to cache in main memory.

Explanation:
No explanation is available for this question!


31)   Where is the root directory of a disk placed?

a. Anywhere on the disk.
b. At a fixed location on the system disk.
c. At a fixed address in main memory.
d. None of the above.
Answer  Explanation 

ANSWER: At a fixed location on the system disk.

Explanation:
No explanation is available for this question!


32)   Which normal form is the partial dependency removed?

a. First
b. Second
c. Third
d. BCNF
Answer  Explanation 

ANSWER: Second

Explanation:
No explanation is available for this question!


33)   Match the following

A) Composite attribute ------ i) Attribute whose value is calculated from other attributes
B) Multivalued Attribute ---- ii) Attribute that can be further subdivided to yield additional attributes
C) Derived Attribute -------- iii) Attribute that can have more values


a. A-i, B-ii, C-iii
b. A-ii, B-i, C-iii
c. A-ii, B-iii, C-i
d. A-iii, B-ii, C-i
Answer  Explanation 

ANSWER: A-ii, B-iii, C-i

Explanation:
No explanation is available for this question!


34)   When a primary key is define in the table, DBMS automatically creates a ____ on a primary key column.

a. Unique index
b. Sequence
c. Trigger
d. Synonym
Answer  Explanation 

ANSWER: Unique index

Explanation:
No explanation is available for this question!


35)   Which of the following is an Open Source DBMS?

a. MySQL
b. Microsoft SQL Server
c. Microsoft Access
d. Oracle
Answer  Explanation 

ANSWER: MySQL

Explanation:
No explanation is available for this question!


36)   Which among the below mentioned assertions is / are mainly associated with the feature of Spooling?

a. Scheduling of processes
b. Maintenance of a queue of jobs to be printed
c. A queue of client processes awaiting to gain the service from the service process
d. All of the above
Answer  Explanation 

ANSWER: Maintenance of a queue of jobs to be printed

Explanation:
No explanation is available for this question!


37)   What is the ' next ' field of structure node in the Queue?

a. Results into the storage of queue elements.
b. Results into the storage of address of next node by holding the next element of queue.
c. Results into the memory allocation of data elements to next node.
d. Results into the address allocation data elements to next node.
Answer  Explanation 

ANSWER: Results into the storage of address of next node by holding the next element of queue.

Explanation:
No explanation is available for this question!


38)   What will a simple two pass assembler do in the first pass?

a. It will allocate space for the literals.
b. It will generate the code for all the load and store register instruction.
c. It will build the symbol table for the symbols and their values.
d. It will compute the total length of the program.
Answer  Explanation 

ANSWER: It will allocate space for the literals.

Explanation:
No explanation is available for this question!


39)   Which event will be used when a connection to the server is opened.

a. onopen
b. onmessage
c. onerror
d. None of the above
Answer  Explanation 

ANSWER: onopen

Explanation:
No explanation is available for this question!


40)   In the table given below T1, T2 and T3 are the transactions.The correct serialization of the below schedules is

computer-science-33.png
a. T2 -> T3 -> T1
b. T3 -> T2 -> T1
c. T1 -> T2 -> T3
d. T1 -> T3 -> T2
Answer  Explanation 

ANSWER: T1 -> T3 -> T2

Explanation:
No explanation is available for this question!