SQL Training Test

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

SQL Training Test

Email *

1) Which of the following keywords is used to insert a data in SQL?

10 points

a) Insert New

b) Insert Into

c) Add

d) Create

Clear selection

2) There are 3 columns named “ID,Name and SurName” in a table named AdminUser. When we run which of the following queries, all Names in the table are written to the screen?

10 points

a) Select au.Name from AdminUser au

b) Select * from AdminUser

c) Select Name AdminUser

d) Select Name

Clear selection

3) Which of the following is true for Primary Keys?

10 points

a) They increase one by one

b) They are defined as Int

c) They must be defined as "Id" or "TablenameID"

d) None

Clear selection

4) There are 3 columns named “ID,Name and SurName” in a table named AdminUser. Which of the following queries will give me all the columns whose Name field is null?

10 points

a) Select * from AdminUser

b) Select Name from AdminUser where Name = null

c) Select * from AdminUser where Name is null

d) Select Name from AdminUser where Name is null

Clear selection

5) Which of the following keywords is used to sort the data in a table?

10 points

a) Sort by

b) Order by

c) Order

d) None

Clear selection

6) Which of the following functions can we use to find how many data there are in a table?

10 points

a) Len

b) Count

c) Columns

d) None

Clear selection

7) What is the name of the SQL object that we can run as a trigger after insert, update, delete operations on a table?

10 points

a) Transaction

b) Store Procedure

c) View

d) Trigger

Clear selection

8) Which of the following system databases stores the information and activities of users logged into SQL Server?

10 points

a) Tempdb

b) Master

c) Resource

d) Model

Clear selection

9) What is the name of the SQL object in which we save the previously determined query sets, which is also called a virtual table on SQL?

10 points

a) Store Procedure

b) View

c) Trigger

d) Transaction

Clear selection

10) What is the keyword that allows us to undo the transaction according to a certain condition in a transaction?

10 points

a) Commit

b) Rollback

c) End

d) The operation on SQL cannot be undone.

Clear selection

Submit

Clear form

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms