|

Work Integreted Learning MCQs – Class 12 IT (802)

Work Integrated Learning MCQs for Class 12 IT (802) are designed in accordance with the latest CBSE syllabus and based on commonly asked question patterns from previous years.

Q1. A school wants to develop a database application to manage student records, examination results, faculty details, and infrastructure information. Which domain does this application primarily belong to?
a) Banking
b) Education
c) Government Sector
d) E-Commerce


Q2. A bank maintains customer account details, loan information, daily transactions, and employee salary records. Which of the following best explains the role of DBMS in this situation?
a) Managing only customer login details
b) Storing and retrieving banking-related information efficiently
c) Designing websites for online shopping
d) Maintaining only employee attendance


Q3. A hospital wants to maintain patient health records, hospitalization dates, doctor details, room information, and medical equipment records. Which database application would be most suitable?
a) Company Management Application
b) Hospital Management Application
c) Inventory Control Application
d) Library Management Application


Q4. An online shopping platform maintains product prices, quantities, manufacturing dates, seller details, customer addresses, and order information. Which domain does this application represent?
a) Banking
b) E-Commerce
c) Education
d) Telecommunications


Q5. An airline database stores flight arrival and departure times, fares, passenger capacity, and the number of bookings. It also maintains online and offline reservations. Which other domain uses a similar type of database functionality?
a) Hospitals
b) Railways
c) Companies
d) Education


Q6. A hotel wants to identify which rooms are booked and which are available. It also needs to maintain guest check-in and check-out times. Which information would be most relevant to this requirement?
a) Guest details, duration of stay, and room allocation
b) Customer loan details and daily transactions
c) Flight fares and passenger capacity
d) Employee investments and project details


Q7. XYZ Shopping Website provides customers with 24 × 7 access to a variety of products. A customer can compare products, add selected items to a shopping cart, and choose a payment method. Which of the following is NOT mentioned as a payment option on the website?
a) Cash on Delivery
b) Credit/Debit Card
c) Net Banking
d) Cheque Payment


Q8. A shopping website needs to store category information such as category number, category name, and category description. Which table should be created for this purpose?
a) PRODUCT
b) CATEGORY
c) CUSTOMER
d) SELLER


Q9. A shopping website wants to display the number of items remaining in stock for each product. Which attribute of the PRODUCT table will provide this information?
a) Discount
b) Quantity
c) Description
d) Brand


Q10. A customer registers on XYZ Shopping Website by providing a name, address, email ID, contact number, and password. In which table will these details be stored?
a) SELLER
b) CUSTOMER
c) PAYMENT
d) SHIPMENT


Q11. A database designer is examining the ORDER table of the shopping application. The table stores order identification, customer identification, product identification, shipment identification, order date, and current status. Which attribute represents the primary key?
a) Customer_id
b) Product_id
c) Shipment_id
d) Order_id


Q12. A customer completes an online purchase using net banking. The website needs to maintain the payment amount, payment date, payment mode, and related order number. Which table should store these details?
a) ORDER
b) CUSTOMER
c) PAYMENT
d) PRODUCT


Q13. A customer selects a product on the shopping website. The same product is offered by three different sellers. The website must display the details of all three sellers. According to the textbook, which combination should be declared as a composite key to serve this purpose?
a) Product_id and Customer_id
b) Product_id and Seller_id
c) Seller_id and Order_id
d) Customer_id and Order_id


Q14. A customer adds products to the shopping cart and selects the Buy option. The customer is not already logged in. According to the order completion process described in the textbook, what should happen next?
a) The customer must immediately receive the shipment details.
b) The customer is asked to log in or provide personal details.
c) The order is automatically marked as delivered.
d) The payment record is deleted.


Q15. A student is installing NetBeans IDE on a computer for developing Java applications. After downloading the installer and starting the installation, the student reaches the License Agreement screen. What should the student do to proceed with the installation?
a) Click Finish immediately.
b) Check the selection box to accept the License Agreement and click Next.
c) Delete the downloaded installation file.
d) Open the Java application before completing the installation.


Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *