SQL-2
Quiz by Dr.J.Jenefa
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- view complete results in the Gradebook and Mastery Dashboards
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
Our brand new solo games combine with your quiz, on the same screen
Correct quiz answers unlock more play!
19 questions
Show answers
- Q1The language used in application programs to request data from the DBMS is referred to as __________DMLDDLAll the aboveQuery Language30sEditDelete
- Q2In SQL, which of the following is not a data Manipulation Language Commands?UPDATETRUNCATECREATEDELETE30sEditDelete
- Q3Which of the following is not a type of SQL statement?DDL (Data Definition Language)DCL (Data Control Language)DML (Data Manipulation Language)DCL (Data Communication Language)30sEditDelete
- Q4Which of the following is not included in DML (Data Manipulation Language) ?INSERTCREATEUPDATEDELETE30sEditDelete
- Q5TRUNCATE statement in SQL is a ______________DMLDDLDCLTCL30sEditDelete
- Q6In SQL, which command is used to add new rows to a table ?INSERTALTERAPPENDADD ROW30sEditDelete
- Q7Combination of a primary key with foreign key formsNetwork model between the tables connect themMany to many relationship between the tables that connect themNone of themParent-child relationship between the tables that connect them30sEditDelete
- Q8Stack is also called _____________________________First In First Out (FIFO)Last In Last Out (LILO)First Come First Served (FCFS)First In Last Out (FILO)30sEditDelete
- Q9)Match SQL language with SQL commands 1)DDL i)Revok, Grant 2)DML ii)rename a table 3)TCL iii)insert, update 4)DCL iv)rollback , commit1-ii,2-iii,3-iv,4-i1-i,2-iii,3-ii,4-iv1-iii,2-ii,3-iv,4-i1-iii,2-i,3-ii,4-iv30sEditDelete
- Q10Which is not DDL (data definition language) operation ?SQL create tableRenaming a tableUpdate data into a table in SQL databaseAdd a column to an existing table30sEditDelete
- Q11Which of the following is not a type of SQL statement?DMLDCLDCIDDL30sEditDelete
- Q12Which of the following is not included in DML (Data Manipulation Language)?InsertDeleteAlterUpdate30sEditDelete
- Q13A type of query that is placed within a WHERE or HAVING clause of another query is calledMaster queryMulti-querySub querySuper query30sEditDelete
- Q14Which one of these is used with SELECT clause to fetch all columns from a table?ALLDISTINCTAS*30sEditDelete
- Q15Data manipulation language (DML) includes statements that modify the _____ of a database.StructureUserSizeData30sEditDelete
- Q16Which of the following is a legal expression in SQL?SELECT NAME FROM EMPLOYEE WHEN SALARY = NULL;None of the aboveSELECT NAME FROM EMPLOYEE;SELECT NULL FROM EMPLOYEE;30sEditDelete
- Q17Which of the following is a comparison operator in SQL?BETWEENAll of the above=LIKE30sEditDelete
- Q18To delete a particular column in relation the command used is:DELETE COLUMNALTER , DROPUPDATE TABLETRUNCATE COLUMN30sEditDelete
- Q19The ______ operator is used to compare a value to a list of literals values that have been specified.BETWEENINALLANY30sEditDelete