What are some other data types in SQL?

cursor, sql_variant, table, uniqueidentifier, xml.

What is the syntax to create a new database in SQL?

CREATE DATABASE database_name;.

What is the syntax to create a new table in SQL?

CREATE TABLE table_name (column1 datatype, ...);.

Provide an example of creating a new table in SQL.

CREATE TABLE Students (StudentID varchar(11), LastName varchar(99), FirstName varchar(99), Section varchar(5));.

What is the syntax to add a column in an existing table in SQL?

ALTER TABLE table_name ADD column datatype;.

Provide an example of adding a column in an existing table in SQL.

ALTER TABLE Students ADD MiddleName varchar(99);.

What is the syntax to drop a column in an existing table in SQL?

ALTER TABLE table_name DROP COLUMN column;.

Provide an example of dropping a column in an existing table in SQL.

ALTER TABLE Students DROP COLUMN Section;.

What is the syntax to modify a column in an existing table in SQL?

ALTER TABLE table_name ALTER COLUMN column datatype;.

Provide an example of modifying a column in an existing table in SQL.

ALTER TABLE Students ALTER COLUMN MiddleName nvarchar(99);.

What does NOT NULL constraint do in SQL?

Ensures that a column cannot have a NULL value.

Provide an example of NOT NULL constraint in CREATE TABLE.

CREATE TABLE Students (StudentID varchar(11) NOT NULL, LastName varchar(99) NOT NULL, FirstName varchar(99) NOT NULL, Section varchar(5));.

What does UNIQUE constraint do in SQL?

Ensures that all values in a column are different.

Provide an example of UNIQUE constraint in CREATE TABLE.

CREATE TABLE Students (StudentID varchar(11) NOT NULL UNIQUE, LastName varchar(99) NOT NULL, FirstName varchar(99) NOT NULL, Section varchar(5));.

What does PRIMARY KEY constraint do in SQL?

Uniquely identifies each row in a table.

Provide an example of PRIMARY KEY constraint in CREATE TABLE.

CREATE TABLE Students (StudentID varchar(11) NOT NULL PRIMARY KEY, LastName varchar(99) NOT NULL, FirstName varchar(99) NOT NULL, Section varchar(5));.

What does FOREIGN KEY constraint do in SQL?

Uniquely identifies a row in another table.

Provide an example of FOREIGN KEY constraint in CREATE TABLE.

CREATE TABLE Orders (OrderID int NOT NULL PRIMARY KEY, TableNumber int NOT NULL, CustomerID int FOREIGN KEY REFERENCES Customers (CustomerID));.

What does CHECK constraint do in SQL?

Ensures that all values in a column satisfy a specific condition.

Provide an example of CHECK constraint in CREATE TABLE.

CREATE TABLE Students (StudentID varchar(11) NOT NULL, LastName varchar(99) NOT NULL, FirstName varchar(99) NOT NULL, Age int CHECK (Age>=15));.

What does DEFAULT constraint do in SQL?

Sets a default value for a column when there is no value specified.

Provide an example of DEFAULT constraint in CREATE TABLE.

CREATE TABLE Students (StudentID varchar(11) NOT NULL, LastName varchar(99) NOT NULL, FirstName varchar(99) NOT NULL, Section varchar(5) DEFAULT 'Not yet enrolled');.

Introduction to SQL (Part I) Flashcards

Student preview

38 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What is a query in SQL?

Back

A specific request for data manipulation issued by the end-user or the application to the DBMS.

2.

FLASHCARD QUESTION

Front

What does SQL stand for?

Back

Structured Query Language.

3.

FLASHCARD QUESTION

Front

How is SQL pronounced?

Back

As S-Q-L or 'sequel'.

4.

FLASHCARD QUESTION

Front

What are the main functions of SQL commands?

Back

Create database and table structures, perform various types of data manipulation and data administration, and query the database to extract useful information.

5.

FLASHCARD QUESTION

Front

Name some popular Database Management Tools.

Back

Microsoft SQL Server, MySQL, Oracle RDBMS, Microsoft Access.

6.

FLASHCARD QUESTION

Front

What are the common exact numeric data types in SQL?

Back

bigint, bit, decimal, int, money, numeric.

7.

FLASHCARD QUESTION

Front

What are the approximate numeric data types in SQL?

Back

float, real.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Vocabulary Flashcard

Flashcard

•

University

23 questions

Automata Flashcard April 2025

Flashcard

•

University

45 questions

S1 Final Review (Chem)

Flashcard

•

KG - University

20 questions

TRẬT TỰ TÍNH TỪ P2

Flashcard

•

12th Grade

22 questions

Organic Chemistry Overview

Flashcard

•

University

35 questions

English Grammar and Vocabulary Flashcards

Flashcard

•

KG

36 questions

Intrebari teorie sunt doar 37/43

Flashcard

•

University

41 questions

Computer Science Concepts

Flashcard

•

University

Popular Resources on Wayground

8 questions

2 Step Word Problems

Quiz

•

KG - University

20 questions

Comparing Fractions

Quiz

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Latin Bases claus(clois,clos, clud, clus) and ped

Quiz

•

6th - 8th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

7 questions

The Story of Books

Quiz

•

6th - 8th Grade

Discover more resources for Computers

8 questions

2 Step Word Problems

Quiz

•

KG - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

10 questions

14.2 Independent/Dependent Variables

Quiz

•

KG - University

18 questions

Great Lakes States

Quiz

•

KG - University

7 questions

DNA, Chromosomes, Genes, and Traits: An Intro to Heredity

Interactive video

•

11th Grade - University

7 questions

Reflexive Verbs in Spanish

Lesson

•

9th Grade - University

7 questions

Narrative Writing 1

Interactive video

•

4th Grade - University