Explain normalization with example (1NF, 2NF, 3NF)
|
|
2
|
1997
|
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
|
509
|
18 June 2022
|
What are indexes and types of indexes in SQL?
|
|
0
|
308
|
18 June 2022
|
How to join columns of 3 different Tables?
|
|
3
|
533
|
18 June 2022
|
How to insert an index?
|
|
2
|
495
|
18 June 2022
|
What is the difference between DROP and TRUNCATE commands?
|
|
0
|
299
|
15 June 2022
|
What is AUTO_INCREMENT?
|
|
0
|
299
|
15 June 2022
|
What is an index?
|
|
0
|
261
|
15 June 2022
|
What is a primary key?
|
|
0
|
337
|
15 June 2022
|
What is meant by table and field in SQL?
|
|
0
|
478
|
15 June 2022
|
What is the DBMS primary key and foreign key?
|
|
0
|
340
|
13 June 2022
|
Do I really need triggers for relational database, for example, PostgreSQL?
|
|
0
|
301
|
12 June 2022
|
Does metadata only refer to the description of the attributes in RDBMS?
|
|
0
|
251
|
12 June 2022
|
Why would you add the same field multiple times to an aggregate query?
|
|
0
|
366
|
12 June 2022
|
Are there any OLTP databases that are able to replace the use of OLAP databases?
|
|
0
|
283
|
12 June 2022
|
SQL: What does it mean to own a schema?
|
|
0
|
274
|
12 June 2022
|
What is Instr in MySQL?
|
|
0
|
265
|
12 June 2022
|
How do we filter data in SQL?
|
|
2
|
440
|
12 June 2022
|
What is the difference between "like" and "wildcard" in SQL?
|
|
0
|
1417
|
12 June 2022
|
What are views in SQL? How are they useful?
|
|
0
|
374
|
12 June 2022
|
Wildcards in SQL
|
|
2
|
441
|
12 June 2022
|
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
|
|
0
|
2844
|
12 June 2022
|
Difference between where and having clause. When do we use where function and when do we use having a function
|
|
2
|
504
|
12 June 2022
|
Group BY and MERGE operation
|
|
3
|
517
|
12 June 2022
|
Explain subqueries
|
|
2
|
494
|
12 June 2022
|
Why is creating a data model for a beginner so time consuming and difficult to finish?
|
|
0
|
256
|
12 June 2022
|
How do I check the codes of an SQL database?
|
|
0
|
292
|
12 June 2022
|
How is data modified in a relational database?
|
|
0
|
282
|
12 June 2022
|
What is the main role of SQL?
|
|
0
|
273
|
12 June 2022
|
Is a Kafka topic the equivalent of a database or a table within a database?
|
|
0
|
313
|
12 June 2022
|