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 delete the records of contractors whose phone number is not known.

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; ``` **(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; ``` **(IV) To delete the records of contractors whose phone number is not known:** ```sql DELETE FROM Contractor WHERE Phone IS NULL; ```

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Structured Query Language

Keep Practicing

Current Question

Community Stats

Track Your Progress

Edvaya Target

We Value Your Privacy