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 1: In SQL, which command is used to select only one copy of each set of duplicable rows
- A SELECT DISTINCT
- B SELECT DIFFERENT
- C None of the above
- D All of the above
- E SELECT UNIQUE
Explanation: The correct answer to the question is: SELECT DISTINCT
Question 2: Which of the following is not the responsibility of the utilities component of DBMS software?
- A removing flagged records for deletion
- B None of the above
- C monitoring performance
- D creating the physical and logical designs
- E creating and maintaining the data dictionary
Explanation: The correct answer to the question is: creating the physical and logical designs
Question 3: Which of the following is not a logical data-base structure?
- A network
- B tree
- C relational
- D chain
- E All of the above
Explanation: The correct answer to the question is: chain
Question 4: In SQL, which command is used to changes data in a table?
- A INSERT
- B None of the above
- C BROWSE
- D UPDATE
- E APPEND
Explanation: The correct answer to the question is: UPDATE
Question 5: The PROJECT command will create new table that has
- A both (a) and (b)
- B all the fields of master table
- C more rows than the original table
- D more fields than the original table
- E None of the above
Explanation: The correct answer to the question is: None of the above
Question 6: A file that is organized in uniform format is formally referred to as a _____ or a database file.
- A None of the above
- B Structured data file
- C Record
- D Database
- E Document
Explanation: The correct answer to the question is: Structured data file
Question 7: The activity of a file
- A if high, reduces processing efficiency for sequential and nonsequential files
- B is a low percentages of number of records added or deleted from a file
- C is a measure of the percentage of existing records updated during a run
- D None of the above.
- E refers to how closely the files fits into the allocated
Explanation: The correct answer to the question is: is a low percentages of number of records added or deleted from a file
Question 8: In SQL, the CREATE VIEW command is used
- A None of the above
- B to define a view of one or more tables or views
- C to recompile view
- D to recompile a table
- E to create a trigger
Explanation: The correct answer to the question is: to define a view of one or more tables or views
Question 9: The language used in application programs to request data from the DBMS is referred to as the
- A All of the above
- B DDL
- C None of the above
- D DML
- E query language
Explanation: The correct answer to the question is: DML
Question 10: The distinguishable parts of a record are called
- A data
- B database
- C fields
- D files
- E None of the above
Explanation: The correct answer to the question is: fields
Question 11: Large collections of files are called
- A databases
- B records
- C fields
- D file system
- E None of the above
Explanation: The correct answer to the question is: databases
Question 12: A report generator is used to
- A All of the above
- B update files
- C data entry
- D None of the above
- E print files on paper
Explanation: The correct answer to the question is: print files on paper
Question 13: The main idea behind computer files is that it is convenient to
- A create them
- B store information together
- C arrange them
- D None of the above
- E access them
Explanation: The correct answer to the question is: store information together
Question 14: In SQL, GRANT command is used to
- A allow user to access databases
- B grant system privileges, roles, and object privileges to uses and roles
- C choose auditing for specific SQL commands
- D allow user to create databases
- E None of the above
Explanation: The correct answer to the question is: grant system privileges, roles, and object privileges to uses and roles
Question 15: The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
- A data item
- B field
- C record
- D file
- E data base
Explanation: The correct answer to the question is: record
Question 16: Data encryption techniques are particularly useful for
- A protecting data in data communication systems
- B None of the above
- C reducing storage space requirements
- D improving data integrity
- E All of the above
Explanation: The correct answer to the question is: protecting data in data communication systems
Question 17: Which of the following is not true of the traditional approach to information processing?
- A Programs are dependent on the files
- B It is file-oriented
- C There is common sharing of data among the various applications
- D All of the above are true
- E It is inflexible
Explanation: The correct answer to the question is: There is common sharing of data among the various applications
Question 18: The model for a record management system might be
- A handwritten list
- B a Rolodex card file
- C a business form
- D None of the above
- E All of the above
Explanation: The correct answer to the question is: All of the above
Question 19: The Management Information system (MIS) structure with one main computer system is called a
- A hierarchical MIS structure
- B centralized MIS structure
- C distributed MIS structure
- D decentralized MIS structure
- E None of the above
Explanation: The correct answer to the question is: centralized MIS structure
Question 20: In order to use a record management system
- A Both (a) and (b)
- B None of the above
- C You need to understand the model the record management system uses.
- D You need to understand the low-level details of how information in stored
- E All of the above
Explanation: The correct answer to the question is: You need to understand the model the record management system uses.
Question 21: A _____ Contains fields of data about one entity.
- A None of the above
- B Document
- C File
- D Record
- E Fields
Explanation: The correct answer to the question is: Record
Question 22: In SQL, which command is used to add new rows to a table?
- A APPEND
- B ADD ROW
- C ALTER TABLE
- D None of the above
- E INSERT
Explanation: The correct answer to the question is: INSERT
Question 23: Which of the following is not characteristic of a relational database model?
- A complex logical relationships
- B None of the above
- C records
- D tables
- E treelike structure
Explanation: The correct answer to the question is: treelike structure
Question 24: 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 data manipulation language
- B transaction log
- C report writer
- D query language
- E None of the above
Explanation: The correct answer to the question is: transaction log
Question 25: A data dictionary is a special file that contains
- A the widths of all fields in all files
- B the names of all fields in all files
- C the data types of all fields in all files
- D All of the above
- E None of the above
Explanation: The correct answer to the question is: All of the above
Question 26: Queries to a database
- A can use aggregate functions like SUM and COUNT
- B are written in English
- C None of the above
- D All of the above
- E both (a) and (b)
Explanation: The correct answer to the question is: can use aggregate functions like SUM and COUNT
Question 27: A race condition occurs when
- A two users of the DBMS are interacting with different files at the same time
- B All of the above
- C both (a) and (b)
- D None of the above
- E Two concurrent activities interact to cause a processing error
Explanation: The correct answer to the question is: Two concurrent activities interact to cause a processing error
Question 28: What is the name given to the database management system which is able to handle full text data, image data, audio and video?
- A Graphics media
- B Hypertext
- C None of the above
- D Full media
- E Multimedia
Explanation: The correct answer to the question is: Multimedia
Question 29: Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
- A None of the above
- B None of the above
- C ALTER PROCEDURE
- D COMPILE PROCEDURE
- E MODIFY PROCEDURE id) All of the above
Explanation: The correct answer to the question is: ALTER PROCEDURE
Question 30: Which of the following is not a relational database?
- A None of the above
- B Reflex
- C FoxPro
- D 4th Dimension
- E dBASE IV
Explanation: The correct answer to the question is: Reflex
Question 31: A list in alphabetical order
- A is in descending order
- B is the result of a sort operation
- C both (b) and (c)
- D is in ascending order
- E None of the above
Explanation: The correct answer to the question is: both (b) and (c)
Question 32: An indexing operation
- A None of the above
- B establishes an index for a file
- C sorts file using two keys
- D both (b) and (c)
- E sorts a file using a single key
Explanation: The correct answer to the question is: establishes an index for a file
Question 33: The model for a _____ resembles the hierarchical model in many respects.
- A Hierarchical database
- B Relational database
- C Distributed database
- D None of the above
- E Network database
Explanation: The correct answer to the question is: Network database
Question 34: A compound key
- A is a combination of each unique key
- B both (a) and (b)
- C uniquely identifies an item in a list
- D None of the above
- E is made up a several pieces of information
Explanation: The correct answer to the question is: both (a) and (b)
Question 35: When you have finished entering information into a form
- A All of the above
- B the template is written to the data file
- C the contents of the form are written to the data file
- D the contents of the form can be printed
- E None of the above
Explanation: The correct answer to the question is: the contents of the form are written to the data file
Question 36: Which of the following is a serious problem of file management systems?
- A All of the above
- B program dependence
- C data redundancy
- D difficult to update
- E lack of data independence
Explanation: The correct answer to the question is: All of the above
Question 37: Characteristic(s) of a distributed MIS structure is
- A computers supporting local DP operations
- B All of the above
- C interactive sharing of the workload
- D None of the above
- E a multiprocessing environment
Explanation: The correct answer to the question is: All of the above
Question 38: A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
- A None of the above
- B Network
- C Relational
- D Hierarchical
- E Object-Oriented
Explanation: The correct answer to the question is: Relational
Question 39: A command that lets you change one or more fields in a record is
- A Insert
- B None of the above
- C Modify
- D Look-up
- E All of the above
Explanation: The correct answer to the question is: Modify
Question 40: What is the language used by most of the DBMSs for helping their users to access data?
- A High level language
- B 4GL
- C None of the above
- D SQL
- E Query language
Explanation: The correct answer to the question is: Query language
Question 41: Each of data files has a _____ that describe the way the data is stored in the file.
- A File structure
- B Records
- C Database
- D Fields
- E None of the above
Explanation: The correct answer to the question is: File structure
Question 42: In SQL, which command is used to add a column/integrity constraint to a table
- A None of the above
- B ALTER TABLE
- C ADD COLUMN
- D INSERT COLUMN
- E MODIFY TABLE
Explanation: The correct answer to the question is: ALTER TABLE
Question 43: If a calculation is embedded in a form
- A the calculations are stored with the form
- B the result of the calculations are printed in report
- C All of the above
- D None of the above
- E the result of the calculations are stored with the form
Explanation: The correct answer to the question is: the calculations are stored with the form
Question 44: A number of related records that are treated as a unit is called
- A field
- B data
- C file
- D batch
- E None of the above
Explanation: The correct answer to the question is: file
Question 45: In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
- A data record
- B data file
- C data field
- D database
- E None of the above
Explanation: The correct answer to the question is: data field
Question 46: A computer file contains several records. What does each record contain?
- A Fields
- B None of the above
- C Words
- D Database
- E Bytes
Explanation: The correct answer to the question is: Fields
Question 47: The highest level in the hierarchy of data organization is called
- A data file
- B None of the above
- C data bank
- D data record
- E database
Explanation: The correct answer to the question is: database
Question 48: An operation that will increase the length of a list is
- A All of the above
- B Modify
- C None of the above
- D Insert
- E Look-up
Explanation: The correct answer to the question is: Insert
Question 49: Which of the following hardware components is the most important to the operation of a database management system?
- A plotter
- B high-resolution video display
- C high speed, large-capacity disk
- D mouse
- E printer
Explanation: The correct answer to the question is: high speed, large-capacity disk
Question 50: In SQL, which of the following is not a data Manipulation Language Commands?
- A SELECT
- B UPDATE
- C DELETE
- D CREATE
- E None of the above
Explanation: The correct answer to the question is: CREATE