|
Explain normalization with example (1NF, 2NF, 3NF)
|
|
2
|
2237
|
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
|
521
|
18 June 2022
|
|
What are indexes and types of indexes in SQL?
|
|
0
|
316
|
18 June 2022
|
|
How to join columns of 3 different Tables?
|
|
3
|
544
|
18 June 2022
|
|
How to insert an index?
|
|
2
|
498
|
18 June 2022
|
|
What is the difference between DROP and TRUNCATE commands?
|
|
0
|
304
|
15 June 2022
|
|
What is AUTO_INCREMENT?
|
|
0
|
303
|
15 June 2022
|
|
What is an index?
|
|
0
|
270
|
15 June 2022
|
|
What is a primary key?
|
|
0
|
343
|
15 June 2022
|
|
What is meant by table and field in SQL?
|
|
0
|
483
|
15 June 2022
|
|
What is the DBMS primary key and foreign key?
|
|
0
|
341
|
13 June 2022
|
|
Do I really need triggers for relational database, for example, PostgreSQL?
|
|
0
|
302
|
12 June 2022
|
|
Does metadata only refer to the description of the attributes in RDBMS?
|
|
0
|
255
|
12 June 2022
|
|
Why would you add the same field multiple times to an aggregate query?
|
|
0
|
369
|
12 June 2022
|
|
Are there any OLTP databases that are able to replace the use of OLAP databases?
|
|
0
|
286
|
12 June 2022
|
|
SQL: What does it mean to own a schema?
|
|
0
|
282
|
12 June 2022
|
|
What is Instr in MySQL?
|
|
0
|
269
|
12 June 2022
|
|
How do we filter data in SQL?
|
|
2
|
443
|
12 June 2022
|
|
What is the difference between "like" and "wildcard" in SQL?
|
|
0
|
1445
|
12 June 2022
|
|
What are views in SQL? How are they useful?
|
|
0
|
380
|
12 June 2022
|
|
Wildcards in SQL
|
|
2
|
456
|
12 June 2022
|
|
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
|
|
0
|
3089
|
12 June 2022
|
|
Difference between where and having clause. When do we use where function and when do we use having a function
|
|
2
|
523
|
12 June 2022
|
|
Group BY and MERGE operation
|
|
3
|
532
|
12 June 2022
|
|
Explain subqueries
|
|
2
|
505
|
12 June 2022
|
|
Why is creating a data model for a beginner so time consuming and difficult to finish?
|
|
0
|
260
|
12 June 2022
|
|
How do I check the codes of an SQL database?
|
|
0
|
298
|
12 June 2022
|
|
How is data modified in a relational database?
|
|
0
|
283
|
12 June 2022
|
|
What is the main role of SQL?
|
|
0
|
275
|
12 June 2022
|
|
Is a Kafka topic the equivalent of a database or a table within a database?
|
|
0
|
316
|
12 June 2022
|