SQL Quiz

SQL Quiz

You can test your SQL skills with W3Schools' Quiz.

The Test

The test contains 25 questions and there is no time limit.
The test is not official, it's just a nice way to see how much you know, or don't know, about SQL.

Count Your Score

You will get 1 point for each correct answer. At the end of the Quiz, your total score will be displayed. Maximum score is 25 points.

Comments

Post a Comment

Popular posts from this blog

What is Data Flow Diagram (DFD)

Image
Data Flow Diagram Symbols. DFD Library Data Flow Diagram Symbols. DFD Library Data Flow Diagrams graphically represent the information transfers and process steps of a system. They visually depict how data are processed by a system in terms of inputs and outputs, how occurs the input in a system, how the data flow through an information system and where they are stored, and how occurs output from the system. DFDs give the overview of the system and models the processes aspects, they are maintained with other methods of structured systems analysis. The main goal of DFDs is achievement of understanding between developers and users. For their construction are used two notations - Gane-Sarson and Yourdon, each of them uses its own set of symbols. Data Flow Diagrams solution from Software Development area extends the ConceptDraw PRO software with templates, samples, and predesigned libraries of data flow diagram symbols for both notations, allowing you...
Read more

SQL CHECK Constraint

SQL CHECK Constraint SQL CHECK Constraint The CHECK constraint is used to limit the value range that can be placed in a column. If you define a CHECK constraint on a single column it allows only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row. SQL CHECK on CREATE TABLE The following SQL creates a CHECK constraint on the "Age" column when the "Persons" table is created. The CHECK constraint ensures that you can not have any person below 18 years: MySQL: CREATE TABLE Persons (     ID int NOT NULL ,     LastName varchar( 255 ) NOT NULL ,     FirstName varchar( 255 ),     Age int,     CHECK (Age>= 18 ) ); SQL Server / Oracle / MS Access: CREATE TABLE Persons (     ID int NOT NULL ,     LastName varchar( 255 ) NOT NULL...
Read more