MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 155 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Versatilereportgeneratorscan provide |
| A. | olumnar totals |
| B. | ubtotals |
| C. | alculations |
| D. | ll of the above |
| E. | one of the above |
| Answer» E. one of the above | |
| 2. |
An-owner-membersetinthe CODASYL specifications may have |
| A. | nly one owner but many owner occurrences |
| B. | nly one member but many member occurrence |
| C. | ore than one member but only one occurrence per member |
| D. | ll of the above |
| E. | one of the above |
| Answer» B. nly one member but many member occurrence | |
| 3. |
If a piece of data is stored in two places in the database, then |
| A. | is in ascending order |
| B. | is the result of a sort operation |
| C. | both (b) and (c) |
| D. | None of the above |
| Answer» E. | |
| 4. |
The index consists of |
| A. | a list of keys |
| B. | pointers to the master list |
| C. | both (a) and (b) |
| D. | All of the above |
| Answer» D. All of the above | |
| 5. |
Queries to a database |
| A. | are written in English |
| B. | can use aggregate functions like SUM and COUNT |
| C. | both (a) and (b) |
| D. | All of the above |
| Answer» C. both (a) and (b) | |
| 6. |
Versatile report generators can provide |
| A. | Columnar totals |
| B. | Subtotals |
| C. | Calculations |
| D. | All of the above |
| Answer» E. | |
| 7. |
Subschema can be used to |
| A. | create very different, personalized views of the same data |
| B. | present information in different formats |
| C. | hide sensitive information by omitting fields from the sub¬schema's description |
| D. | All of the above |
| Answer» E. | |
| 8. |
The modify operation is likely to be done after |
| A. | Delete |
| B. | Look-up |
| C. | Insert |
| D. | All of the above |
| Answer» C. Insert | |
| 9. |
A set of programs that handle a firm's data base responsibilities is called a |
| A. | Data Base Management System (DBMS) |
| B. | Data Base Processing System (DBPS) |
| C. | Data Management System (DMS) |
| D. | All of the above |
| Answer» E. | |
| 10. |
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL? |
| A. | DEFINE TABLE |
| B. | MODIFY TABLE |
| C. | ALTER TABLE |
| D. | All of the above |
| Answer» D. All of the above | |
| 11. |
The distinguishable parts of a record are called |
| A. | files |
| B. | data |
| C. | fields |
| D. | database |
| Answer» D. database | |
| 12. |
In SQL, the CREATE TABLE is used |
| A. | to create a table, defining its columns, integrity constrains, and storage allocation |
| B. | to add a column/integrity constraint to a table |
| C. | to redefine a column |
| D. | to change a table's storage characteristics |
| Answer» B. to add a column/integrity constraint to a table | |
| 13. |
An audit trail |
| A. | is used to make back-up copies |
| B. | is the recorded history of operations performed on a file |
| C. | can be used to restore lost information |
| D. | All of the above |
| Answer» C. can be used to restore lost information | |
| 14. |
With respect to data input, the most accurate description of batch control is |
| A. | dividing documents to be entered into batches |
| B. | controlling the input of each input clerk |
| C. | comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system |
| D. | All of the above |
| Answer» D. All of the above | |
| 15. |
Long-range planning report produced in an MIS are primarily designed for |
| A. | top management |
| B. | middle management |
| C. | lower management |
| D. | All of the above |
| Answer» B. middle management | |
| 16. |
An indexing operation |
| A. | sorts a file using a single key |
| B. | sorts file using two keys |
| C. | establishes an index for a file |
| D. | both (b) and (c) |
| Answer» D. both (b) and (c) | |
| 17. |
A data dictionary doesn't provide information about: |
| A. | where data is located |
| B. | the size of the disk storage device |
| C. | It allows a many-to-many relationship |
| D. | It is conceptually simple |
| Answer» C. It allows a many-to-many relationship | |
| 18. |
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields. |
| A. | Network |
| B. | Hierarchical |
| C. | Relational |
| D. | Object-Oriented |
| Answer» D. Object-Oriented | |
| 19. |
The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in |
| A. | a tree file |
| B. | an indexed file |
| C. | a hashed file |
| D. | a sequential file |
| Answer» D. a sequential file | |
| 20. |
One approach to standardizing storing of data |
| A. | MIS |
| B. | structured programming |
| C. | CODASYL specifications |
| D. | All of the above |
| Answer» D. All of the above | |
| 21. |
It is more accurate to define a _____ as a variety of different record types that are treated as a single unit |
| A. | Database |
| B. | Table |
| C. | Record |
| D. | Flat File |
| Answer» B. Table | |
| 22. |
One data dictionary software package is called |
| A. | DB/DC dictionary |
| B. | TOTAL |
| C. | ACCESS |
| D. | any of the above |
| Answer» B. TOTAL | |
| 23. |
In the DBM approach, application programs perform the |
| A. | storage function |
| B. | processing functions |
| C. | access control |
| D. | All of the above |
| Answer» C. access control | |
| 24. |
In a large DBMS |
| A. | each user can "see" only a small part of the entire database |
| B. | each user can access every sub¬schema |
| C. | each subschema contains every field in the logical schema |
| D. | All of the above |
| Answer» B. each user can access every sub¬¨schema | |
| 25. |
Which of the following command(s) is(are) used to recompile a stored procedure in SQL? |
| A. | COMPILE PROCEDURE |
| B. | ALTER PROCEDURE |
| C. | MODIFY PROCEDURE id) All of the above |
| D. | None of the above |
| Answer» C. MODIFY PROCEDURE id) All of the above | |
| 26. |
A condition that led to the development of databases was |
| A. | a demand for more data to support information needs |
| B. | an increase in the amount of data handled by organizations |
| C. | the proliferation of data files |
| D. | All of the above |
| Answer» E. | |
| 27. |
If a piece of data is stored in two places in the database, then |
| A. | storage space is wasted |
| B. | changing the data is one spot will cause data inconsistency |
| C. | it can be more easily accessed |
| D. | both (a) and (b) |
| Answer» E. | |
| 28. |
Which of the following is a type of DBMS software? |
| A. | database manipulation language |
| B. | query language |
| C. | utilities |
| D. | report writer |
| Answer» B. query language | |
| 29. |
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time? |
| A. | report writer |
| B. | query language |
| C. | data manipulation language |
| D. | transaction log |
| Answer» E. | |
| 30. |
Administrate supervision of database activities is the responsibility of the |
| A. | Database administrator |
| B. | DP Manager |
| C. | DB Manager |
| D. | DP administration |
| Answer» B. DP Manager | |
| 31. |
A compound key |
| A. | is made up a several pieces of information |
| B. | uniquely identifies an item in a list |
| C. | both (a) and (b) |
| D. | is a combination of each unique key |
| Answer» D. is a combination of each unique key | |
| 32. |
In SQL, the _____ command is used to recompile a view |
| A. | COMPILE VIEW |
| B. | DEFINE VIEW |
| C. | CREATE VIEW |
| D. | ALTER VIEW |
| Answer» E. | |
| 33. |
If you want your database to include methods, you should use a _____ database. |
| A. | Network |
| B. | Distributed |
| C. | Hierarchical |
| D. | Object-Oriented |
| Answer» E. | |
| 34. |
Which command(s) is(are) used to redefine a column of the table in SQL ? |
| A. | ALTER TABLE |
| B. | DEFINE TABLE |
| C. | MODIFY TABLE |
| D. | All of the above |
| Answer» B. DEFINE TABLE | |
| 35. |
Which of the following is not characteristic of a relational database model? |
| A. | tables |
| B. | treelike structure |
| C. | complex logical relationships |
| D. | records |
| Answer» C. complex logical relationships | |
| 36. |
A list in alphabetical order |
| A. | is in descending order |
| B. | is in ascending order |
| C. | is the result of a sort operation |
| D. | both (b) and (c) |
| Answer» E. | |
| 37. |
The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types. |
| A. | Database |
| B. | Table |
| C. | Flat file |
| D. | Data structure |
| Answer» D. Data structure | |
| 38. |
The data-base environment has all of the following components except: |
| A. | users |
| B. | separate files |
| C. | data base |
| D. | data-base administrator |
| Answer» C. data base | |
| 39. |
Which of the following is a serious problem of file management systems? |
| A. | difficult to update |
| B. | lack of data independence |
| C. | data redundancy |
| D. | program dependence |
| Answer» E. | |
| 40. |
A logical schema |
| A. | is the entire database |
| B. | is a standard way of organizing information into accessible parts |
| C. | describes how data is actually stored on disk |
| D. | All of the above |
| Answer» C. describes how data is actually stored on disk | |
| 41. |
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa. |
| A. | One-to-one relationship |
| B. | One-to-many relationship |
| C. | Many-to-one relationship |
| D. | Many-to-many relationship |
| Answer» E. | |
| 42. |
The activity of a file |
| A. | is a low percentages of number of records added or deleted from a file |
| B. | if high, reduces processing efficiency for sequential and nonsequential files |
| C. | is a measure of the percentage of existing records updated during a run |
| D. | refers to how closely the files fits into the allocated |
| Answer» B. if high, reduces processing efficiency for sequential and nonsequential files | |
| 43. |
The language used in application programs to request data from the DBMS is referred to as the |
| A. | DML |
| B. | DDL |
| C. | query language |
| D. | All of the above |
| Answer» B. DDL | |
| 44. |
Database management systems are intended to: |
| A. | eliminate data redundancy |
| B. | establish relationships among records in different files |
| C. | manage file access |
| D. | maintain data integrity |
| Answer» E. | |
| 45. |
The _____ command is used to allocates an extent for the table in SQL |
| A. | MODIFY ALLOCATES |
| B. | MODIFY TABLE |
| C. | ALTER TABLE |
| D. | REDEFINE TABLE |
| Answer» B. MODIFY TABLE | |
| 46. |
In SQL, which command is used to create a database user? |
| A. | ADD USER TO DATABASE |
| B. | MK USER |
| C. | CREATE USER |
| D. | All of the above |
| Answer» D. All of the above | |
| 47. |
The database administration function includes |
| A. | application programming |
| B. | computer operations management |
| C. | database access planning |
| D. | All of the above |
| Answer» D. All of the above | |
| 48. |
Batch processing is appropriate if |
| A. | a large computer system is available |
| B. | only a small computer system is available |
| C. | only a few transactions are involved |
| D. | All of the above |
| Answer» E. | |
| 49. |
A computer file contains several records. What does each record contain? |
| A. | Bytes |
| B. | Words |
| C. | Fields |
| D. | Database |
| Answer» D. Database | |
| 50. |
Which language has recently become the de-facto standard for interfacing application programs with relational database system? |
| A. | Oracle |
| B. | SQL |
| C. | dBASE |
| D. | 4GL |
| Answer» C. dBASE | |