SQL Operators Arithmetic

AND, OR, NOT, LIKE, IN, BETWEEN, EXISTS, ANY, ALL

SQL Operators Comparison

AND, OR, NOT, LIKE, IN, BETWEEN, EXISTS, ANY, ALL

SQL Operators Compound

AND, OR, NOT, LIKE, IN, BETWEEN, EXISTS, ANY, ALL

SQL Operators Logical

AND, OR, NOT, LIKE, IN, BETWEEN, EXISTS, ANY, ALL

SQL Data Definition Commands Syntax for CREATE DATABASE

CREATE DATABASE = database_name;

SQL Data Definition Commands Syntax for DROP DATABASE

REMOVE DATABASE = database_name;

DESTROY DATABASE database_name;

SQL Data Definition Commands Syntax for CREATE TABLE

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

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

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

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

SQL Data Definition Commands Syntax to add in ALTER TABLE

ALTER TABLE table_name ADD column datatype;

ADD COLUMN table_name ALTER column datatype;

ALTER TABLE table_name COLUMN ADD datatype;

ALTER table_name ADD COLUMN datatype;

SQL Data Definition Commands Syntax to delete in ALTER TABLE

ALTER TABLE table_name DROP COLUMN column_name;

ALTER TABLE table_name DROP column column_name;

DROP COLUMN table_name ALTER column column_name;

DELETE COLUMN table_name column column_name;

SQL Data Definition Commands Syntax to modify in ALTER TABLE

ALTER TABLE table_name ALTER COLUMN column_name datatype;

ALTER TABLE table_name MODIFY COLUMN column_name datatype;

ALTER TABLE table_name CHANGE COLUMN column_name datatype;

MODIFY TABLE table_name ALTER COLUMN column_name datatype;

SQL Constraints Syntax for UNIQUE on ALTER TABLE

ALTER TABLE table_name ADD UNIQUE (column_name);

ALTER TABLE table_name ADD CONSTRAINT UNIQUE (column_name);

ALTER TABLE table_name UNIQUE COLUMN (column_name);

ALTER TABLE table_name ADD COLUMN UNIQUE (column_name);

SQL Constraints Syntax for PRIMARY KEY on ALTER TABLE

ALTER TABLE table_name ADD PRIMARY KEY (column_name);

ALTER TABLE table_name ADD CONSTRAINT PRIMARY KEY (column_name);

ALTER TABLE table_name PRIMARY KEY (column_name);

ALTER TABLE table_name ADD COLUMN PRIMARY KEY (column_name);

SQL Constraints Syntax for FOREIGN KEY on ALTER TABLE

ALTER TABLE table1_name ADD FOREIGN KEY (table1_column) REFERENCES table2_name (table2_column);

ALTER TABLE table1_name ADD CONSTRAINT FOREIGN KEY (table1_column) REFERENCES table2_name (table2_column);

ALTER TABLE table1_name ADD KEY FOREIGN (table1_column) REFERENCES table2_name (table2_column);

ALTER TABLE table1_name ADD FOREIGN (table1_column) REFERENCES table2_name (table2_column);

SQL Constraints Syntax for CHECK on ALTER TABLE

ALTER TABLE table_name ADD CHECK (condition);

ALTER TABLE table_name CHECK (condition);

ALTER TABLE table_name ADD CONSTRAINT CHECK (condition);

ALTER TABLE table_name ADD CONDITION (CHECK condition);

SQL Constraints Syntax for DEFAULT on ALTER TABLE

ALTER TABLE table_name ADD CONSTRAINT constraint_name DEFAULT 'value' FOR column;

ALTER TABLE table_name ADD DEFAULT constraint_name 'value' FOR column;

ALTER TABLE table_name ADD CONSTRAINT DEFAULT 'value' FOR column;

ALTER TABLE table_name ADD CONSTRAINT constraint_name DEFAULT 'value' TO column;

Information Management Prefinals

Authored by Zandar Kuwabara

Computers

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

73 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is a specific request for data manipulation issued by the end-user or the application to the DBMS

Query

Structured Query Language

DBMS

Server

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL stands for?

Structured Query Language

Structure Queries Language

Sequential Query Language

System Query Language

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How is SQL commonly pronounced?

Only as "sequel"

Only as individual letters: "S-Q-L"

Both as "S-Q-L" and "sequel", depending on preference

As "Squeal", following standard acronym pronunciation rules

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a function of SQL?

Create database and table structures

Perform various types of data manipulation and data administration

Query the database to extract useful information

Design the user interface for database applications

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Among are the popular Database Management tools EXCEPT

Microsoft SQL Server

MySQL

Oracle RDBMS

Microsoft Access

Netbeans

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL Data Types
Exact Numeric

bigint, bit, decimal, int, money, numeric

float, real

date, datetime, time

char, text, varchar

nchar, ntext, nvarchar

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL Data Types
Approximate Numeric

bigint, bit, decimal, int, money, numeric

float, real

date, datetime, time

char, text, varchar

nchar, ntext, nvarchar

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

75 questions

JAVASCRIPT-STRING,ARRAYS,FUNCTIONS

Quiz

•

University

76 questions

MOC10961

Quiz

•

University

70 questions

Exchange Quiz

Quiz

•

KG - University

68 questions

Modules 9 - 12

Quiz

•

University

71 questions

Data Communication and Networking 3 Prefinal Exam

Quiz

•

University

69 questions

SE2 - Lesson 3 (Systems Analysts Tools)

Quiz

•

University

77 questions

CS 1301 Final Exam Review

Quiz

•

University

77 questions

unit 1 ad soft_

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

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

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

Information Management Prefinals