Category: Database

Enable Binary Logs In MySQL Server 0

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...

Shares 0
DML (Data Manipulation Language) Commands in MySQL 0

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...

Shares 0
DDL (Data Definition Language) Commands in MySQL 0

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, it...

Shares 0
PostgresSQL Interview Questions & Answers 0

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...

Shares 0
Mongodb  Interview Questions & Answers part 2 0

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...

Shares 0
Mongodb  Interview Questions & Answers part 1 0

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...

Shares 0
SQL server Interview Questions & Answers 0

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...

Shares 0
Sybase Interview Questions & Answers part 2 0

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...

Shares 0
Sybase Interview Questions & Answers part 1 0

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...

Shares 0
Oracle Interview Questions & Answers part 2 0

Oracle Interview Questions & Answers part 2

Q: – What is the maximum number of triggers, can apply to a single table? 12 triggers Q: – What are the components of physical...

Shares 0