Basic SQLs

Create an engaging and colorful illustration featuring a computer screen displaying SQL code, with a person excitedly learning SQL concepts. The background should include elements that represent data management and programming, like databases and code snippets.

Basic SQLs Quiz

Test your knowledge of SQL with our engaging Basic SQLs Quiz! Whether you're a beginner learning the ropes or someone looking to brush up on your skills, this quiz is designed to challenge and enhance your understanding of SQL syntax and queries.

  • Multiple choice questions
  • Covers fundamental SQL commands
  • Ideal for beginners and intermediate learners
6 Questions2 MinutesCreated by LearningCode101
To display the first and last column of the table, what is the correct SQL
CustomerID FName LName DOB Sex Phone Address PostCode
20002 RAJOO THINH MINH 1963-05-31 M 7842728 11 HILDA CRES 3181
20004 PHONGWATCHARARUK JERZY MIROSLAW 1976-09-30 M 3193758 44 BARRINGTON AVE 3030
20006 CHOW SOW LIM 1968-01-23 F 2982091 17 KERFERD ROAD 3149
20008 LIVERIADIS TONY 1978-01-04 M 8325704 413 MT ALEXANDER RD 3165
Select first, last from the customer;
Select * from customer;
Select custoemrId and Address from customer;
select customerId, Postcode from customer;
To display all the details of all the customers
CustomerID FName LName DOB Sex Phone Address PostCode
20002 RAJOO THINH MINH 1963-05-31 M 7842728 11 HILDA CRES 3181
20004 PHONGWATCHARARUK JERZY MIROSLAW 1976-09-30 M 3193758 44 BARRINGTON AVE 3030
20006 CHOW SOW LIM 1968-01-23 F 2982091 17 KERFERD ROAD 3149
20008 LIVERIADIS TONY 1978-01-04 M 8325704 413 MT ALEXANDER RD 3165
Select * from customer;
Select ALL from customer;
Select from customer
None of the answers are correct
To display all the details of all the customers whose name contains strring 'CH', the correct SQL is
CustomerID FName Sex LName DOB Sex Phone Address PostCode
20002 RAJOO M THINH MINH 1963-05-31 M 7842728 11 HILDA CRES 3181
20004 PHONGWATCHARARUK F JERZY MIROSLAW 1976-09-30 M 3193758 44 BARRINGTON AVE 3030
20006 CHOW M SOW LIM 1968-01-23 F 2982091 17 KERFERD ROAD 3149
20008 LIVERIADIS F TONY 1978-01-04 M 8325704 413 MT ALEXANDER RD 3165
Select * from Customer;
Select * from customer where name like '% CH%;
Select * from customer where name = ' CHOW';
Select * from customer where name =CH
To display all the details of all the customers whose name contains strring 'CH', who are females, the correct SQL is
CustomerID FName Sex LName DOB Sex Phone Address PostCode
20002 RAJOO M THINH MINH 1963-05-31 M 7842728 11 HILDA CRES 3181
20004 PHONGWATCHARARUK F JERZY MIROSLAW 1976-09-30 M 3193758 44 BARRINGTON AVE 3030
20006 CHOW M SOW LIM 1968-01-23 F 2982091 17 KERFERD ROAD 3149
20008 LIVERIADIS F TONY 1978-01-04 M 8325704 413 MT ALEXANDER RD 3165
Select * from Customer;
Select * from customer where name like '% CH% or Sex='F';
Select * from customer where name like '% CH% and Sex='F';
Select * from customer sex='F';
To display all the details of all the customers who are females living in either postcode 3035 or 3030, the correct SQL is
CustomerID FName Sex LName DOB Sex Phone Address PostCode
20002 RAJOO M THINH MINH 1963-05-31 M 7842728 11 HILDA CRES 3181
20004 PHONGWATCHARARUK F JERZY MIROSLAW 1976-09-30 M 3193758 44 BARRINGTON AVE 3030
20006 CHOW M SOW LIM 1968-01-23 F 2982091 17 KERFERD ROAD 3149
20008 LIVERIADIS F TONY 1978-01-04 M 8325704 413 MT ALEXANDER RD 3165
Select * from where sex='F';
Select * from customer where (postcode=3030 or postcode=3035) and sex='F';
Select * from customer where postcode=3030 or postcode=3035 and sex='F
Select * from customer sex='F';
To display all the details of all the customers whose fname is Rajoo
CustomerID FName Sex LName DOB Sex Phone Address PostCode
20002 RAJOO M THINH MINH 1963-05-31 M 7842728 11 HILDA CRES 3181
20004 PHONGWATCHARARUK F JERZY MIROSLAW 1976-09-30 M 3193758 44 BARRINGTON AVE 3030
20006 CHOW M SOW LIM 1968-01-23 F 2982091 17 KERFERD ROAD 3149
20008 LIVERIADIS F TONY 1978-01-04 M 8325704 413 MT ALEXANDER RD 3165
Select * from customer where fname ='Rajoo';
Select * from customer where fname like 'Rajoo';
Select * from customer where lower(fname) like 'rajoo';
Select * from customer where lower(fname) = 'rajoo';
{"name":"Basic SQLs", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of SQL with our engaging Basic SQLs Quiz! Whether you're a beginner learning the ropes or someone looking to brush up on your skills, this quiz is designed to challenge and enhance your understanding of SQL syntax and queries.Multiple choice questionsCovers fundamental SQL commandsIdeal for beginners and intermediate learners","img":"https:/images/course2.png"}
Powered by: Quiz Maker