Commerce (English Medium) इयत्ता १२ - CBSE Question Bank Solutions

Consider the following MOVIE table and write the SQL query based on it.

List business is done by the movies showing only MovieID, MovieName, and Total_Earning. Total_ Earning to be calculated as the sum of ProductionCost and BusinessCost.

Consider the following MOVIE table and write the SQL query based on it.

List the different categories of movies.

Consider the following MOVIE table and write the SQL query based on it.

Find the net profit of each movie showing its MovieID, MovieName, and NetProfit. Net Profit is to be calculated as the difference between Business Cost and Production Cost.

Consider the following MOVIE table and write the SQL query based on it.

List MovieID, MovieName, and Cost for all movies with ProductionCost greater than 10,000 and less than 1,00,000.

Consider the following MOVIE table and write the SQL query based on it.

List details of all movies which fall in the category of comedy or action.

Consider the following MOVIE table and write the SQL query based on it.

List details of all movies which have not been released yet.

Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

1. Display the MatchID of all those matches where both teams have scored more than 70.
2. Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeam has scored more than 70.
3. Display the MatchID and date of matches played by Team 1 and won by it.
4. Display the MatchID of matches played by Team 2 and not won by it.
5. Change the name of the relation TEAM to T_DATA. Also, change the attributes TeamID and TeamName to T_ID and T_NAME respectively.

Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeam has scored more than 70.

Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Display the MatchID and date of matches played by Team 1 and won by it.

Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Display the MatchID of matches played by Team 2 and not won by it.

What are the risks associated with HTTP? How can we resolve these risks by using HTTPS?

Which of the following mode in the file opening statement results or generates an error if the file does not exist?

The SELECT statement when combined with the ______ clause returns records without repetition.

Write two points of difference between Circuit Switching and Packet Switching.

Explain the use of ‘Foreign Key’ in a Relational Database Management System. Give example to support your answer.

Consider the following tables – Bank_Account and Branch:

Table: Bank_Account

Table: Branch

What will be the output of the following statement?

SELECT * FROM Bank_Account NATURAL JOIN Branch;

Write a method COUNTLINES() in Python to read lines from the text file ‘TESTFILE.TXT’ and display the lines which do not start with any vowel.

Example:

If the file content is as follows:

An apple a day keeps the doctor away.
We all pray for everyone’s safety.
A marked difference will come in our country.

The COUNTLINES() function should display the output as:

The number of lines not starting with any vowel - 1

Write a function ETCount() in Python, which should read each character of a text file “TESTFILE.TXT” and then count and display the count of occurrence of alphabets E and T individually (including small cases e and t too).

Example:

If the file content is as follows:

Today is a pleasant day.
It might rain today.
It is mentioned on weather sites

The ETCount() function should display the output as:
E or e : 6
T or t : 9

______ clause is used with a SELECT statement to display data in a sorted form with respect to a specified column.

Explain the concept of “Alternate Key” in a Relational Database Management System with an appropriate example.