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

31 questions

ASL Countries and Classifiers

Flashcard

•

University

28 questions

Supply & Demand

Flashcard

•

12th Grade

30 questions

Algebra Functions Vocabulary

Flashcard

•

12th Grade

37 questions

Culinary Arts 1 - Objective 5.01 Flashcards - Review Questions

Flashcard

•

11th Grade

25 questions

Solutions Review

Flashcard

•

KG - University

25 questions

Midterm Review

Flashcard

•

University

20 questions

DBMS Introduction Flashcard 1

Flashcard

•

University

20 questions

Futuro Irregulares

Flashcard

•

KG - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University