DBMS Flashcards by Vansil Chauhan

Q

selection operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Projection Operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Union operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Set difference operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Set intersection operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

rename operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

cross product operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Natural Join operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Conditional Join

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Theta join

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

division operator

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

degree of a relation schema

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

power of relational algebra and relational calculus

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Safe and unsafe relational calculus

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Domain relational calculus

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

tuple relational calculus

A

Relational Algebra

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

SELECT operator

A

SQL

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

GROUP BY

A

SQL

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Operators in SQL

A

SQL

Q

one to many and many to many

A

Entity Relationship

Q

Symbols in ER Diagram

A

Entity Relationship

Q

ER Diagram

A

Entity Relationship

Q

prime attribute

A

Key constraints

Q

candidate key

A

Key constraines

super key

Key constraines

primary key

Key constraines

Indexing

Views and Indexes

Dense and Sparse index

View and Indexing

Types of indexes

Views and Indexes

Secondary index

View and indexing

Nested loop join and Block nested loop join

Joins

Left outer join and natural join

Joins

correlated query

Queries and Sub Queries

HAVING and GROUP BY

Queries and Sub Queries

WITH attribute

SQL

1NF

BCNF DBMS normalization

Functional dependencies

Functional Dependency

Trivial and Non trivial FD

Functional Dependency

Properties of FD

Functional Dependency

minimal keys or minimal superkeys

Functional Dependency

Topological ordering of directed graph

File Structures (B+ tree)

B tree and it’s properties

File Structures (B+ tree)

B+ tree

File Structures (B+ tree)

Difference between B tree and B+tree

File Structures (B+ tree)

dependency preserving decomposition

BCNF

lossless decomposition

BCNF

Minimal cover of relation

Functional dependency