Tuesday, 20 October 2015

Manage SPF Record - How to add SPF Record?

Manage SPF Record - How to add Spf Record?


Question: What is SPF Record?
An SPF record is a type of DNS record that identifies which mail servers are permitted to send email on behalf of your domain. Full form of DNS is Domain Name Service.


Question: What is purpose of SPF Record?
It identifies which mail servers are permitted to send email on behalf of your domain. In this way, It help us to prevent from spammer email.

Question: How to add SPF record?
You manage SPF Record, you must need have access DNS Manager.


Question: How to add SPF Record in Godaddy.com?
https://www.mail-tester.com/spf/godaddy

IF you are using other than Godaddy then check your "Web hosting company"
https://www.mail-tester.com/spf/

Question: Can we add two domain in SPF Record?
Yes, you can add two OR more domain in SPF Record.


Question: Can we add Two SPF Record
No, you can't add two OR more SPF Record.
Multiple SPF records will cause the SPF evaluation to fail with "permerror" (see RFC 7208, Section 4.5.).
But you can add multiple domain in Single SPF Record.


Question: How to add multiple domain in Single SPF Domain?
Single Domain in single SPF Record
v=spf1 include:spf.protection.outlook.com -all

Two Domain in single SPF Record
v=spf1 include:spf.protection.outlook.com include:spf.mandrillapp.com -all

Three Domain in single SPF Record
v=spf1 include:spf.protection.outlook.com include:spf.mandrillapp.com include:spf.domain.com  -all

Question: How to check SPF Record is available OR Not?
Make sure there is NO Error.


Question: How to Remove "support@mail128-15.atl41.mandrillapp.com" In Email's from?
To remove this text, you need to add SPF & DKIM Record in your DNS.
https://mandrill.zendesk.com/hc/en-us/articles/205582277-How-do-I-add-DNS-records-for-my-sending-domains-

Thursday, 15 October 2015

DBMS Interview Questions and Answers for Freshers


DBMS Interview Questions and Answers for Freshers


Question: What is database?
Database is a collection of information which are stored in organised way.


Question: What is DBMS?
Full for of DBMS is Database Management System.
It is Management System which manage the databases and its table.


Question: What are the advantages of using DBMS?
  1. Backup and Recovery
  2. It contains two-dimensional tables with rows and columns.
  3. Integrity constraints
  4. Redundancy can be reduced
  5. Give Access to User in controlled way.


Question: What are the disadvantage in File Processing System?
  1. Data redundancy and inconsistency.
  2. Data integrity.
  3. Security Problems
  4. Data isolation.
  5. Difficult in accessing data.



Question:What is Data Model?
A collection of conceptual tools for describing data, data relationships, data semantics & constraints.
Question: What is normalization?
Normalization is the process of organizing tables in such a way that the results are always unambiguous, accurate and fast.


Question: What is BCNF (Boyce-Codd Normal Form)?
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.


Question: What is RDBMS?
Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model.


Question: What is SQL?
Structured Query Language is a language designed specifically for communicating with databases to get the required results.


Question: What is a Record in a database?
A record is the collection of values / fields of a specific entity: i.e. an Employee.
It have employee details like employee id,name, email and address etc.


Question: What is Object Oriented model?
This model is based on collection of objects.


Question: What is an Entity?
small independent things.


Question: What is an Entity type?
It is a collection (set) of entities that have same or different attributes.


Question: What is Weak Entity set?
An entity set may not have sufficient attributes to form a primary key.


Question: What is DDL?
Full form of DDL is Data Definition Language.
DDL is a standard for commands that define the different structures in a database.
DDL statements create, modify and remove database objects such as tables, indexes, and users.
Most Common DDL statements are CREATE, ALTER and DROP.


Question: What is Data mining?
Data mining is a process of analyzing current data and summarizing the information in more useful.