Free WebSchools.com

HOME

HTML Test
PHP Test
JSP Test
Java Test
ASP Test
XML Test
XHTML Test
MYSQL Test

Test Your Knowledge

A database is a container to store organized data
Yes
No

_____________ is a structured list of data of specific type
table
row
column

_________ is a single field in a table.
Table
row
column

_____ is a record in a table
row
column
none of the above

___________ is a set of column whose values uniquely identify every row ina table.
Primary key
Secondary key
null key

SQL stands for
structured query letter
structured query language
structured quest language

____________ use select to retrive data from the table.
where
Select
retrive

can we retrive multiple column from the database.
yes
no

within a select statement data is filtered by specify search criteria in the _____________ clause.
Select
where
why

To check for a range of values you can use ________ operators
Select
Between
OR

To filter by more than one column you use the _______ operator to append condition to your WHERE clause
Between
OR
AND

can we do mathemetical calculation on retrived data from database
yes
no

SQL server _______________ function which returns a part of a data
DATEPART()
DATEADD()
GETDATE()

________________ unction returns the number of rows in a column.
count()
num()
rows()

we can join multiple tables
Yes
No

using _____________ multiple select statement can be specified and their results can be combined int a single result set.
union
add
sum

each query in a UNION must contain the same columns expression or aggregate functions.
Yes
No

select statement output is sorted by using ____________ clause.
Sort
ORDER BY
Union

a table can contain multiple unique constraints but only one primary key is allowed per table.
Yes
No