-
Notifications
You must be signed in to change notification settings - Fork 13
/
dbms_important.html
148 lines (121 loc) · 7.76 KB
/
dbms_important.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta meta name="viewport" content="width=device-width, user-scalable=no" />
<title>Helpdesk</title>
</head>
<link rel="stylesheet" type="text/css" href="style.css?v=1" />
<script src="script.js"></script>
<script
src="https://cdn.jsdelivr.net/npm/@popperjs/[email protected]/dist/umd/popper.min.js"
integrity="sha384-7+zCNj/IqJ95wo16oMtfsKbZ9ccEh31eOz1HGyDuCQ6wgnyJNSYdrPa03rtR1zdB"
crossorigin="anonymous"
></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<link
rel="stylesheet"
href="https://cdn.jsdelivr.net/npm/[email protected]/font/bootstrap-icons.css"
/>
</div>
</div>
<body>
<header class="navbar navbar-expand-md d-flex flex-wrap justify-content-center p-3 mb-2 border-bottom">
<div class="container-fluid">
<a href="#" class="d-flex align-items-center mb-3 mb-md-0 me-md-auto link-body-emphasis text-decoration-none">
<img src="logo.png" id="imglogo">
<span class="fs-4 mr-5 lo"><h2 class="bold-text">Helpdesk</h2></span>
</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#collapsibleNavbar">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="collapsibleNavbar">
<ul class="nav nav-pills navbar-nav ms-auto" id="myNav">
<!-- Sem1 -->
<li class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false">Semister 1</a>
<ul class="dropdown-menu">
<li><a class="nav-link dropdown-item" href="c_language.html">C-Language</a></li>
</ul>
</li>
<li class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false">Semister 2</a>
<ul class="dropdown-menu">
<li><a class="nav-link dropdown-item" href="data_structure.html">Data Structure</a></li>
</ul>
</li>
<li class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false">Semister 3</a>
<ul class="dropdown-menu">
<!-- Add subjects for Sem1 here -->
<li><a class="nav-link dropdown-item" href="dbms.html">DBMS</a></li>
<li><a class="nav-link dropdown-item" href="mech_updated.html">Mechanics</a></li>
<li><a class="nav-link dropdown-item" href="object_updated.html">OOPS Code</a></li>
<li><a class="nav-link dropdown-item" href="daa_updated.html">DAA</a></li>
</ul>
</li>
<!-- Sem2 -->
<li class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false">Semister 4</a>
<ul class="dropdown-menu">
<li><a class="nav-link dropdown-item" href="python.html">Python</a></li>
<li><a class="nav-link dropdown-item" href="os.html">OS</a></li>
<li><a class="nav-link dropdown-item" href="web_tech.html">Web Technologies</a></li>
<li><a class="nav-link dropdown-item" href="archi.html">Comp. Architecture</a></li>
<li><a class="nav-link dropdown-item" href="math.html">Mathematics</a></li>
<li><a class="nav-link dropdown-item" href="archi_lab.html">Comp. Architecture Lab</a></li>
<li><a class="nav-link dropdown-item" href="web_tech_lab.html">Web Technologies Lab</a></li>
<li><a class="nav-link dropdown-item" href="os_lab.html">OS Lab</a></li>
<li><a class="nav-link dropdown-item" href="startup.html">Startup</a></li>
</ul>
<li><a class="nav-link dropdown-item" href="contributers.html"><center>Our Valuable Contributers</center></a></li>
</ul>
</li>
</ul>
</div>
</div>
</header>
<div id="body">
<center><h1>Important Questions</h1></center>
<div id="imp"></div>
<style>
body {
font-family: Arial, sans-serif;
line-height: 1.6;
margin: 20px;
}
h2 {
color: #333;
}
p {
color: #666;
}
</style>
</head>
<body>
<div id="watermark">@Debuggers</div>
<hr>
<p><strong>1. Definition of DBMS:</strong> A Database Management System (DBMS) is software that facilitates the creation, organization, retrieval, and management of data in a structured format...</p>
<p><strong>2. Advantages of DBMS:</strong> Data Integrity: Ensures accuracy and consistency of data. Data Security: Controls access to the data to prevent unauthorized usage...</p>
<p><strong>3. Components of DBMS:</strong> Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Transaction Control Language (TCL)...</p>
<p><strong>4. Entities and Attributes:</strong> An entity is a real-world object or concept represented in the database. Attributes are properties or characteristics of entities...</p>
<p><strong>5. Tables and Rows:</strong> Tables are the fundamental structure for organizing data in a relational database. Rows represent individual records in a table, and columns represent attributes...</p>
<p><strong>6. Primary Key:</strong> A primary key uniquely identifies each record in a table. It must be unique for each record and cannot contain NULL values...</p>
<p><strong>7. Foreign Key:</strong> A foreign key establishes a relationship between two tables. It refers to the primary key of another table and enforces referential integrity...</p>
<p><strong>8. Normalization:</strong> The process of organizing data to minimize redundancy and dependency. Normal forms (1NF, 2NF, 3NF, BCNF) help achieve a well-organized database...</p>
<p><strong>9. ACID Properties:</strong> Atomicity, Consistency, Isolation, and Durability ensure the reliability of transactions. For example, in a banking system, transferring funds from one account to another must maintain these ACID properties...</p>
<p><strong>10. Indexes:</strong> Indexes improve the speed of data retrieval operations. Clustered indexes determine the physical order of data, while non-clustered indexes do not...</p>
<p><strong>11. Joins:</strong> SQL JOIN operations (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN) combine rows from multiple tables based on related columns...</p>
<p><strong>12. Views:</strong> A view is a virtual table derived from the result of a SELECT query. It provides a way to present a specific perspective of the data to users...</p>
<p><strong>13. Stored Procedures and Triggers:</strong> Stored Procedures are precompiled sets of SQL statements executed with a single call. Triggers are sets of instructions that automatically execute in response to specific events...</p>
<p><strong>14. Database Design Considerations:</strong> Consider factors such as normalization, denormalization, data types, and performance trade-offs when designing a database schema...</p>
<p><strong>15. Database Optimization:</strong> Involves query optimization, index tuning, and caching to enhance database performance. Techniques such as proper indexing and query design can significantly impact performance.</p>
</body>
</head>
</center></div><br><br>
</div>
</body>
</html>