COPA ITI 100 MCQ Test | DGT CTS 2.0 Interview Questions
COPA - Computer Operator & Programming Assistant
100 Technical MCQ Online Test | CTS 2.0
Computer Operator and Programming Assistant (COPA) - Revised July 2022 - NSQF Level 3
Open DGT Curriculum PDF
Quiz Completed
About this practice set
This page holds 100 multiple-choice questions for COPA - Computer Operator & Programming Assistant, written to follow the CTS 2.0 syllabus of the Directorate General of Training (DGT) where the source reference above applies. It suits ITI trainees preparing for the all India trade test, for campus or apprenticeship interviews and for quick revision before a viva. The quiz checks each answer and gives an explanation; the full answer key follows so the questions are also readable without running the quiz.
How to use this quiz
- Attempt the questions in one sitting without searching for answers.
- Read the explanation shown after each answer, even when you were right.
- Write down the questions you missed and the reason in your own words.
- Open the answer key below to revise those questions.
- Retake the quiz after a day or two and compare your score.
Sample of what is covered
- What is the duration of the COPA trade in the curriculum?
- Which component is the main circuit board of a computer?
- Which Linux distribution is specifically installed in the syllabus?
- What is Track Changes used for?
- Which function returns characters from the left side of text?
- What is a hyperlink in a presentation?
- Which SQL category includes commands for defining database structures?
- What is an index used for in a database?
Answer key with explanations (100 questions)
Q1. What is the duration of the COPA trade in the curriculum?
A. One year ✓ Correct answer
B. Three years
C. Six months
D. Two years
Q2. What is the NSQF level specified for COPA?
A. Level 3 ✓ Correct answer
B. Level 2
C. Level 4
D. Level 5
Q3. Which sector is specified for COPA?
A. Automotive
B. IT & ITeS ✓ Correct answer
C. Capital Goods
D. Healthcare
Q4. What is the entry qualification stated for COPA?
A. Diploma
B. 10th class ✓ Correct answer
C. 8th class
D. 12th science
Q5. What is the minimum age specified for admission?
A. 16 years
B. 18 years
C. 14 years ✓ Correct answer
D. 12 years
Q6. How many Professional Skill hours are specified?
A. 120
B. 240
C. 150
D. 840 ✓ Correct answer
Q7. How many Professional Knowledge hours are specified?
A. 840
B. 240 ✓ Correct answer
C. 150
D. 120
Q8. How many Employability Skill hours are specified?
A. 120 ✓ Correct answer
B. 60
C. 100
D. 240
Q9. How many mandatory OJT/group-project hours are specified?
A. 150 ✓ Correct answer
B. 240
C. 40
D. 100
Q10. Which certificate is awarded by DGT after successful completion?
A. National Computer License
B. National Trade Certificate ✓ Correct answer
C. National Engineering Certificate
D. National Diploma
Q11. Which safety activity is included in the first learning outcome?
A. 3D printing
B. PCB fabrication
C. Robot programming
D. Use of fire extinguishers ✓ Correct answer
Q12. What should a trainee identify before working with computer equipment?
A. Only Excel charts
B. Only font styles
C. Safety symbols and hazards ✓ Correct answer
D. Only browser bookmarks
Q13. Which component is the main circuit board of a computer?
A. Motherboard ✓ Correct answer
B. Printer
C. Keyboard
D. Monitor
Q14. Which category includes keyboard and mouse?
A. Storage devices
B. Input devices ✓ Correct answer
C. Output devices
D. Network servers
Q15. Which device is an output peripheral?
A. Printer ✓ Correct answer
B. Keyboard
C. Mouse
D. Scanner
Q16. What does BIOS provide access to during system startup?
A. Database queries
B. Basic firmware/system settings ✓ Correct answer
C. Web pages
D. Excel formulas
Q17. What operation creates logical divisions on a hard disk?
A. Mail merge
B. Pivoting
C. Defragmenting a webpage
D. Partitioning ✓ Correct answer
Q18. What is a device driver used for?
A. Writing HTML
B. Formatting a PowerPoint slide
C. Allowing the operating system to communicate with hardware ✓ Correct answer
D. Creating a database table
Q19. Which wireless settings are explicitly practiced?
A. Infrared only
B. Bluetooth and Wi-Fi ✓ Correct answer
C. NFC and RFID only
D. GPS and satellite only
Q20. Which type of software is installed for protection against malware?
A. Antivirus ✓ Correct answer
B. Compiler
C. Spreadsheet
D. Presentation software
Q21. Which Windows feature is used to manage files and folders?
A. Mail Merge
B. Slide Master
C. Pivot Table
D. File/folder management tools ✓ Correct answer
Q22. What is the purpose of keyboard shortcut commands?
A. Measure voltage
B. Create network cables
C. Perform common operations quickly ✓ Correct answer
D. Design databases
Q23. Which command-line environment is included in COPA training?
A. DOS Command Line Interface ✓ Correct answer
B. Only Java console
C. Only PowerShell
D. Only SQL shell
Q24. What is the main purpose of a directory-listing command?
A. Display files/folders in a directory ✓ Correct answer
B. Format a presentation
C. Create a database
D. Start a web server
Q25. Which Linux distribution is specifically installed in the syllabus?
A. Fedora
B. Ubuntu ✓ Correct answer
C. Red Hat Enterprise only
D. Arch only
Q26. What is Linux described as in the theory section?
A. An open-source operating system ✓ Correct answer
B. A database engine only
C. A presentation package
D. A spreadsheet program
Q27. Which Linux activity is included?
A. Making pivot charts
B. Creating PowerPoint transitions
C. Mail merge
D. Managing files and folders from the command line ✓ Correct answer
Q28. What is a user account used for?
A. Formatting an image
B. Creating a chart
C. Managing access and user-specific settings ✓ Correct answer
D. Testing an RJ-45 cable
Q29. What is a booting process?
A. Sending an email
B. The process of starting the computer and loading the operating system ✓ Correct answer
C. Formatting a webpage
D. Creating an Excel pivot table
Q30. Which type of software is listed for office/document work?
A. MySQL
B. MS Office ✓ Correct answer
C. DHCP
D. BIOS
Q31. Which application is used for word processing?
A. Microsoft Excel
B. Microsoft Word ✓ Correct answer
C. MySQL
D. DHCP
Q32. What does mail merge allow a user to do?
A. Create a network switch
B. Create personalized documents for multiple recipients using a data list ✓ Correct answer
C. Compile Java code
D. Partition a hard disk
Q33. Which Word feature controls repeated information at the top or bottom of pages?
A. Subnet mask
B. Firewall
C. Pivot table
D. Header and footer ✓ Correct answer
Q34. What is Format Painter used for?
A. Testing network cables
B. Copying database rows
C. Running Python
D. Copying formatting from one object/text to another ✓ Correct answer
Q35. What is a section break used for?
A. Separating document sections with different layout settings ✓ Correct answer
B. Starting a Java loop
C. Creating a SQL table
D. Creating an IP address
Q36. Which Word feature helps identify accessibility problems?
A. Mail merge
B. DHCP
C. Slide transition
D. Accessibility inspection/correction ✓ Correct answer
Q37. What is Track Changes used for?
A. Creating a web form
B. Recording edits made during document collaboration ✓ Correct answer
C. Executing SQL
D. Creating an IP subnet
Q38. What can be inserted as a reference element in Word?
A. IP packet
B. Footnote or endnote ✓ Correct answer
C. SQL trigger
D. DHCP lease
Q39. What is a table of contents used for?
A. Running JavaScript
B. Assigning IP addresses
C. Providing navigational entries for document sections ✓ Correct answer
D. Calculating Excel averages
Q40. What is mail merge based on?
A. A Java class
B. A MySQL index
C. A router and subnet mask
D. A mailing list/data source and a document template ✓ Correct answer
Q41. Which application is used for spreadsheet work?
A. PowerPoint
B. MySQL
C. Microsoft Word
D. Microsoft Excel ✓ Correct answer
Q42. What is a cell reference in Excel?
A. A way to identify a cell or range in a worksheet ✓ Correct answer
B. A database password
C. A network address
D. A web URL only
Q43. Which reference stays fixed when a formula is copied?
A. External-only reference
B. Relative reference
C. Absolute reference ✓ Correct answer
D. Random reference
Q44. Which function calculates the arithmetic mean?
A. COUNT()
B. MAX()
C. AVERAGE() ✓ Correct answer
D. LEN()
Q45. Which function returns the largest value?
A. MID()
B. COUNT()
C. MIN()
D. MAX() ✓ Correct answer
Q46. Which function counts non-empty numeric cells?
A. SUM()
B. RIGHT()
C. LEN()
D. COUNT() ✓ Correct answer
Q47. Which function counts cells meeting a condition?
A. COUNTIF() ✓ Correct answer
B. MAX()
C. SUM()
D. CONCAT()
Q48. Which function performs a logical conditional test?
A. AVERAGE()
B. SUM()
C. LEFT()
D. IF() ✓ Correct answer
Q49. Which function returns characters from the left side of text?
A. MID()
B. RIGHT()
C. LEFT() ✓ Correct answer
D. LEN()
Q50. Which function joins text strings?
A. MAX()
B. AVERAGE()
C. CONCAT() ✓ Correct answer
D. COUNTBLANK()
Q51. What is a Pivot Table mainly used for?
A. Installing Windows
B. Creating HTML forms
C. Summarizing and analyzing data ✓ Correct answer
D. Sending email
Q52. What does sorting do in a spreadsheet?
A. Arranges data according to selected criteria ✓ Correct answer
B. Compiles Java
C. Deletes all data
D. Creates a network
Q53. What does filtering do?
A. Installs Linux
B. Displays records that meet selected conditions ✓ Correct answer
C. Changes the CPU speed
D. Creates a web server
Q54. What is Goal Seek used for?
A. Writing HTML
B. Checking Wi-Fi signal
C. Finding an input value needed to achieve a desired result ✓ Correct answer
D. Creating a PowerPoint animation
Q55. What is conditional formatting used for?
A. Applying formatting based on data conditions ✓ Correct answer
B. Creating a database schema
C. Assigning IP addresses
D. Installing a printer
Q56. Which PowerPoint feature controls the common design/layout of slides?
A. DHCP
B. Pivot Table
C. SQL Join
D. Slide Master ✓ Correct answer
Q57. What can be added to a PowerPoint slide?
A. Only text
B. Tables, images, audio and video ✓ Correct answer
C. Only formulas
D. Only database records
Q58. What is a slide transition?
A. A database join
B. An effect used when moving from one slide to another ✓ Correct answer
C. A network protocol
D. A Python module
Q59. What is animation in PowerPoint applied to?
A. Only network cables
B. Only the operating system
C. Text and graphic elements ✓ Correct answer
D. Only database tables
Q60. Which PowerPoint view helps present while seeing presenter information?
A. SQL View
B. BIOS View
C. Presenter View ✓ Correct answer
D. Network View
Q61. What is a hyperlink in a presentation?
A. A clickable link to another location, file or source ✓ Correct answer
B. A firewall rule
C. A database index
D. A subnet mask
Q62. Which PowerPoint feature can remove an image background?
A. DHCP
B. Mail Merge
C. Goal Seek
D. Remove Background ✓ Correct answer
Q63. What is SmartArt used for?
A. Testing LAN cables
B. Executing SQL
C. Creating visual graphic representations of information ✓ Correct answer
D. Installing drivers
Q64. What can be configured for inserted video?
A. IP address and subnet mask
B. Size and playback options ✓ Correct answer
C. CPU voltage
D. SQL constraints
Q65. How can a presentation be protected?
A. Using a subnet mask
B. Using a password ✓ Correct answer
C. Using a Python loop
D. Using a primary key
Q66. What is MySQL primarily used for in COPA?
A. Managing relational databases ✓ Correct answer
B. Configuring Wi-Fi only
C. Editing images
D. Creating slide transitions
Q67. What does DBMS stand for?
A. Digital Binary Memory System
B. Database Management System ✓ Correct answer
C. Data Backup Machine Service
D. Database Browser Management Software
Q68. What does RDBMS emphasize?
A. Only network routing
B. Only image storage
C. Relational database structures using related tables ✓ Correct answer
D. Only web hosting
Q69. What is a database schema?
A. A Wi-Fi password
B. The logical structure/organization of a database ✓ Correct answer
C. A PowerPoint theme
D. A computer cable
Q70. What is a primary key used for?
A. Uniquely identifying records in a table ✓ Correct answer
B. Starting Linux
C. Formatting a webpage
D. Connecting a printer to Wi-Fi
Q71. What is a foreign key used for?
A. Creating a slide transition
B. Formatting text
C. Testing a monitor
D. Linking related records/tables through a referenced key ✓ Correct answer
Q72. What is normalization intended to achieve?
A. Create animations
B. Increase monitor brightness
C. Organize relational data and reduce undesirable redundancy ✓ Correct answer
D. Configure Wi-Fi
Q73. Which SQL category includes commands for defining database structures?
A. HTML
B. DDL ✓ Correct answer
C. DML
D. DCL
Q74. Which SQL category is used for manipulating data such as inserting or deleting records?
A. DML ✓ Correct answer
B. DCL
C. CSS
D. DDL
Q75. Which SQL statement retrieves selected data?
A. INSERT
B. UPDATE
C. SELECT ✓ Correct answer
D. DELETE
Q76. Which SQL operation adds a new record?
A. DELETE
B. DROP
C. SELECT
D. INSERT ✓ Correct answer
Q77. Which SQL operation changes existing record values?
A. SELECT
B. CREATE
C. GRANT
D. UPDATE ✓ Correct answer
Q78. Which SQL operation removes records?
A. DELETE ✓ Correct answer
B. SELECT
C. INSERT
D. ALTER
Q79. What does JOIN do in SQL?
A. Deletes a database
B. Assigns an IP address
C. Combines related rows from multiple tables ✓ Correct answer
D. Formats a webpage
Q80. What is a subquery?
A. A Linux desktop
B. A PowerPoint slide
C. A network cable
D. A query nested inside another query ✓ Correct answer
Q81. Which function returns the total of numeric values?
A. AVG()
B. SUM() ✓ Correct answer
C. MAX()
D. COUNT()
Q82. Which SQL clause groups rows for aggregate analysis?
A. LINK BY
B. MERGE BY
C. GROUP BY ✓ Correct answer
D. ORDER ONLY
Q83. Which SQL clause filters grouped results?
A. GROUPFILTER
B. HEADER
C. HAVING ✓ Correct answer
D. FILTERROW
Q84. What are ACID properties associated with?
A. Wi-Fi security
B. PowerPoint animations
C. HTML forms
D. Database transactions ✓ Correct answer
Q85. What is an index used for in a database?
A. Creating a slide show
B. Formatting a Word document
C. Improving data retrieval/search performance ✓ Correct answer
D. Assigning a subnet
Q86. What is a LAN?
A. Linked Access Number
B. Local Analog Network
C. Large Application Node
D. Local Area Network ✓ Correct answer
Q87. Which connector is commonly used with UTP Ethernet cabling?
A. HDMI
B. VGA
C. RJ-45 ✓ Correct answer
D. USB-C only
Q88. What is a straight-through Ethernet cable used for?
A. Connecting network devices according to the appropriate straight cable wiring standard ✓ Correct answer
B. Running JavaScript
C. Creating a SQL table
D. Formatting a hard disk
Q89. What is a crossover cable?
A. A power cable
B. A printer cable
C. A monitor cable
D. An Ethernet cable with crossover wiring between pairs ✓ Correct answer
Q90. What is the purpose of a LAN tester?
A. Formatting a drive
B. Testing a SQL query
C. Checking Excel formulas
D. Checking network cable/connectivity wiring ✓ Correct answer
Q91. What does an IP address identify?
A. A PowerPoint theme
B. A Word paragraph
C. A database column only
D. A device/interface on an IP network ✓ Correct answer
Q92. What is subnet masking used for?
A. Formatting a webpage
B. Creating a Pivot Table
C. Installing antivirus
D. Identifying network and host portions of an IP address ✓ Correct answer
Q93. Which protocol/service automatically provides IP configuration to clients?
A. HTML
B. SMTP only
C. FTP only
D. DHCP ✓ Correct answer
Q94. What is a switch used for in a LAN?
A. Running a Python program
B. Connecting devices within a local network ✓ Correct answer
C. Creating a Word document
D. Managing SQL tables
Q95. What is a hub?
A. A basic network device that connects multiple devices in a local network ✓ Correct answer
B. A presentation theme
C. A database engine
D. A web scripting language
Q96. What does a firewall help protect?
A. A PowerPoint slide from animation
B. A computer/network from unauthorized or unwanted network traffic ✓ Correct answer
C. A Word document from spelling errors
D. An Excel cell from formulas
Q97. What is Wi-Fi?
A. A database language
B. A programming compiler
C. Wireless local-area networking technology ✓ Correct answer
D. A document format
Q98. What is a proxy server used for?
A. Creating Excel formulas
B. Editing images
C. Compiling Java
D. Acting as an intermediary for network requests ✓ Correct answer
Q99. What is the purpose of a patch panel?
A. Storing databases
B. Organizing/terminating network cabling connections ✓ Correct answer
C. Running PowerPoint
D. Installing Linux
Q100. What is the World Wide Web?
A. A local hard disk
B. A database index
C. A system of interlinked web resources accessed over the Internet ✓ Correct answer
D. A programming language
Frequently asked questions
Is this COPA - Computer Operator & Programming Assistant quiz based on the official syllabus?
The questions follow the topics of the DGT CTS 2.0 curriculum for the trade. Always check the latest syllabus and your state or institute notices, because trade lists and weightage can change.
How many questions are there and how are they marked?
There are 100 multiple-choice questions with one correct option each. The quiz shows your score at the end; there is no negative marking on this practice page.
How can I use the explanations?
After each answer read the explanation, note the fact in your own words, and revisit the questions you missed in the answer key below. Repeating the set after a few days works better than reading it once.
Comments
Post a Comment