Class 11
Information Technology (802)
443 questions available
Refine
All questions
443 resultsWhich SQL statement is used to delete data (rows) from a table (from the textbook's MCQ exercise)?
Show answer
Fill in the blank: ___________ command is used to add records in a relation.
Show answer
Fill in the blank: SELECT is a type of ___________ command.
Show answer
Fill in the blank: BETWEEN operator includes __________ and __________ values given in the range.
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 a database, table Cabinet has a column where the data entry operator is unable to enter NULL values, and also unable to enter duplicate values. What is the likely reason?
Show answer
Convert: 2 KB = ______ Bytes.
Show answer
Convert: 3 KB = ______ Bytes.
Show answer
Convert: 4 KB = ______ Bytes.
Show answer
Convert: 5 KB = ______ Bytes.
Show answer
Convert: 6 KB = ______ Bytes.
Show answer
Convert: 7 KB = ______ Bytes.
Show answer
Convert: 2 MB = ______ KB.
Show answer
Convert: 3 MB = ______ KB.
Show answer
Convert: 4 MB = ______ KB.
Show answer
Convert: 5 MB = ______ KB.
Show answer
Convert: 6 MB = ______ KB.
Show answer
Convert: 7 MB = ______ KB.
Show answer
Convert: 2 GB = ______ MB.
Show answer
Convert: 3 GB = ______ MB.