General Computer Test - 110

 

1. Relational calculus is a

a. Procedural language.

b. None- Procedural language.

c. Data definition language.

d. High level language.

2. The view of total database content is

a. Conceptual view

b. Internal view.

c. External view.

d. Physical view.

3. DML is provided for

a. Description of logical structure of database.

b. Addition of new structure in the database system.

c. Manipulation &processing of database.

d. Definition of physical structure of database system.

4. ODBC stands for

a. Object Database Connectivity.

b. Oral Database Connectivity

c. Oracle Database Connectivity.

d. Open Database Connectivity.

5. Architecture of the database can be viewed as

a. Two levels.

b. Four levels.

c. Three levels.

d. One level.

6. The database schema is written in

a. HLL

b. DML

c. DDL

d. DCL

7. In the architecture of a database system external level is the

a. Physical level.

b. Logical level.

c. Conceptual level

d. View level.

8. In a Hierarchical level model records are organized as

a. Graph.

b. List .

c. Links.

d. Tree.

9. The language used in application programs to request data from the DBMS is referred to as the

a. DML

b. DDL

c. VDL

d. SDL

10. The DBMS language component which can be embedded in a program is

a. The data definition language (DDL)

b. The data manipulation language(DML)

c. The database administrator(DBA)

d. A query language.

11. Which one of the following statement is false?

a. The data dictionary is normally maintained by the database administrator.

b. Data elements in the database can be modified by changing the data dictionary.

c. The data dictionary contains the name and description of each data element.

d. The data dictionary is a tool used exclusively by the database administrator.

12. An advantage of the database management approach is

a. Data is dependent on programs.

b. Data redundancy increase.

c. Data is integrated and can be accessed by multiple programs.

d. None of the above.

13. A DBMS query language is designed to

a. Support end users who use English-like commands.

b. Support in the development of complex applications software.

c. Specify the structure of a database.

d. All of the above.

14. Key to represent relationship between tables is called

a. Primary key

b. Secondary Key

c. Foreign Key

d. None of these

15. The full form of DDL

a. Dynamic Data Language

b. Detailed Data Language

c. Data Definition Language

d. Data Derivation Language

16. Which database level is closest to the users?

a. External

b. Internal

c. Physical

d. Conceptual

17. Hierarchical model is also called

a. Tree structure

b. Plex Stucture

c. Normalize Structure

d. Table Structure

18. Information system that monitor the elementary activities and transactions of the organizations are

a. Management-level system

b. Operational-level system

c. Knowledge-level system

d. Strategic level system

19. Information systems that monitor the elementary activities and transactions of the organizations are:

a. Management-level system

b. Operation-level system

c. Knowlwdge-leve system

d. Strategic level system

20. Projections and responses to queries are information output characteristics associated with a (n)

a. DSS

b. MIS

c. ESS

d. TPS

21. Summary transaction data, high-volume data, and simple models are information inputs characteristic of a (n):

a. DSS

b. MIS

c. ESS

d. TPS

22. Which of the following individuals typically have less formal, advanced educational degrees and tend to process rather than create information?

a. Knowledge workers

b. Executives

c. System analysts

d. Data workers

23. Management information systems usually:

a. Serve managers interested in weekly, monthly, and yearly results, not day-to-day activities.

b. Help managers make decisions that are unique, rapidly changing, and not easily specified in advance.

c. Provide mangers with a generalized computing and telecommunications capacity that can be applied to a changing array of problems.

d. Perform and record the daily routine transactions necessary to the conduct of business

24. Decision support systems usually:

a. Serve managers interested in weekly, monthly, and yearly results, not day-to-day activities.

b. Help managers make decisions that are unique, rapidly changing, and not easily specified in advance.

c. Provide managers with a generalized computing and telecommunications capacity that can be applied to a changing array of problems.

d. Perform and record the daily routine transactions necessary to the conduct of business.

25. Identifying customers and markets using data on demographics, markets, consumer behavior, and trends is an example of a (n):

a. Operational-level sales and marketing information system.

b. Knowledge-level sales and marketing information system.

c. Management-level sales and marketing information system.

d. Strategic-level sales and marketing information system.

1. B  2. A  3. C  4. D  5. C  6. C  7. D  8. D  9. A  10. B

11. B  12. C  13. D  14. C  15. C  16. A  17.A  18. A  19. A  20. C

21. B  22. D  23. A  24. B  25. B