CBSE 2025, Compartment, Set 4

Question

Assume that you are working for ABC Corporation (ABCC). ABCC allots contracts to different contractors for some of its works. The data of Contracts and Contractors are kept in the tables `Work` and `Contractor` respectively. Following are a few records from these two tables of ABCC's database.

![Table Work](https://www.edvaya.com/images/cbse/computer-science/2025/set4/q34-work.webp)
![Table Contractor](https://www.edvaya.com/images/cbse/computer-science/2025/set4/q34-contractor.webp)

Note: The tables contain many more records than shown here.
As an employee of ABCC, you are required to write the SQL queries for the following:
(I) To display all the records from the Work table in alphabetical order of W_Name.
(II) To display the names of contractors where W_Amt is more than 15000.
(III) To display the structure of Work table.
(IV) To count total number of records present in Work table.

Edvaya · Accepted Answer

The correct answer is Subjective. **(I) To display all the records from the Work table in alphabetical order of W_Name:** ```sql SELECT * FROM Work ORDER BY W_Name ASC; ``` *(Note: ASC is optional as it is the default order).* **(II) To display the names of contractors where W_Amt is more than 15000:** ```sql SELECT C_Name FROM Contractor, Work WHERE Contractor.CID = Work.CID AND W_Amt > 15000; ``` **(III) To display the structure of Work table:** ```sql DESCRIBE Work; ``` *(Alternatively, `DESC Work;` is also acceptable).* **(IV) To count total number of records present in Work table:** ```sql SELECT COUNT(*) FROM Work; ```

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Structured Query Language

Keep Practicing

Edvaya Target

Current Question

Community Stats

Track Your Progress

Quick Actions

We Value Your Privacy