Skip to content

Posts tagged ‘database’

Which database is considered the number one database?

1/10 Which database is considered the number one database?

There’s no single database that can be considered the “number one” database, as the best choice depends on the specific use case and requirements. However, some of the most popular and widely-used databases include:

2/10 MySQL – an open-source relational database management system widely used for web-based applications.

3/10 PostgreSQL – an open-source relational database known for its strong community and support for advanced data types.

4/10 MongoDB – a popular NoSQL database known for its flexibility and scalability.

5/10 Oracle – a commercial relational database widely used for enterprise applications and data warehousing.

6/10 Microsoft SQL Server – a commercial relational database from Microsoft, widely used for business intelligence and data warehousing.

7/10 Amazon Aurora – a cloud-based relational database offered by Amazon Web Services (AWS).

8/10 Cassandra – a NoSQL database known for its high performance and scalability, widely used for large-scale applications.

9/10 Firebase – a cloud-based NoSQL database offered by Google, widely used for building real-time mobile and web applications.

10/10 Ultimately, the choice of database will depend on the specific use case, requirements, and constraints of a particular project. It’s important to carefully evaluate and compare different options to determine the best fit.

ORA-1652: unable to extend temp segment by 128 in tablespace TEMP01

Problem:

TEMP tablespace was getting filled when running sql statement.

i increased the temp table size from 25g, 32g, 64 gb. in all cases it throws error.

Solution:

I ran sql tuning advisor on sql and it gave recommendation of profile, index and gather stats.

i created profile, index and gather stats. it did magic sql completed under 5 seconds and did not throw any error.

Oracle DBA Interview Question

Question: User called and said he or she dropped all tables in schema and want to restore it. How will you restore all tables?

Please post your answer in comments.

%d bloggers like this: