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

Q

super key

A

Key constraines

Q

primary key

A

Key constraines

Q

Indexing

A

Views and Indexes

Q

Dense and Sparse index

A

View and Indexing

Q

Types of indexes

A

Views and Indexes

Q

Secondary index

A

View and indexing

Q

Nested loop join and Block nested loop join

A

Joins

Q

Left outer join and natural join

A

Joins

Q

correlated query

A

Queries and Sub Queries

Q

HAVING and GROUP BY

A

Queries and Sub Queries

Q

WITH attribute

A

SQL

Q

1NF

A

BCNF DBMS normalization

Q

Functional dependencies

A

Functional Dependency

Q

Trivial and Non trivial FD

A

Functional Dependency

Q

Properties of FD

A

Functional Dependency

Q

minimal keys or minimal superkeys

A

Functional Dependency

Q

Topological ordering of directed graph

A

File Structures (B+ tree)

Q

B tree and it’s properties

A

File Structures (B+ tree)

Q

B+ tree

A

File Structures (B+ tree)

Q

Difference between B tree and B+tree

A

File Structures (B+ tree)

Q

dependency preserving decomposition

A

BCNF

Q

lossless decomposition

A

BCNF

Q

Minimal cover of relation

A

Functional dependency