A question bank for every class and subject
Practice questions, with answers and explanations included
794 questions available
Refine
All questions
794 resultsWhich command lists all the tables created in the currently selected database?
Show answer
A shopping website's database design typically requires separate tables for entities like Category, Product, Customer, and Orders.
Show answer
Which statement is used to modify data in a table (from the textbook's MCQ exercise)?
Show answer
Which constraint ensures that a user-specified value (e.g., 40000) is stored when no value is provided for an attribute?
Show answer
List any four domains/sectors where database management applications are commonly used, as mentioned in the textbook.
Show answer
Which SQL statement is used to delete data (rows) from a table (from the textbook's MCQ exercise)?
Show answer
Which constraint is used to restrict the values of an attribute to a specific range (e.g., Dept_No <= 110)?
Show answer
Write the CREATE TABLE command for the CATEGORY table with schema CATEGORY(Category_id INT(10) Primary Key, Name VARCHAR(20), Description VARCHAR(40)).
Show answer
Fill in the blank: ___________ command is used to add records in a relation.
Show answer
By default, primary key columns are:
Show answer
Explain the four phases of database application development as applied to designing a shopping website, referencing entity identification and table design.
Show answer
Fill in the blank: SELECT is a type of ___________ command.
Show answer
If a table's primary key comprises MORE than one attribute, how must it be specified in the CREATE TABLE command?
Show answer
Given int a=15, b=4; what is the value of a%b?
Show answer
Fill in the blank: BETWEEN operator includes __________ and __________ values given in the range.
Show answer
Which clause is used to specify a foreign key and the table/column it references?
Show answer
Given int a=22, b=7; what is the value of a%b?
Show answer
Write SQL statements for the following operations on table GYM(PrCode, PrName, UnitPrice, Manufacturer): (a) Display details of all products with unit price less than Rs. 20000. (b) Add a new row for product 'P106', 'Vibro Exerciser', 23000, manufacturer 'Avon Fitness'. (c) Display details of all products with manufacturer name starting with 'A'.
Show answer
In the Key column of a DESC output, what does 'MUL' next to a foreign key column indicate?
Show answer
Given int a=9, b=5; what is the value of a%b?