Useful tips for everyday
What is kernel parameters in Oracle? We have kernel parameters to control the maximum, minimum and sizes of each page size that Oracle database will…
What is DB replica? Replication is the process of copying data from a central database to one or more databases. The central database is called…
How do I choose the right career for myself? Print out and keep this list of ways to pick your top career choices – and…
How do you find the maximum degree of parallelism in SQL Server? Using SQL Server Management Studio In Object Explorer, right-click a server and select…
How do you find the month name and year from a date? How to extract month name from date in Excel =TEXT(A2, “mmm”) – returns…
How do you select all records from one table that do not exist in another table in Oracle? “how to select all records from one…
Is MongoDB single threaded or multithreaded? ¶ MongoDB uses multi-granularity locking [1] that allows operations to lock at the global, database or collection level, and…
What do you think the biggest challenge would be in working with a DBA? There are three big challenges facing today’s DBAs—a shift to an…
How do I change dynamic data range in a pivot table? Use shortcut key Control + T or Go to → Insert Tab → Tables…
How to create an index on a single field? To create an index, you first decide whether you want to create a single-field index or…