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.
| 51. |
In SQL, the ALTER TABLESPACE command is used |
| A. | to add/rename data files |
| B. | to change storage characteristics |
| C. | to take a tablespace online/offline |
| D. | to begin/end a backup |
| Answer» E. | |
| 52. |
In SQL, which command(s) is(are) used to recompile a stored function? |
| A. | SET FUNCTION |
| B. | SET STORED FUNCTION |
| C. | ALTER FUNCTION |
| D. | All of the above |
| Answer» D. All of the above | |
| 53. |
Two files may be joined into a third file if |
| A. | they have a row in common |
| B. | they have a field in common |
| C. | they have no records with the same value in the common field |
| D. | both (b) and (c) |
| Answer» C. they have no records with the same value in the common field | |
| 54. |
A race condition occurs when |
| A. | Two concurrent activities interact to cause a processing error |
| B. | two users of the DBMS are interacting with different files at the same time |
| C. | both (a) and (b) |
| D. | All of the above |
| Answer» B. two users of the DBMS are interacting with different files at the same time | |
| 55. |
A _____ Contains fields of data about one entity. |
| A. | Record |
| B. | File |
| C. | Fields |
| D. | Document |
| Answer» B. File | |
| 56. |
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory? |
| A. | Special purpose packages |
| B. | Custom made programs |
| C. | Single function application packages |
| D. | Data management packages |
| Answer» E. | |
| 57. |
The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a |
| A. | forecasting report |
| B. | exception report |
| C. | regularly scheduled report |
| D. | on demand report |
| Answer» E. | |
| 58. |
Data items grouped together for storage purposes are called a |
| A. | record |
| B. | title |
| C. | list |
| D. | string |
| Answer» B. title | |
| 59. |
Internal auditors should review data system design before they are |
| A. | developed |
| B. | implemented |
| C. | modified |
| D. | All of the above |
| Answer» E. | |
| 60. |
What name is given to the collection of facts, items of information or data which are related in some way? |
| A. | Database |
| B. | Directory information |
| C. | Information tree |
| D. | Information provider |
| Answer» B. Directory information | |
| 61. |
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database? |
| A. | DASD |
| B. | FMS |
| C. | EMMS |
| D. | DBMS |
| Answer» E. | |
| 62. |
In SQL, which command is used to remove a stored function from the database? |
| A. | REMOVE FUNCTION |
| B. | DELETE FUNCTION |
| C. | DROP FUNCTION |
| D. | ERASE FUNCTION |
| Answer» D. ERASE FUNCTION | |
| 63. |
A file that is organized in uniform format is formally referred to as a _____ or a database file. |
| A. | Document |
| B. | Database |
| C. | Record |
| D. | Structured data file |
| Answer» E. | |
| 64. |
In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? |
| A. | CREATE PACKAGE |
| B. | CREATE SCHEMA |
| C. | CREATE CLUSTER |
| D. | All of the above |
| Answer» C. CREATE CLUSTER | |
| 65. |
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As |
| A. | tables |
| B. | relations |
| C. | tuple |
| D. | both (a) and (b) |
| Answer» E. | |
| 66. |
Which of the following is not an advantage of the data-base approach? |
| A. | elimination of the data redundancy |
| B. | ability to associate related data |
| C. | increased security |
| D. | program/data independence |
| Answer» E. | |
| 67. |
Goals for the design of the logical schema include |
| A. | avoiding data inconsistency |
| B. | being able to construct queries easily |
| C. | being able to access data efficiently |
| D. | All of the above |
| Answer» E. | |
| 68. |
Characteristic(s) of a distributed MIS structure is |
| A. | interactive sharing of the workload |
| B. | a multiprocessing environment |
| C. | computers supporting local DP operations |
| D. | All of the above |
| Answer» E. | |
| 69. |
In SQL, which command(s) is(are) used to redefine an index's future storage allocation |
| A. | ALTER INDEX |
| B. | REDEFINE INDEX |
| C. | MODIFY INDEX |
| D. | DO INDEX |
| Answer» B. REDEFINE INDEX | |
| 70. |
Which command is used to select distinct subject (SUB) from the table (BOOK)? |
| A. | SELECT ALL FROM BOOK |
| B. | SELECT DISTINCT SUB FROM BOOK |
| C. | SELECT SUB FROM BOOK |
| D. | All of the above |
| Answer» C. SELECT SUB FROM BOOK | |
| 71. |
A form can be used to |
| A. | modify records |
| B. | delete records |
| C. | format printed output |
| D. | All of the above |
| Answer» E. | |
| 72. |
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called |
| A. | data field |
| B. | data record |
| C. | data file |
| D. | database |
| Answer» B. data record | |
| 73. |
A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file. |
| A. | File structure |
| B. | Records |
| C. | Fields |
| D. | Database |
| Answer» D. Database | |
| 74. |
Which of the following is not the responsibility of the utilities component of DBMS software? |
| A. | creating the physical and logical designs |
| B. | removing flagged records for deletion |
| C. | creating and maintaining the data dictionary |
| D. | monitoring performance |
| Answer» B. removing flagged records for deletion | |
| 75. |
Large collections of files are called |
| A. | fields |
| B. | records |
| C. | databases |
| D. | file system |
| Answer» D. file system | |
| 76. |
The model for a record management system might be |
| A. | handwritten list |
| B. | a Rolodex card file |
| C. | a business form |
| D. | All of the above |
| Answer» E. | |
| 77. |
When performing a look-up operation using a form |
| A. | you enter the search value into the form |
| B. | you look at each form sequentially until you see the one you want |
| C. | you type the key in an entry line, and the correct form is displayed |
| D. | All of the above |
| Answer» B. you look at each form sequentially until you see the one you want | |
| 78. |
The data dictionary tells the DBMS |
| A. | what files are in the database |
| B. | what attribute are possessed by the data |
| C. | what these files contain |
| D. | All of the above |
| Answer» E. | |
| 79. |
The way a particular application views the data from the data base that the application uses is a : |
| A. | module |
| B. | relational model |
| C. | schema |
| D. | subschema |
| Answer» E. | |
| 80. |
A top-to-bottom relationship among the items in a database is established by a |
| A. | Hierarchical schema |
| B. | Network schema |
| C. | Relational schema |
| D. | All of the above |
| Answer» B. Network schema | |
| 81. |
A _____ means that one record in a particular record type may be related to more than one record of another record type. |
| A. | One-to-one relationship |
| B. | One-to-many relationship |
| C. | Many-to-one relationship |
| D. | Many-to many relationship |
| Answer» C. Many-to-one relationship | |
| 82. |
Which of the following hardware components is the most important to the operation of a database management system? |
| A. | high-resolution video display |
| B. | printer |
| C. | high speed, large-capacity disk |
| D. | plotter |
| Answer» D. plotter | |
| 83. |
If the record management system allows you to edit values before they are recorded on disk, you can |
| A. | correct spelling changes before they are recorded |
| B. | change the name of a field |
| C. | change the width of a field |
| D. | All of the above |
| Answer» B. change the name of a field | |
| 84. |
A network schema |
| A. | restricts the structure to a one-to-many relationship |
| B. | permits many-to-many relation¬ships |
| C. | stores data in tables |
| D. | All of the above |
| Answer» C. stores data in tables | |
| 85. |
A file produced by a spreadsheet |
| A. | is generally stored on disk in an ASCII text format |
| B. | can be used as it by the DBMS |
| C. | can be used for graphic |
| D. | All of the above |
| Answer» B. can be used as it by the DBMS | |
| 86. |
A _____ means that one record in a particular record type is related to only one record of another record type. |
| A. | One-to-one relationship |
| B. | One-to-many relationship |
| C. | Many-to-one relationship |
| D. | Many-to-many relationship |
| Answer» B. One-to-many relationship | |
| 87. |
Related fields in a data base are grouped to form |
| A. | data file |
| B. | data record |
| C. | menu |
| D. | bank |
| Answer» C. menu | |
| 88. |
In SQL, which command(s) is(are) used to enable/disable all triggers on a table? |
| A. | ALTER TRIGGERS |
| B. | ALTER TABLE |
| C. | MODIFY TRIGGERS IN TABLE |
| D. | All of the above |
| Answer» C. MODIFY TRIGGERS IN TABLE | |
| 89. |
An operation that will increase the length of a list is |
| A. | Insert |
| B. | Look-up |
| C. | Modify |
| D. | All of the above |
| Answer» B. Look-up | |
| 90. |
A scheme describes |
| A. | data elements |
| B. | records and files |
| C. | record relationships |
| D. | All of the above |
| Answer» E. | |
| 91. |
Data integrity control |
| A. | is used to set upper and lower limits on numeric data |
| B. | requires the use of passwords to prohibit unauthorized access to the file |
| C. | has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files |
| D. | All of the above |
| Answer» D. All of the above | |
| 92. |
Updating a database means |
| A. | revising the file structure |
| B. | reorganizing the database |
| C. | modifying or adding record occurrences |
| D. | All of the above |
| Answer» D. All of the above | |
| 93. |
In SQL, which command(s) is(are) used to change a table's storage characteristics? |
| A. | ALTER TABLE |
| B. | MODIFY TABLE |
| C. | CHANGE TABLE |
| D. | All of the above |
| Answer» B. MODIFY TABLE | |
| 94. |
A form defines |
| A. | where data is placed on the screen |
| B. | the width of each field |
| C. | both (a) and (b) |
| D. | All of the above |
| Answer» D. All of the above | |
| 95. |
In SQL, which command is used to add a column/integrity constraint to a table |
| A. | ADD COLUMN |
| B. | INSERT COLUMN |
| C. | MODIFY TABLE |
| D. | ALTER TABLE |
| Answer» E. | |
| 96. |
The relational model uses some unfamiliar terminology. A tuple is equivalent to a: |
| A. | record |
| B. | field |
| C. | file |
| D. | data base |
| Answer» B. field | |
| 97. |
In SQL, which command is used to changes data in a table? |
| A. | UPDATE |
| B. | INSERT |
| C. | BROWSE |
| D. | APPEND |
| Answer» B. INSERT | |
| 98. |
Which of the following is not a relational database? |
| A. | dBASE IV |
| B. | 4th Dimension |
| C. | FoxPro |
| D. | Reflex |
| Answer» E. | |
| 99. |
In SQL, the CREATE VIEW command is used |
| A. | to recompile view |
| B. | to define a view of one or more tables or views |
| C. | to recompile a table |
| D. | to create a trigger |
| Answer» C. to recompile a table | |
| 100. |
A large computer information system maintains many different computer files. Which amongst them is called a perpetual file? |
| A. | Specialized file |
| B. | Log file |
| C. | Master file |
| D. | Update file |
| Answer» D. Update file | |