About Programming MCQs
Programming is the cornerstone of computer science and IT. MCQs on this subject test your understanding of syntax, logic, data structures, and algorithms across various programming languages. Whether you are preparing for a university exam or a technical job interview, these questions will sharpen your problem-solving skills.
Topics Covered in This Category
- Language Fundamentals: C, C++, Java, Python, and PHP basics.
- Data Structures: Arrays, linked lists, stacks, queues, trees, and graphs.
- Algorithms: Sorting, searching, recursion, and time complexity.
- Object-Oriented Programming (OOP): Classes, objects, inheritance, polymorphism, and encapsulation.
Study Tips for Programming MCQs
Programming is best learned by doing. Do not just read the code; type it out and run it. Trace algorithms on paper to understand how variables change. When solving MCQs, pay attention to subtle syntax errors, loop conditions, and array indices, as these are common traps in exams.
Question 101: Versatile report generators can provide
- A Subtotals
- B Columnar totals
- C All of the above
- D Calculations
- E None of the above
Explanation: The correct answer to the question is: All of the above
Question 102: The logical data structure with a one-to-many relationship is a :
- A network
- B None of the above
- C tree
- D relational
- E chain
Explanation: The correct answer to the question is: tree
Question 103: If you want to group the records in the abc database, you could use the Jobcode as the _____.
- A Index
- B Update
- C Delete
- D Sort Key
- E None of the above
Explanation: The correct answer to the question is: Sort Key
Question 104: Which of the following is a database administrator's function?
- A user coordination
- B backing up the database
- C All of the above
- D performance monitoring
- E database design
Explanation: The correct answer to the question is: All of the above
Question 105: Primitive operations common to all record management systems include
- A Sort
- B Look-up
- C All of the above
- D Print
- E None of the above
Explanation: The correct answer to the question is: Look-up
Question 106: A logical schema
- A All of the above
- B is a standard way of organizing information into accessible parts
- C is the entire database
- D describes how data is actually stored on disk
- E None of the above
Explanation: The correct answer to the question is: is a standard way of organizing information into accessible parts
Question 107: Batch processing is appropriate if
- A only a small computer system is available
- B only a few transactions are involved
- C a large computer system is available
- D None of the above
- E All of the above
Explanation: The correct answer to the question is: None of the above
Question 108: It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
- A Table
- B None of the above
- C Flat File
- D Record
- E Database
Explanation: The correct answer to the question is: Database
Question 109: Updating a database means
- A modifying or adding record occurrences
- B All of the above
- C revising the file structure
- D None of the above
- E reorganizing the database
Explanation: The correct answer to the question is: modifying or adding record occurrences
Question 110: Sophisticated report generators can
- A None of the above
- B selectively retrieve and print portions of a list
- C perform arithmetic operations
- D All of the above
- E print row-oriented reports
Explanation: The correct answer to the question is: All of the above
Question 111: A scheme describes
- A record relationships
- B All of the above
- C records and files
- D data elements
- E None of the above
Explanation: The correct answer to the question is: All of the above
Question 112: The data dictionary tells the DBMS
- A what these files contain
- B All of the above
- C what attribute are possessed by the data
- D None of the above
- E what files are in the database
Explanation: The correct answer to the question is: All of the above
Question 113: Embedded pointer provide
- A a physical record key
- B None of the above
- C an inverted index
- D All of the above
- E a secondary access path
Explanation: The correct answer to the question is: a secondary access path
Question 114: In SQL, which command(s) is(are) used to redefine an index's future storage allocation
- A REDEFINE INDEX
- B ALTER INDEX
- C MODIFY INDEX
- D None of the above
- E DO INDEX
Explanation: The correct answer to the question is: ALTER INDEX
Question 115: Related fields in a data base are grouped to form
- A data file
- B None of the above
- C bank
- D data record
- E menu
Explanation: The correct answer to the question is: data record
Question 116: Which of the following is true of a network structure?
- A It allows a many-to-many relationship
- B It is conceptually simple
- C None of the above
- D It will be the dominant data base of the future
- E It is a physical representation of the data
Explanation: The correct answer to the question is: It allows a many-to-many relationship
Question 117: In SQL, which command is used to select data in rows and column from one or more tables?
- A SELECT
- B None of the above
- C BROWSE
- D LIST
- E CHOOSE
Explanation: The correct answer to the question is: SELECT
Question 118: A data dictionary doesn't provide information about:
- A It allows a many-to-many relationship
- B where data is located
- C It is conceptually simple
- D the size of the disk storage device
- E It will be the dominant data base of the future
Explanation: The correct answer to the question is: the size of the disk storage device
Question 119: The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
- A exception report
- B on demand report
- C None of the above
- D forecasting report
- E regularly scheduled report
Explanation: The correct answer to the question is: on demand report
Question 120: A form defines
- A None of the above
- B the width of each field
- C where data is placed on the screen
- D All of the above
- E both (a) and (b)
Explanation: The correct answer to the question is: both (a) and (b)
Question 121: A file produced by a spreadsheet
- A can be used as it by the DBMS
- B All of the above
- C None of the above
- D can be used for graphic
- E is generally stored on disk in an ASCII text format
Explanation: The correct answer to the question is: is generally stored on disk in an ASCII text format
Question 122: The data-base environment has all of the following components except:
- A separate files
- B users
- C data base
- D data-base administrator
- E None of the above
Explanation: The correct answer to the question is: separate files
Question 123: Internal auditors should review data system design before they are
- A implemented
- B modified
- C None of the above
- D All of the above
- E developed
Explanation: The correct answer to the question is: All of the above
Question 124: To have a file hold a list, it is necessary to
- A identify the name, width and type of the fields of each record.
- B decide which fields will be used as sort or index keys
- C identify the records in the list
- D None of the above
- E All of the above
Explanation: The correct answer to the question is: All of the above
Question 125: In SQL, which command is used to remove a stored function from the database?
- A ERASE FUNCTION
- B REMOVE FUNCTION
- C None of the above
- D DROP FUNCTION
- E DELETE FUNCTION
Explanation: The correct answer to the question is: DROP FUNCTION
Question 126: In the DBM approach, application programs perform the
- A access control
- B None of the above
- C processing functions
- D storage function
- E All of the above
Explanation: The correct answer to the question is: processing functions
Question 127: In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
- A ALTER TABLE
- B None of the above
- C ALTER TRIGGERS
- D MODIFY TRIGGERS IN TABLE
- E All of the above
Explanation: The correct answer to the question is: ALTER TABLE
Question 128: Which of the following is a type of DBMS software?
- A All of the above
- B utilities
- C report writer
- D database manipulation language
- E query language
Explanation: The correct answer to the question is: database manipulation language
Question 129: In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
- A ZIP
- B PACK
- C COMMIT
- D None of the above
- E SAVE
Explanation: The correct answer to the question is: COMMIT
Question 130: A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
- A tuple
- B None of the above
- C tables
- D both (a) and (b)
- E relations
Explanation: The correct answer to the question is: both (a) and (b)
Question 131: A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
- A the last name
- B All of the above
- C a compound key consisting of the first name and the last name
- D None of the above
- E the pin code
Explanation: The correct answer to the question is: a compound key consisting of the first name and the last name
Question 132: Periodically adding, changing and deleting file records is called file
- A upgrading
- B Updating
- C restructuring
- D None of the above
- E renewing
Explanation: The correct answer to the question is: Updating
Question 133: A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
- A None of the above
- B File structure
- C Database
- D Fields
- E Records
Explanation: The correct answer to the question is: Fields
Question 134: In SQL, the _____ command is used to recompile a view
- A ALTER VIEW
- B CREATE VIEW
- C None of the above
- D DEFINE VIEW
- E COMPILE VIEW
Explanation: The correct answer to the question is: ALTER VIEW
Question 135: If a piece of data is stored in two places in the database, then
- A changing the data is one spot will cause data inconsistency
- B None of the above
- C both (a) and (b)
- D it can be more easily accessed
- E storage space is wasted
Explanation: The correct answer to the question is: both (a) and (b)
Question 136: What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
- A None of the above
- B DASD
- C DBMS
- D EMMS
- E FMS
Explanation: The correct answer to the question is: DBMS
Question 137: The way a particular application views the data from the data base that the application uses is a :
- A module
- B schema
- C subschema
- D None of the above
- E relational model
Explanation: The correct answer to the question is: subschema