Showing posts with the label Introduction to Structured Query Language (SQL)

A shop called Wonderful Garments that sells school uniforms maintain a database SCHOOL_UNIFORM as shown below.

Q. A shop called Wonderful Garments that sells school uniforms maintain a datab…

An organization ABC maintains a database EMP-DEPENDENT to record the following details about its employees and their dependents.

Q. An organization ABC maintains a database EMP-DEPENDENT to record the followi…

Create a database called STUDENT_PROJECT having the following tables.

Q. Create a database called STUDENT_PROJECT having the following tables. Choose…

Differentiate between the following commands: a) ALTER and UPDATE b) DELETE and DROP

Q. Differentiate between the following commands: a) ALTER and UPDATE b) DELETE …

Using the sports database containing two relations (TEAM, MATCH_DETAILS), answer the following relational algebra queries.

Q. Using the sports database containing two relations (TEAM, MATCH_DETAILS), an…

Suppose your school management has decided to conduct cricket matches between students of class XI and Class XII.

Q. Suppose your school management has decided to conduct cricket matches betwee…

Consider the following MOVIE database and answer the SQL queries based on it.

Q. Consider the following MOVIE database and answer the SQL queries based on it…

Fill in the blanks: a) ____declares that an index in one table is related to that in another table.

Q. Fill in the blanks: (a) ____declares that an index in one table is related t…

Choose appropriate answer with respect to the following code snippet. CREATE TABLE student ( name CHAR(30), student_id INT,

Q. Choose appropriate answer with respect to the following code snippet. CREATE…

Load More That is All