Class 12

Which payment method is NOT mentioned as an option in the XYZ Shopping Website case study?

Which command lists all the tables created in the currently selected database?

A shopping website's database design typically requires separate tables for entities like Category, Product, Customer, and Orders.

Which constraint ensures that a user-specified value (e.g., 40000) is stored when no value is provided for an attribute?

List any four domains/sectors where database management applications are commonly used, as mentioned in the textbook.

Which constraint is used to restrict the values of an attribute to a specific range (e.g., Dept_No <= 110)?

Write the CREATE TABLE command for the CATEGORY table with schema CATEGORY(Category_id INT(10) Primary Key, Name VARCHAR(20), Description VARCHAR(40)).

By default, primary key columns are:

Explain the four phases of database application development as applied to designing a shopping website, referencing entity identification and table design.

If a table's primary key comprises MORE than one attribute, how must it be specified in the CREATE TABLE command?

Given int a=15, b=4; what is the value of a%b?

Which clause is used to specify a foreign key and the table/column it references?

Given int a=22, b=7; what is the value of a%b?

In the Key column of a DESC output, what does 'MUL' next to a foreign key column indicate?

Given int a=9, b=5; what is the value of a%b?

Which referential action automatically sets the foreign key value to NULL when the referenced primary key row is deleted?

Given int a=31, b=6; what is the value of a%b?

Which referential action automatically deletes the corresponding rows in the referencing table when the referenced row is deleted?

Given int a=18, b=4; what is the value of a%b?

Which referential action rejects the delete/update operation on the referenced table if there are related rows in the referencing table?