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 Quiz

73 questions

Show all answers

1.

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL stands for?

Structured Query Language

Structure Queries Language

Sequential Query Language

System Query Language

3.

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

4.

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Among are the popular Database Management tools EXCEPT

Microsoft SQL Server

MySQL

Oracle RDBMS

Microsoft Access

Netbeans

6.

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

7.

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

68 questions

IT

Quiz

•

University

70 questions

ÔN TẬP GK2 _ TIN 12

Quiz

•

12th Grade - University

75 questions

General Knowledge and Current Affairs Quiz

Quiz

•

University

75 questions

Đề 10 E3 HT 23.24

Quiz

•

University

75 questions

Đề 24 E3 HT 23.24

Quiz

•

University

71 questions

H446 Section 1: Components of a computer

Quiz

•

11th Grade - University

70 questions

ID and Access Management

Quiz

•

10th Grade - University

75 questions

PYTHON CERT REVIEWER

Quiz

•

University

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

KG

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Computers

20 questions

Disney Trivia

Quiz

•

University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

14 questions

Ch.3_TEACHER-led

Quiz

•

University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

Information Management Prefinals