Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
Oracle Syntax Quiz (revised from MySQL quiz)

Oracle Syntax Quiz (revised from MySQL quiz)

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
42 cards
()
Section 1

Preview this deck

SQL UNIQUE Constraint on CREATE TABLE, no name

Front

1 / 42

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (42)

Section 1

(42 cards)

SQL UNIQUE Constraint on CREATE TABLE, no name

Front

CREATE TABLE tableName ( columnName1 datatype UNIQUE );

Back

SQL CREATE OR REPLACE VIEW Syntax

Front

CREATE OR REPLACE VIEW viewName AS SELECT columnName1, columnName2 FROM tableName WHERE condition;

Back

SQL PRIMARY KEY on ALTER TABLE, no name

Front

ALTER TABLE tableName ADD PRIMARY KEY (columnName1);

Back

CREATE INDEX Syntax

Front

CREATE INDEX indexName ON tableName (columnName1, columnName2);

Back

SQL DROP VIEW Syntax

Front

DROP VIEW viewName;

Back

DROP INDEX Statement

Front

DROP INDEX indexName;

Back

ALTER TABLE - ALTER/MODIFY COLUMN

Front

ALTER TABLE tableName MODIFY columnName1 datatype;

Back

SQL FOREIGN KEY on CREATE TABLE, Multiple Columns

Front

CREATE TABLE tableName ( columnName1 datatype PRIMARY KEY, CONSTRAINT constraintName FOREIGN KEY (columnName2) REFERENCES tableName (columnName3) );

Back

CREATE UNIQUE INDEX Syntax

Front

CREATE UNIQUE INDEX indexName ON tableName (columnName1, columnName2);

Back

DROP a UNIQUE Constraint

Front

ALTER TABLE tableName DROP CONSTRAINT constraintName;

Back

SQL ALTER TABLE - ADD COLUMN

Front

ALTER TABLE tableName ADD columnName1 datatype;

Back

SQL PRIMARY KEY on CREATE TABLE, Multiple Columns

Front

CREATE TABLE tableName ( columnName1 datatype, CONSTRAINT constraintName PRIMARY KEY (columnName1, columnName2) );

Back

DROP a FOREIGN KEY Constraint

Front

ALTER TABLE tableName DROP CONSTRAINT constraintName;

Back

SQL FOREIGN KEY on ALTER TABLE, Multiple Columns

Front

ALTER TABLE tableName ADD CONSTRAINT constraintName FOREIGN KEY (columnName1) REFERENCES tableName (columnName2);

Back

DROP a PRIMARY KEY Constraint

Front

ALTER TABLE tableName DROP CONSTRAINT constraintName;

Back

DEFINE

Front

Back

SQL DEFAULT on ALTER TABLE

Front

ALTER TABLE tableName MODIFY columnName1 DEFAULT 'value';

Back

SQL PRIMARY KEY on CREATE TABLE

Front

CREATE TABLE tableName ( columnName1 datatype PRIMARY KEY );

Back

SQL FOREIGN KEY on ALTER TABLE

Front

ALTER TABLE tableName ADD FOREIGN KEY (columnName1) REFERENCES tableName (columnName2);

Back

SQL Create Constraints

Front

CREATE TABLE tableName ( columnName1 datatype constraint );

Back

SQL Drop NOT NULL Constraint

Front

ALTER TABLE tableName MODIFY columnName1 NULL;

Back

SQL CHECK on ALTER TABLE, no name

Front

ALTER TABLE tableName ADD CHECK (columnName1 expression);

Back

SQL CREATE DB

Front

CREATE DATABASE databaseName;

Back

SQL UNIQUE Constraint on Alter TABLE, with name and/or multiple columns

Front

ALTER TABLE tableName ADD CONSTRAINT constraintName UNIQUE (columnName1, columnName2);

Back

DROP a CHECK Constraint

Front

ALTER TABLE tableName DROP CONSTRAINT constraintName;

Back

SQL PRIMARY KEY on ALTER TABLE, with name and/or multiple columns

Front

ALTER TABLE tableName ADD CONSTRAINT constraintName PRIMARY KEY (columnName1, columnName2);

Back

SQL UNIQUE Constraint on CREATE TABLE, with name and/or multiple columns

Front

CREATE TABLE tableName ( columnName1 datatype constraint, columnName2 datatype constraint, CONSTRAINT constraintName UNIQUE (columnName1, columnName2) );

Back

DROP a DEFAULT Constraint

Front

ALTER TABLE tableName ALTER COLUMN columnName1 DROP DEFAULT;

Back

Auto Increment (Default)

Front

CREATE SEQUENCE sequenceName MINVALUE # INCREMENT BY # START WITH # CACHE #;

Back

OFFSET/FETCH

Front

SELECT columnname1 FROM tablename (OFFSET rowCount ROWS) FETCH NEXT | FIRST (rowCount | percent PERCENT) ROWS (ONLY | WITH TIES ) );

Back

SQL DROP DB

Front

DROP DATABASE databaseName;

Back

SQL DROP TABLE

Front

DROP TABLE tableName;

Back

CREATE VIEW Syntax

Front

CREATE VIEW viewName AS SELECT columnName1, columnName2 FROM tableName WHERE condition;

Back

SQL TRUNCATE TABLE

Front

TRUNCATE TABLE tableName;

Back

SQL ALTER TABLE - DROP COLUMN

Front

ALTER TABLE tableName DROP COLUMN columnName1;

Back

SQL DEFAULT on CREATE TABLE

Front

CREATE TABLE tableName ( columnName1 datatype DEFAULT 'value'/function );

Back

SQL NOT NULL Constraint

Front

CREATE TABLE tableName ( columnName1 datatype NOT NULL );

Back

SQL UNIQUE Constraint on ALTER TABLE, no name

Front

ALTER TABLE tableName ADD UNIQUE (columnName1);

Back

SQL CREATE TABLE

Front

CREATE TABLE tableName ( columnName1 datatype );

Back

SQL FOREIGN KEY on CREATE TABLE

Front

CREATE TABLE tableName ( columnName1 datatype PRIMARY KEY, columnName2 datatype FOREIGN KEY REFERENCES tableName (columnName3) );

Back

SQL CHECK on CREATE TABLE

Front

CREATE TABLE tableName ( columnName1 datatype, columnName2 datatype, columnName3 datatype CHECK (columnName3 expression) );

Back

SQL CHECK on CREATE TABLE, Multiple Columns

Front

CREATE TABLE tableName ( columnName1 datatype, columnName2 datatype, CONSTRAINT constraintName CHECK (columnName1 expression AND columnName2 expression) );

Back