Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DBMS > SQL - RDBMS Concepts > Flashcards

SQL - RDBMS Concepts Flashcards

1
Q

RDBMS Concepts

RDBMS stands for

A

Relational Database Management System.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

RDBMS Concepts

The data in an RDBMS is stored in database objects which are called as

A

tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

RDBMS Concepts

is basically a collection of related data entries and it consists of numerous columns and rows.

A

tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

RDBMS Concepts

Every table is broken up into smaller entities called

A

fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

RDBMS Concepts

is a column in a table that is designed to maintain specific information about every record in the table.

A

Answer: fields

+—-+———-+—–+———–+———-+
| ID | NAME | AGE | ADDRESS | SALARY |
+—-+———-+—–+———–+———-+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+—-+———-+—–+———–+———-+

The fields in the CUSTOMERS
table consist of ID, NAME, AGE, ADDRESS and SALARY.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

RDBMS Concepts

A record is also called as a _____ of data is each individual entry that exists in a table.

A

Answer: row

+—-+———-+—–+———–+———-+
| ID | NAME | AGE | ADDRESS | SALARY |
+—-+———-+—–+———–+———-+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+—-+———-+—–+———–+———-+

There are 7 records in the table CUSTOMERS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

RDBMS Concepts

is a horizontal entity in a table.

A

Answer: Record

+—-+———-+—–+———–+———-+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
+—-+———-+—–+———–+———-+

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

RDBMS Concepts

is a vertical entity in a table that contains all information associated with a specific field in a table.

A

Answer: Column

+———–+
| ADDRESS |
+———–+
| Ahmedabad |
| Delhi |
| Kota |
| Mumbai |
| Bhopal |
| MP |
| Indore |
+—-+——+

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

RDBMS Concepts

is a value in a field that appears to be blank (no value)

A

NULL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Identification

are the rules enforced on data columns on a table

A

Constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Identification

These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database.

A

Constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

SQL Constraints

are applied
only to one column

A

Column level constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

SQL Constraints

are applied to the entire table

A

table level constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

SQL Constraints

Ensures that a column cannot have a NULL value.

A

NOT NULL Constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

SQL Constraints

Provides a default value for a column when none is specified.

A

DEFAULT Constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

SQL Constraints

Ensures that all the values in a column are different.

A

UNIQUE Constraint

17
Q

SQL Constraints

Uniquely identifies each row/record in a database table.

A

PRIMARY Key

18
Q

SQL Constraints

Uniquely identifies a row/record in any another database table.

A

FOREIGN Key

19
Q

SQL Constraints

ensures that all values in a column satisfy certain conditions.

A

CHECK Constraint

20
Q

SQL Constraints

Used to create and retrieve data from the database very quickly.

A

INDEX

21
Q

Data Integrity

There are no duplicate rows in a table.

A

Entity Integrity

22
Q

Data Integrity

Enforces valid entries for a given column by restricting the
type, the format, or the range of values.

A

Domain Integrity

23
Q

Data Integrity

Rows cannot be deleted, which are used by other records.

A

Referential integrity

24
Q

Data Integrity

Enforces some specific business rules that do not fall
into entity, domain or referential integrity.

A

User-Defined Integrity

25
Q

Data Integrity

These categories of data integrity exist with each RDBMS:

A
  • Entity Integrity
  • Domain Integrity
  • Referential integrity
  • User-Defined Integrity
26
Q

Identification

is the process of efficiently organizing data in a database

A

Database normalization

27
Q

Database Normalization

There are two reasons of this normalization process:

A
  • Eliminating redundant data
  • Ensuring data dependencies make sense
28
Q

Database Normalization

Rules of First Normal form (1NF)

A
  1. Define the data items required, place the related data items in a table.
  2. Ensure that there are no repeating groups of data.
  3. Ensure that there is a primary key
29
Q

Database Normalization

Rules of Second Normal form (2NF)

A
  1. Meet all the rules for 1NF
  2. Remove partial dependences of any of the columns on the primary key
30
Q

Database Normalization

Rules of Third Normal form (3NF)

A
  1. Must be in 2NF
  2. Remove all transitive dependencies
31
Q

Database Normalization

A functional dependency between two (or more) nonkey attributes

A

Transitive Dependency

32
Q

Database Normalization

Q
a situation in which a non-key attribute of a table depends on only a part of the primary key.

A

Partial Dependency

DBMS (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions