HP Computer Practice Set 14 | Interactive MCQ Mock Test

1. Which type of key in a database is used to uniquely identify each record in a table?

Computer 📄 JOA IT (2026)

A. Candidate key B. Foreign key C. Primary key D. Alternate key

2. Which scenario best demonstrates a violation of the primary key constraint in a relational database?

Computer 📄 JOA IT (2026)

A. Allowing NULL values in non-key columns B. Having multiple candidate keys in a table C. Using multiple foreign keys in a table D. Inserting two rows with the same value in the primary key column

3. In a database system, a student's age field is restricted to accept only numeric values within a specific range. Any alphabetical or negative input is rejected during data entry. This restriction ensures that only valid values are stored in the database column. This restriction defines:

Computer 📄 JOA IT (2026)

A. Domain B. Entity C. Tuple D. Schema

4. A company wants to generate a list of unique departments from their employee database, but some department names are repeated. Which SQL query will ensure only unique department names are displayed?

Computer 📄 JOA IT (2026)

A. SELECT DISTINCT department FROM employees; B. SELECT department, COUNT(*) FROM employees; C. SELECT department FROM employees; D. SELECT UNIQUE department FROM employees;

5. How does MySQL enforce the integrity of relationships between tables when records are inserted or deleted?

Computer 📄 JOA IT (2026)

A. Permitting unrestricted deletions B. Using only indexing methods C. Applying foreign key constraints D. Allowing automatic record insertion

6. Why are text formatting tags like b, i, and h1 important in HTML web pages?

Computer 📄 JOA IT (2026)

A. They improve readability and help organize content visually B. They create hyperlinks between pages C. They add images to the web page D. They change the overall color theme of the browser

7. If you want a link to open in the same window and not disrupt your browsing session, which target attribute would you avoid using?

Computer 📄 JOA IT (2026)

A. _blank B. _parent C. _self D. _top

8. A web designer wants to create a navigation menu on a single web page that jumps to different sections like About, Services, and Contact when clicked. Which approach best applies the concept of internal hyperlinks for this purpose?

Computer 📄 JOA IT (2026)

A. Place all content in one long div and use external links B. Create separate HTML files for each section and link between them C. Use class attributes for sections and create anchor tags for classes D. Assign unique IDs to each section and use anchor tags referencing those IDs

9. You need to reverse the elements of an array in place. Which method ensures minimal additional space usage while achieving this task?

Computer 📄 JOA IT (2026)

A. Push all elements to a stack and pop them back B. Use recursion to reverse elements C. Swap elements from start and end towards the center D. Create a new array and copy elements in reverse order

10. If you want to change the bullet style of an unordered list in modern HTML5, which method should you use instead of the obsolete attribute?

Computer 📄 JOA IT (2026)

A. type attribute B. ul-bullet property C. inline style attribute only D. CSS list-style-type property

Himachal Pradesh Computer - Practice Mock Test Set 14

📊 Live Score Summary

Quick Navigation Links

Boost Your Himachal Pradesh Computer Exam Preparation