Useful tips for everyday
What is the datatype for money in SQL? Unlike the DECIMAL data type, the MONEY data type is always treated as a fixed-point decimal number.…
How do I delete backed up archive logs? How to delete old archive logs using RMAN Safely Delete one day old archive logs RMAN >…
In what year was the first ANSI standard for SQL issued? The first SQL standard was SQL-86. It was published in 1986 as ANSI standard…
Which strategy is used to improve query performance? There are two most common query optimization techniques – cost-based optimization and rule (logic) based optimization. For…
How to set the Oracle Database Xe environment variables? For example, to set your environment variables in Bourne, Bash, or Korn shell without being prompted…
How do you kill a long running query in SQL Server? You can use a keyboard shortcut ALT + Break to stop the query execution.…
How does PostgreSQL clean up dead tuples? PostgreSQL rather creates what is called a “dead tuple”. If there is no more dependency on those tuples…
How do I connect to a Postgres database container? Connecting to the PSQL server via CLI : Run the below command to enter into the…
What are the types of database schema? There are two main kinds of database schema: A logical database schema conveys the logical constraints that apply…
Which database has best performance? Let’s take a quick look at the top five databases in this ranking: MySQL. MySQL has been at the top…