Class 11
Information Technology (802)
443 questions available
Refine
All questions
443 resultsDefine the term: Computer
Show answer
A MySQL table can have more than one primary key defined using two separate PRIMARY KEY clauses.
Show answer
Define the term: Input Device
Show answer
Which statement is used to select a database and make it the current database?
Show answer
Define the term: Output Device
Show answer
List the four DML commands mentioned in the chapter.
Show answer
Define the term: Processor
Show answer
Write the SQL statement to create a table named 'Shoes' with columns Code (CHAR(4), Primary Key), Name (VARCHAR(20)), type (VARCHAR(10)), size (INT(2), NOT NULL), cost (DECIMAL(6,2)), margin (DECIMAL(4,2)), and Qty (INT(4)).
Show answer
Differentiate between Bus Topology and Star Topology.
Show answer
Which keyword is used with SELECT to eliminate repeated (duplicate) values from the result?
Show answer
Differentiate between Star Topology and Tree Topology.
Show answer
Which clause is used to filter rows based on a specified condition?
Show answer
Differentiate between Star Topology and Mesh Topology.
Show answer
Which SQL statement is used to modify existing data (records) within a table?
Show answer
Differentiate between Ring Topology and Bus Topology.
Show answer
Which SQL statement removes data (rows) from a table?
Show answer
Differentiate between LAN and WAN.
Show answer
Which operator is used for pattern matching of strings in SQL?
Show answer
Differentiate between LAN and MAN.
Show answer
Which wildcard character in the LIKE clause matches exactly one character?