Enable Binary Logs In MySQL Server
Overview :
The binary log contains events that describe database changes such as table creation operations or changes to table data. It also contains events...
DML (Data Manipulation Language) Commands in MySQL
Data Manipulation Language (DML) statements or commands are used for managing data within tables. Some commands of DML are:
Some commands of DML are:
SELECT -...
DDL (Data Definition Language) Commands in MySQL
DDL statements or commands are used to define and modify the database structure of your tables or schema. When you execute a DDL statement,...
PostgresSQL Interview Questions & Answers
Q: - What Is A Sequence?
A sequence is a special kind of database object designed for generating unique numeric identifiers. It is typically used...
Mongodb Interview Questions & Answers part 2
Q: - How long does replica set fail over take?
It may take 10-30 seconds for the primary to be declared down by the other...
Mongodb Interview Questions & Answers part 1
Q: - What makes Mongodb best?
Document-oriented
High performance
High availability
Easy scalability
Rich query language
Q: - If I am using replication, can some members use journaling and others...
SQL server Interview Questions & Answers
Q: - Can you explain about buffer cash and log Cache in sql server?
Buffer Cache: Buffer cache is a memory pool in which data...
Sybase Interview Questions & Answers part 2
Q: - What is ASA in Sybase?
ASA is a fully featured DBMS with transactional integrity, automatic rollback and recovery, declarative RI, triggers and stored...
Sybase Interview Questions & Answers part 1
Q: - What is the difference of a LEFT JOIN and an INNER JOIN statement?
A LEFT JOIN will take ALL values from the first...