Explain normalization with example (1NF, 2NF, 3NF)
|
|
2
|
1256
|
18 June 2022
|
There are 2 tables. One table has missing values in columns. So how do you perform join operation between those 2 tables?
|
|
2
|
378
|
18 June 2022
|
What are indexes and types of indexes in SQL?
|
|
0
|
137
|
18 June 2022
|
How to join columns of 3 different Tables?
|
|
3
|
354
|
18 June 2022
|
How to insert an index?
|
|
2
|
335
|
18 June 2022
|
What is the difference between DROP and TRUNCATE commands?
|
|
0
|
133
|
15 June 2022
|
What is AUTO_INCREMENT?
|
|
0
|
150
|
15 June 2022
|
What is an index?
|
|
0
|
120
|
15 June 2022
|
What is a primary key?
|
|
0
|
157
|
15 June 2022
|
What is meant by table and field in SQL?
|
|
0
|
148
|
15 June 2022
|
What is the DBMS primary key and foreign key?
|
|
0
|
160
|
13 June 2022
|
Do I really need triggers for relational database, for example, PostgreSQL?
|
|
0
|
139
|
12 June 2022
|
Does metadata only refer to the description of the attributes in RDBMS?
|
|
0
|
114
|
12 June 2022
|
Why would you add the same field multiple times to an aggregate query?
|
|
0
|
184
|
12 June 2022
|
Are there any OLTP databases that are able to replace the use of OLAP databases?
|
|
0
|
122
|
12 June 2022
|
SQL: What does it mean to own a schema?
|
|
0
|
113
|
12 June 2022
|
What is Instr in MySQL?
|
|
0
|
130
|
12 June 2022
|
How do we filter data in SQL?
|
|
2
|
279
|
12 June 2022
|
What is the difference between "like" and "wildcard" in SQL?
|
|
0
|
542
|
12 June 2022
|
What are views in SQL? How are they useful?
|
|
0
|
143
|
12 June 2022
|
Wildcards in SQL
|
|
2
|
303
|
12 June 2022
|
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
|
|
0
|
491
|
12 June 2022
|
Difference between where and having clause. When do we use where function and when do we use having a function
|
|
2
|
335
|
12 June 2022
|
Group BY and MERGE operation
|
|
3
|
349
|
12 June 2022
|
Explain subqueries
|
|
2
|
336
|
12 June 2022
|
Why is creating a data model for a beginner so time consuming and difficult to finish?
|
|
0
|
110
|
12 June 2022
|
How do I check the codes of an SQL database?
|
|
0
|
130
|
12 June 2022
|
How is data modified in a relational database?
|
|
0
|
143
|
12 June 2022
|
What is the main role of SQL?
|
|
0
|
123
|
12 June 2022
|
Is a Kafka topic the equivalent of a database or a table within a database?
|
|
0
|
142
|
12 June 2022
|