Quiz
SQL Knowkedge test
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (15)
1What does SQL stand for?
- AStrong Question Language
- BStructured Question Language
- CStructured Query Language
- D Structured Quest Language
2The FROM SQL clause is used to…
- ASpecify range for search condition
- BSpecify what table we are deleting data from
- CSpecify what table we are selecting data from
- DSpecify search condition
3Which of the following is NOT a SQL keyword or SQL clause?
- ADELETE
- BINVERT
- CUPDATE
- DMOVE
- EALTER
- FREMOVE
- G INSERT
4The UNION SQL clause can be used with
- AThe DELETE and UPDATE clauses
- BThe UPDATE clause only
- CThe DELETE clause only
- DThe SELECT clause only
5Which SQL statement inserts data into a table called Projects?
- AINSERT INTO Employees (FullName, ProjectName) VALUES (Yuriy Shovkun, Cartera)
- BINSERT Employees (FullName, ProjectName) VALUES ('Yuriy Shovkun, Cartera')
- CINSERT INTO Employees (FullName, ProjectName) VALUES ('Yuriy Shovkun, Cartera')
- DINSERT INTO Employees (FullName, ProjectName) VALUES ('Yuriy Shovkun', 'Cartera')
- AINSERT INTO Employees (FullName, ProjectName) VALUES (Yuriy Shovkun, Cartera)
6Which of the following SQL statements is logically correct?
- ASELECT ProjectName, COUNT(ProjectName) FROM Employees GROUP BY ProjectName
- BSELECT ProjectName, COUNT(ProjectName) FROM Employees
- CSELECT ProjectName, COUNT(ProjectName) FROM Employees SORT BY ProjectName
- DSELECT ProjectName, COUNT(ProjectName) FROM Employees ORDER BY ProjectName
7Is it possible to insert 'null' value into Foreign Key?
- ATrue
- BFalse
8Select correct SQL field data types
- AINTEGER
- BDOUBLE BOOLEAN
- CVARCHAR
- DCHARACTER
- ETIME
- FYEAR
- GTIMESTAMP
- HINCREMENT
- IMULTISET
- JBOOLEAN
9What data type is using for store True/False values?
- AVARCHAR
- BFLOAT
- CBOOLEAN
- DDECIMAL
10What is the type of JOIN do you see in the picture?
- AINNER JOIN
- BLEFT RIGHT JOIN
- CFULL OUTER JOIN
- DFULL INNER JOIN
11What is the type of JOIN do you see in the picture?
- ARIGHT JOIN
- BRIGHT INNER JOIN
- CRIGHT JOIN with MINUS KEY (if NULL value)
- DRIGHT OUTER JOIN
12The column 'Salary' in table 'Employees' is of type integer. This column does not accept null values. You want it to be of type 'Float'. You still do not want it to accept null values. What is the correct syntax?
- AALTER TABLE Employees ALTER COLUMN Salary float IS NOT NULL
- BALTER TABLE Employees ALTER Salary float(10) NOT NULL
- CALTER TABLE Employees ALTER COLUMN Salary float(10) NOT NULL
- DALTER TABLE Employees COLUMN Salary float(10) NOT NULL
13What command is using for deleting column 'Salary' from 'Employees' table?
- AALTER TABLE Employees DROP Salary
- BALTER TABLE Employees DELETE Salary
- CALTER TABLE Employees REMOVE Salary
- DALTER TABLE Employees CLEAR Salary
14Which is the correct format for create table ?
- ACREATE Employees TABLE (
EmpId NUMBER,
EmpName VARCHAR(25),
EmpPosition VARCHAR(25) ,
EmpDate DATE,
) - BCREATE TABLE Employees (
EmpId NUMBER,
EmpName VARCHAR(25),
EmpPosition VARCHAR(25) ,
EmpDate DATE,
) - CCREATE TABLE Employees (
EmpId,
EmpName,
EmpPosition ,
EmpDate,
) - DAll above
- ACREATE Employees TABLE (
15Which SQL statement lets you list all Employees whose total salary bonus amount is over 2000?
- ASELECT Employee_id, SUM(Bonus_Amount) FROM Employees GROUP BY Employee_id HAVING SUM(Bonus_Amount) > 5000
- BSELECT Employee_id, SUM(Bonus_Amount) FROM Employees GROUP BY Employee_id HAVING Bonus_Amount > 5000
- CSELECT Employee_id, SUM(Bonus_Amount) FROM Employees WHERE SUM(Bonus_Amount) > 5000 GROUP BY Employee_id
- DSELECT Employee_id, SUM(Bonus_Amount) FROM Employees WHERE Bonus_Amount > 5000 GROUP BY Employee_id
Information
- Description
- Quiz on SQL Knowkedge test, created by miasorubka on 30/06/2015.
- Author
- miasorubka
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz