SQL Knowkedge test

Question 1

What does SQL stand for?

Accepted Answer

Structured Query Language

Answer

Strong Question Language

Answer

Structured Question Language

Answer

Structured Quest Language

Question 2

The FROM SQL clause is used to…

Accepted Answer

Specify what table we are deleting data from

Accepted Answer

Specify what table we are selecting data from

Answer

Specify range for search condition

Answer

Specify search condition

Question 3

Which of the following is NOT a SQL keyword or SQL clause?

Accepted Answer

INVERT

Accepted Answer

MOVE

Accepted Answer

REMOVE

Answer

DELETE

Answer

UPDATE

Answer

ALTER

Answer

INSERT

Question 4

The UNION SQL clause can be used with

Accepted Answer

The SELECT clause only

Answer

The DELETE and UPDATE clauses

Answer

The UPDATE clause only

Answer

The DELETE clause only

Question 5

Which SQL statement inserts data into a table called Projects?

Accepted Answer

INSERT Employees (FullName, ProjectName) VALUES ('Yuriy Shovkun, Cartera')

Answer

INSERT INTO Employees (FullName, ProjectName) VALUES (Yuriy Shovkun, Cartera)

Answer

INSERT INTO Employees (FullName, ProjectName) VALUES ('Yuriy Shovkun, Cartera')

Answer

INSERT INTO Employees (FullName, ProjectName) VALUES ('Yuriy Shovkun', 'Cartera')

Question 6

Which of the following SQL statements is logically correct?

Accepted Answer

SELECT ProjectName, COUNT(ProjectName) FROM Employees GROUP BY ProjectName

Answer

SELECT ProjectName, COUNT(ProjectName) FROM Employees

Answer

SELECT ProjectName, COUNT(ProjectName) FROM Employees SORT BY ProjectName

Answer

SELECT ProjectName, COUNT(ProjectName) FROM Employees ORDER BY ProjectName

Question 7

Is it possible to insert 'null' value into Foreign Key?

Answer

true

Question 8

Select correct SQL field data types

Accepted Answer

INTEGER

Accepted Answer

VARCHAR

Accepted Answer

CHARACTER

Accepted Answer

TIME

Accepted Answer

TIMESTAMP

Accepted Answer

BOOLEAN

Answer

DOUBLE BOOLEAN

Answer

YEAR

Answer

INCREMENT

Answer

MULTISET

Question 9

What data type is using for store True/False values?

Accepted Answer

BOOLEAN

Answer

VARCHAR

Answer

FLOAT

Answer

DECIMAL

Question 10

What is the type of JOIN do you see in the picture?

Accepted Answer

FULL OUTER JOIN

Answer

INNER JOIN

Answer

LEFT RIGHT JOIN

Answer

FULL INNER JOIN

Question 11

What is the type of JOIN do you see in the picture?

Accepted Answer

RIGHT  JOIN with MINUS KEY (if NULL value)

Answer

RIGHT JOIN

Answer

RIGHT INNER JOIN

Answer

RIGHT OUTER JOIN

Question 12

The 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?

Accepted Answer

ALTER TABLE Employees ALTER COLUMN Salary float(10) NOT NULL

Answer

ALTER TABLE Employees ALTER COLUMN Salary float IS NOT NULL

Answer

ALTER TABLE Employees ALTER Salary float(10) NOT NULL

Answer

ALTER TABLE Employees  COLUMN Salary float(10) NOT NULL

Question 13

What command is using for deleting column 'Salary' from 'Employees' table?

Accepted Answer

ALTER TABLE Employees DROP Salary

Answer

ALTER TABLE Employees DELETE Salary

Answer

ALTER TABLE Employees REMOVE Salary

Answer

ALTER TABLE Employees CLEAR  Salary

Question 14

Which is the correct format for create table ?

Accepted Answer

CREATE TABLE Employees (
EmpId NUMBER,
EmpName VARCHAR(25),
EmpPosition VARCHAR(25) ,
EmpDate DATE,
)

Answer

CREATE Employees TABLE (
EmpId NUMBER,
EmpName VARCHAR(25),
EmpPosition VARCHAR(25) ,
EmpDate DATE,
)

Answer

CREATE TABLE Employees (
EmpId,
EmpName,
EmpPosition ,
EmpDate,
)

Answer

All above

Question 15

Which SQL statement lets you list all Employees whose total salary bonus amount is over 2000?

Accepted Answer

SELECT Employee_id, SUM(Bonus_Amount) FROM Employees GROUP BY Employee_id HAVING SUM(Bonus_Amount) > 5000

Answer

SELECT Employee_id, SUM(Bonus_Amount) FROM Employees GROUP BY Employee_id HAVING Bonus_Amount > 5000

Answer

SELECT Employee_id, SUM(Bonus_Amount) FROM Employees WHERE SUM(Bonus_Amount) > 5000 GROUP BY Employee_id

Answer

SELECT Employee_id, SUM(Bonus_Amount) FROM Employees WHERE Bonus_Amount > 5000 GROUP BY Employee_id

SQL Knowkedge test

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden

Fragen in diesem Quiz (15)

Informationen

Feedback

Wie gefällt dir das neue Design?