+ 43

SQL Quizzes

Maybe some of SQL questions for new quizzes in Solo Learn 1. What does SQL stand for? Strong Question Language Structured Question Language Structured Query Language 2. Which SQL statement is used to extract data from a database? EXTRACT GET OPEN SELECT 3. Which SQL statement is used to update data in a database? MODIFY UPDATE SAVE AS SAVE 4. Which SQL statement is used to delete data from a database? COLLAPSE REMOVE DELETE 5. The SQL BETWEEN operat

26th Dec 2017, 8:19 AM
Daniel
Daniel - avatar
20 Réponses
+ 32
👉👉👉like this☺ ????? //👉👉true & false type 1) sql statement given below is an example of DDL command Alter table emp add empid varchar (16) after empno; //true 2)primary key contraint on a field restrict null values for that field //true 3)unique constraint on a field does not restricts null value for that field //true 4) degree refers to number of tuples in a table //false 5)foreign key is a non-key attribute //true 6)any arithmetic expression containing a null,always returns null as output //true 7) join using which identical columns from both the tables is shown once in the result //natural join //👉👉fill in the blanks type(blanks u can assign) 1)display records of employee(name,dat_of_retirement) from emp table who are retired //select name,dat_of_retirement from emp where dat_of_retirement is not null; 2)_______ is pool of valid values from which columns derives their values //domain 3)display all records of table school where class is not 12 //select * from school where class <> 12; 4)display names of students of class 12 , section a2 from school table where name has character "r" at forth position //select name from school where class=12 && section ="a2" && name like "_ _ _ r%"; 5)increase price of fruits by 20% in fruits table where fruit_name is apple,papaya //update fruits set price=1.2*price where fruit_name in ("apple","papaya"); 6)to display total number of students of 12 got selected in an exam from table exam_winners //select count (*) from exam_winners where class=12; 7)display names of employee with same department from emp table //select count (*),department from emp group by department; //👉👉 1 word answer type 1)department table have 2 columns,5 rows and emp table have 3 rows ,4 columns . how many rows and columns will be produced in output if we take cartesian product of these two tables //15 rows and 6 columns //U can make possible correction in it , will good one when my exams will be over after some days ☺
26th Dec 2017, 6:34 PM
Gaurav Agrawal
Gaurav Agrawal - avatar
+ 26
I think SQL quizzes will eventually be opened for submission. :>
28th Apr 2017, 7:05 AM
Hatsy Rei
Hatsy Rei - avatar
+ 21
Glad to see no math on Quizz. Hope Sql coming soon.
28th Apr 2017, 8:20 AM
Agus Mei
Agus Mei - avatar
+ 20
But it's hard to get even a 100 quizzes if current rules for declining quizzes (similar questions, out of scope etc,.) are considered.
29th Apr 2017, 2:08 AM
Krishna Teja Yeluripati
Krishna Teja Yeluripati - avatar
+ 16
can i also give my questions on SQL ? sir ... //waiting ...
26th Dec 2017, 9:53 AM
Gaurav Agrawal
Gaurav Agrawal - avatar
+ 15
Maybe while SoloLearn implement it , we could posting here some other quizzes: * In a LIKE clause, how do you get all the names of people starting with "John"? -LIKE "John%" -LIKE "John*" -LIKE "John
quot; -LIKE "John&" * If you have that table CREATE TABLE cities ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(30) NOT NULL ); check right queries: - INSERT INTO cities(id, name) values(1, 'Los Angeles'); - ADD INTO cities(id, name) values(1, 'Los Angeles'); - ADD INTO cities(name, id) values('Los Angeles',1); - INSERT INTO cities(name, id) values('Los Angeles',1);
3rd May 2017, 7:02 PM
Daniel
Daniel - avatar
+ 14
I hope it will be soon @Hatsy Rei ;)
28th Apr 2017, 7:10 AM
Daniel
Daniel - avatar
+ 13
Will wait for SQL. (Nikolay revises SQL concepts to prepare 😂)
30th Aug 2017, 3:25 AM
👑 Prometheus 🇸🇬
👑 Prometheus 🇸🇬 - avatar
+ 12
Krishna I think we can do it, all together ;)
29th Apr 2017, 3:11 AM
Daniel
Daniel - avatar
+ 10
Great idea. l like a lot SQL. I wait...
3rd Aug 2017, 12:04 AM
Benjamin Salas
Benjamin Salas - avatar
+ 9
@Daniel great quizzes apart from quiz factory
2nd Aug 2017, 10:37 AM
Vivek Singh
Vivek Singh - avatar
+ 7
Thanks. We will be waitting for soon updates in SL
2nd Aug 2017, 4:23 PM
Daniel
Daniel - avatar
+ 7
Yes I'm definitely in favor of SQL for challenges. Great idea Daniel! Knowing the languages and how databases work is very important for any full stack developer.
22nd Nov 2017, 2:04 PM
Kent Gray
Kent Gray - avatar
+ 5
1.Structured Query Language 2.SELECT 3.UPDATE 4.DELETE 5.Specifies a range to test
27th Dec 2017, 3:48 AM
Zin Mar Oo
+ 4
Yes of course ;-)
26th Dec 2017, 4:32 PM
Daniel
Daniel - avatar
+ 3
wow ! gr8 👏
8th Nov 2017, 11:35 PM
fcbshady
fcbshady - avatar
+ 1
1.Structured Query Language 2.SELECT 3.UPDATE 4.DELETE 5.Specifies a range to test
31st May 2018, 1:24 AM
Alan Carreño Fiestas
Alan Carreño Fiestas - avatar
0
@Daniel Structured Query Language EXTRACT UPDATE DELETE Specifies a range to test
26th Dec 2017, 7:41 PM
PRIYANKA SINGHAL
PRIYANKA SINGHAL - avatar
0
%wolf
28th Aug 2020, 6:58 PM
xgqfrms
xgqfrms - avatar
0
Zoo You manage a zoo. Each animal in the zoo comes from a different country. Here are the tables you have: AnimalscontentImageCountriescontentImage1) A new animal has come in, with the following details: name - "Slim", type - "Giraffe", country_id - 1 Add him to the Animals table. 2) You want to make a complete list of the animals for the zoo’s visitors. Write a query to output a new table with each animal's name, type and country fields, sorted by countries
19th May 2021, 12:00 AM
Sayed.Ramadan
Sayed.Ramadan - avatar