tp-11mba-mbait01-svs-1.pdf

7/27/2019 TP-11MBA-MBAIT01-SVS-1.pdf

1/6

Multiple Choice Questions. Attempt all the questions.

Q1. The ability to change the conceptual schema without affecting the externalschemas or application programs is known as ___________________.

a. Program-data independenceb. Logical data independencec. Physical data independenced. Data abstraction

Q2. Which of these levels deals with the physical representation of the databaseon the computer?

a. External level

b. Conceptual level

c. Internal level

d. None of these

Q3. Which of these is not a representational data model?

a. Entity-relationship model

b. Hierarchical data model

c. Relational data model

d. Network data model

Q4. Which of these is not a feature of Hierarchical model?

a. Organizes the data in tree-like structure

b. Parent node can have any number of child nodesc. Root node does not have any parent

d. Child node can have any number of parent nodes

Q5. Which of these data models is an extension of relational data model?

a. Object-oriented data model

b. Object-relational data model

c. Semi structured data model

d. None of these

Q6. The information about data in a database is called _______.

a. Metadata

b. Hyper data

c. Tera data

d. None of these


2/6

Q7.The relational database environment has all of the following componentsexcepta. users

b. separate files

c. database

d. query languages

Q8. DBMS are intended to

a. eliminate data redundancy

b. establish relationship among records in different files

c. manage file access

d. maintain data integrity

e. all of the above

Q9. The language used application programs to request data from the DBMS isreferred to as the

a. DML

b. DDL

c. query language

e. none of the above

Q10. The highest level in the hierarchy of data organization is called

a. data bankb. data base

c. data file

d. data record

Q11. Report generators are used to

a. store data input by a user

b. retrieve information from files

c. answer queries

d. both b and c

Q12. A top-to-bottom relationship among the items in a database is establishedby a

a. hierarchical schema

b. network schema

c. relational schema

d. all of the above


3/6

Q13. The management information system (MIS) structure with one maincomputer system is called a

a. hierarchical MIS structure

b. distributed MIS structure

c. centralized MIS structure

d. decentralized MIS structure

Q14.A data dictionary is a special file that contains?a. the names of all fields in all files

b. the data types of all fields in all filesc. the widths of all fields in all filesd.All of abovee. None of above

Q15. The DBMS acts as an interface between what two components of an

enterprise-class database system?a. Database application and the databaseb. Data and the databasec. The user and the database applicationd. Database application and SQL

Q16.An on-line commercial site such as Amazon.com is an example of a(n)________ .

a. Single-user database applicationb. Multi-user database applicationc. E-commerce application

d. Data mining database application

Q17. SQL stands for ___________________ .a. Structured Query Languageb. Sequential Query Languagec. Structured Question Languaged. Sequential Question Language

Q18. The following are functions of a DBMS except ________ .

a. creating and processing forms

b. creating databases

c. processing data

d. administrating databases

Q19. A primary key should be defined as:

a. NULL

b. Not NULL


4/6

c. Either of the above can be used.d. None of the above is correct.

Q20.A foreign key is:

a. a column containing the primary key of another table.

b. Used to define data typesc. Used to define NULL statusd. All of the above

Q21. The relational database model was created by E.F. Codd.

a. Trueb. False

Q22. The terms alternate key and candidate key mean the same thing.

a. True

b. False

Q23. When transforming an entity-relationship model into a relational databasedesign, each entity is represented as a table.

a. Trueb. False

Q24. The identifier of an entity will become the ________ of the new table.

a. Foreign Keyb. Main Attributec. Primary keyd. Identity Key

Q25. Which of the following is not true of the traditional approach to information

processinga. there is common sharing of data among the various applications

b. it is file oriented

c. programs are dependent on the file

d. it is inflexible

e. all of the above are true

Q26. Which of the following hardware component is the most important to theoperation of database management system?

a. high resolution video displayb. printer

c. high speed, large capacity disk


5/6

d. plotter

e. mouse

Q27. If a piece of data is stored in two places in the database, then

a. storage space is wasted

b. changing the data in one spot will cause data inconsistency

c. in can be more easily accessed

d. both a and b

e. both a and c

Q28. An audit trail ___________ .

a. is used to make backup copies

b. is the recorded history of operations performed on a file

c. can be used to restore lost information

d. none of the above

Q29. Large collection of files are called ____________ .

a. fields

b. records

c. database

d. sectors

Q30. Generalized database management systems do not retrieve data to meet

routine requesta. True

b. False

Answers:


6/6

Q1.b, Q2.c, Q3.a, Q4.d, Q5.b, Q6.a, Q7.b, Q8.e, Q9.a, Q10.b, Q11.d, Q12.a,Q13.c,Q14.d, Q15.a, Q16.c, Q17.a, Q18.a, Q19.b, Q20.a,Q21.a, Q22.a, Q23.a,Q24.c, Q25.a, Q26.c, Q27.d, Q28.b, Q29.c, Q30.b

tp-11mba-mbait01-svs-1.pdf

Documents