Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

32 cards

()

Section 1

Preview this deck

primary key (PK)

Front

1 / 32

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (32)

Section 1

(32 cards)

primary key (PK)

Front

A field (or group of fields) that uniquely identifies a given entity in a table

Back

Numeric values SQL

Front

NUMBER(4,2) = 99.99

Back

COUNT (subquery)

Front

Returns # of rows

Back

First Normal Form (1NF)

Front

A relation that has a primary key and in which there are no repeating groups.

Back

subquery

Front

a SELECT statement that is inside another select or action query (WHERE clause)

Back

finger user

Front

lists the login name, the full name, and possibly other details about the user you are fingering.

Back

RDBMS

Front

(Relational Database Management System) A software application that contains tools to manage data, answer queries, create user-friendly forms for data entry, and generate printed reports.

Back

<sysdate

Front

before today

Back

= (subquery)

Front

Allows one value

Back

DDL (Data Definition Language)

Front

Subset of SQL: Database and table structure

Back

WHERE

Front

Not used with aggregates

Back

NVL

Front

If it is possible for a subquery to return a NULL value to the outer query for comparison, the ____ function should be used to substitute an actual value for the NULL.

Back

To_char(SYSDATE,'MM-YY')

Front

this month

Back

like sysdate

Front

today

Back

Used with a join?

Front

ON

Back

Third Normal Form (3NF)

Front

A table is in 3NF when it is in 2NF and no nonkey attribute is functionally dependent on another nonkey attribute; that is, it cannot include transitive dependencies.

Back

ERD (Entity Relationship Diagram) / schema

Front

A database design diagram: The major entities within the system scope, and the inter-relationships among these entities.

Back

DCL (Data Control Language)

Front

Subset of SQL: Gives user privileges

Back

inline view

Front

A subquery in the FROM clause of a SELECT statement.

Back

String values SQL

Front

VARCHAR2(Length)

Back

in (subquery)

Front

Allows multiple values

Back

left outer join

Front

A join that includes all of the rows from the first table in the query and only those records from the second table that match the join field in the first table.

Back

Union All

Front

everything from both tables with duplicates

Back

DML (Data Manipulation Language)

Front

Subset of SQL: Accessing, inserting, modifying and deleting data

Back

HAVING

Front

used with aggregates

Back

foreign key (FK)

Front

Attribute that allows database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.

Back

Union

Front

everything from both tables

Back

date, varchar2, number

Front

The data types

Back

Date values SQL

Front

DATE

Back

Second Normal Form (2NF)

Front

The second stage in the normalization process, in which a relation is in 1NF and there are no partial dependencies (dependencies in only part of the primary key).

Back

to_char(ADD_MONTHS(SYSDATE,-1),'MM-YY')

Front

last month

Back

SUM (subquery)

Front

returns total sum of numeric values

Back