A question bank for every class and subject
Practice questions, with answers and explanations included
794 questions available
Refine
All questions
794 resultsWrite an SQL query using GROUP BY and HAVING to find departments having more than one teacher.
Show answer
ARPANET, developed in 1969, made use of which technology?
Show answer
Write an SQL query to display fname and marks of students where fname starting with the letter 'A'.
Show answer
Write an SQL query to update the salary of teacher with Teacher_ID = 101 to 55000.
Show answer
Which body coordinates the assignment of unique identifiers like domain names and IP addresses on the Internet?
Show answer
Write an SQL query to display fname and marks of students where fname ending with the letter 'H'.
Show answer
Write an SQL query to increase the salary of teacher named 'Shanaya' by 5000.
Show answer
In which mode of communication can data be transferred in only one direction?
Show answer
Write an SQL query to display fname and marks of students where fname containing the substring 'AN'.
Show answer
Write an SQL query to delete the tuple for teacher with Teacher_ID = 101.
Show answer
Which network device connects two or more LANs, possibly operating at different speeds?
Show answer
Write an SQL query to display fname and marks of students where fname of exactly five characters.
Show answer
Consider the Employee table (Employee_ID [PK], Employee_Name, Job_Title, Salary, Bonus, Age, Manager_ID [FK referencing Employee_ID]): Write SQL commands to (a) create the table (b) delete the employee with Employee_ID 1217 (c) update the salary of 'Amyra' to 40000.
Show answer
Which network device is used to restore a weakened/distorted signal so it can travel farther?
Show answer
Write an SQL query to display fname and marks of students where marks IS NULL.
Show answer
For the same Employee table, write SQL queries to: (a) display names and salaries of employees whose salary is greater than 20000 (b) display details of employees who are not getting any bonus (c) display names of employees whose name ends with the letter 'a' (d) display name and job title of employees whose Manager_ID is 1201.
Show answer
Which topology uses a backbone cable, with nodes connected via a tap connector?
Show answer
Write an SQL query to display fname and marks of students where marks IS NOT NULL.
Show answer
For the same Employee table, write SQL queries to: (a) display name and job title of employees whose manager is 'Amyra' (using a self-join/nested query) (b) display name and job title of employees aged between 26 and 30 years (both inclusive).
Show answer
Which topology requires a dedicated point-to-point link between every pair of nodes?