1. Files are organised by storing them in _________ ?

tables

databases

folders

graphs

Answer: folders

Explanation:

folders. Files are commonly organized and stored in folders, which are a type of container used to group related files together and create a hierarchy of information. This allows for easy access and management of files on a computer or other storage device. Tables and databases are used to organize data, while graphs are used to visualize data.


2. Which command we will give if we want to show the database objects with it's decription ?

Details

Show

List

None of the above

Answer: None of the above

Explanation:

To show the database objects along with their description, we need to use the "DESCRIBE" or "DESC" command in SQL. Therefore, the correct option is (e) None of the above.


3. Which of the following places the common data elements in order from smallest to largest ?

Character, file record, field, database

Character, record, field, file, database

Character, field, record, file, database

Bit, byte, character, record, field, file, database

Answer: Character, field, record, file, database

Explanation:

The correct answer is (c) Character, field, record, file, database. Explanation: A character is the smallest unit of data that can be processed, such as a letter or a number. A field is a collection of characters that represents an attribute of an entity, such as a person's name or address. A record is a collection of fields that represents a complete set of information about an entity, such as a customer or an order. A file is a collection of records, typically of the same type, stored in a single unit, such as a text file or a spreadsheet. A database is a collection of related files that are organized in a way that facilitates efficient retrieval of information. Therefore, the order from smallest to largest common data elements is character, field, record, file, database.


4. A collection of interrelated files in a computer is a _________ ?

file manager

field

record

database

Answer: database

Explanation:

The correct answer is (d) database. A collection of interrelated files in a computer is typically called a database. A database is a structured collection of data that is organized in a way that allows for efficient storage, retrieval, and manipulation of that data.


5. The issues that deals with the collection and use of data about individuals is ?

access

publicity

accuracy

privacy

Answer: privacy

Explanation:

The correct answer is (d) privacy.


6. Data independency in DBMS is known as ?

Data modeling

Data hiding

Data capturing

Data consistency

Answer: Data modeling

Explanation:

Data independency in DBMS is known as data modelling. Q. The function of Data Manipulation is (in DBMS).


7. What does the data dictionary identify ?

Field names

Field types

Field formates

All of the above

Answer: All of the above

Explanation:

All of the above. The data dictionary is a catalog or repository of metadata that contains information about the data in a database. This includes field names, field types, and field formats, as well as other information such as data relationships, data dependencies, and data usage.


8. The database administrator is, in effect, the coordinator between the _____ and the _____ ?

DBMS; database

application program; database

database, users

application programs; users

Answer: database, users

Explanation:

database, users. The database administrator (DBA) is responsible for managing the database and acting as a liaison between the database and the users who access it. The DBA is not directly responsible for coordinating between the DBMS and database, or between application programs and users.


9. E-R modeling technique is a ?

top-down approach

bottom-up approach

left-right approach

both top-down and bottom-up

Answer: top-down approach

Explanation:

The E-R modeling technique is a top-down approach. It involves identifying the entities in a system and the relationships between them, and then creating a diagram to represent this information. Therefore, the correct option is (a) top-down approach.


10. In order to understand DBMS, it is important to understand ?

the physical schema

all sub schema that are system support

one sub schema

Both (a) and (b)

Answer: one sub schema

Explanation:

The correct answer is (d) Both (a) and (b). To understand DBMS (Database Management System), it is important to understand the physical schema which defines how the data is actually stored on the physical storage devices, such as hard disk or SSD. This includes the storage structures, indexing techniques, and access methods used to store and retrieve data efficiently.