💻 Computing Solved MCQs with Answers

Practice 1954 approved 💻 Computing questions with verified answers from the 💾 Computer Science subject for Pakistan exams.

1954 solved MCQs

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?Answer: COMMIT Periodically adding, changing and deleting file records is called fileAnswer: Updating Sort/report generatorsAnswer: Require more disk space than index/report generators The data dictionary tells the DBMSAnswer: All of the above In SQL, which command(s) is(are) used to enable/disable a database trigger?Answer: ALTER TRIGGER If the record management system allows you to edit values before they are recorded on disk, you canAnswer: correct spelling changes before they are recorded The relational model uses some unfamiliar terminology. A tuple is equivalent to a:Answer: record The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?Answer: Data field Which command is used to remove an index from the database in SQL?Answer: DROP INDEX An-owner-member set in the CODASYL specifications may haveAnswer: only one owner but many owner occurrences What is the name given to the database management system which is able to handle full text data, image data, audio and video?Answer: Multimedia A top-to-bottom relationship among the items in a database is established by aAnswer: Hierarchical schema A database management systemAnswer: both (a) and (b) Which of the following hardware components is the most important to the operation of a database management system?Answer: high speed, large-capacity disk The PROJECT command will create new table that hasAnswer: None of the above To have a file hold a list, it is necessary toAnswer: All of the above Sophisticated report generators canAnswer: All of the above In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.Answer: Hierarchical database Which two files are used during operation of the DBMS?Answer: data dictionary and transaction log When using a database management system, the first thing that you must do is toAnswer: load the software into your microÂ¬computer A network schemaAnswer: permits many-to-many relationÂ¬ships Which of the following is not a relational database?Answer: Reflex Which command is used to remove a table from the database in SQL?Answer: DROP TABLE A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?Answer: Master file A file produced by a spreadsheetAnswer: is generally stored on disk in an ASCII text format A form definesAnswer: both (a) and (b) Which of the following is true of a network structure?Answer: It allows a many-to-many relationship In SQL, GRANT command is used toAnswer: grant system privileges, roles, and object privileges to uses and roles The highest level in the hierarchy of data organization is calledAnswer: database The logical data structure with a one-to-many relationship is a :Answer: tree