Functional information subsystems can be classified into

The failure data analysis of a longwall mining system consisting of thre major subsystems revealed that the failure rate of shearer, face conveyor any stage loader are 0.15/ hour, 0.2/ hour and 0.1/ hour respectively. If all the subsystems must be running for a satisfactory system operation, the reliability of the longwall system for a period of 4 hours is

A

0.165

B

0.259

C

0.405

D

0.63

Assertion (A) The system is a set of inter-dependent subsystems that constitute a united whole.
Reason (R) The management of a family depends upon the components of the environments of these subsystems.

A

A is correct and R is incorrect

B

A is incorrect and R is correct

C

Both A and R are correct

D

Both Aand R are incorrect

Functional subsystems are connected by

A

resource flows

B

decision flows

C

information flows

D

data flows

E

None of the above

Configuration management can be divided into which two subsystems?

A

Reconfiguration and documentation

B

Management and configuration

C

Documentation and dialing up

D

Configuration and dialing up

Configuration management can be divided into two subsystems: reconfiguration and __________

A

Documentation

B

Information

C

Servers

D

Entity

The functional area showing the greatest interest in the concept of functional information systems is the

A

financial function

B

manufacturing function

C

both (a) and (6)

D

neither (a) nor (b)

E

None of the above

The manager, in using the systems approach, should subdivide the firm into subsystems based on

A

functional areas-marketing, finance, and manufacturing

B

management levels-strategic, tactical, and operational

C

resource flows-manpower, money, machines, and material

D

any of the above represent acceptable subsystem divisions.

E

None of the above

Partitioning into subsystems are done at

A

design stage

B

prototype stage

C

testing stage

D

fabrication stage

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A

Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer.

B

Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C

Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table.

D

Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

A

Zero

B

More than zero but less than that of an equivalent 3NF decomposition

C

Proportional to the size of F+

D

Indeterminate

Functional information subsystems can be classified into

Related Questions