mysql different storage engines

MySql different storage engines
MySql different storage engines
Following are the basic storage engines available in mysql database.

One must have brief idea on these storage engines to face any kind of interview.

  • MyISAM - the default MySQL pluggable storage engine and the one that is used the most in Web, data warehousing, and other application environments. Note that a MySQL server's default storage engine can easily be changed by altering the STORAGE_ENGINE configuration variable
  • InnoDB - used for transaction processing applications, and sports a number of features including ACID transaction support.
  • BDB - an alternative transaction engine to InnoDB that supports COMMIT, ROLLBACK, and other transactional features.
  • Memory - stores all data in RAM for extremely fast access in environments that require quick look ups of reference and other like data.
  • Merge - allows a MySQL DBA or developer to logically group together a series of identical MyISAM tables and reference them as one object. Good for VLDB environments like data warehousing.
  • Archive - provides the perfect solution for storing and retrieving large amounts of seldom-referenced historical, archived, or security audit information.
  • Federated - offers the ability to link together separate MySQL servers to create one logical database from many physical servers. Very good for distributed or data mart environments.
  • Cluster/NDB - the Clustered database engine of MySQL that is particularly suited for applications with high performance lookup needs that also require the highest possible degree of uptime and availability.
  • Other - other storage engines include CSV (references comma-separated files as database tables), Blackhole (for temporarily disabling application input to the database) and an Example engine that helps jump start the process of creating custom pluggable storage engines.

networking jobs interview questions

networking interview questions and answers
OSI Model


How many layers are in OSI model? Name them
There are seven layers of OSI model. The layers are:
1.               Application layer
2.               Presentation layer
3.               Session layer
4.               Transport layer
5.               Network layer
6.               Data link layer
7.               Physical layer
Note: You can remember the seven layer model by a simple sentence. Please Do Not Touch Steven's Pet Alligator. See, the starting of each word forms the layer.
Why do you need to use a router?
Router can easily divide the broadcast domain and collision domain. So, to communicate among several networks, routers are used.
What is the second layer of OSI model?
Data Link layer.
Name two network devices which can work as layer 2 device.
Switch and router
What is OSI model?
OSI revers for Open System Interconnection Reference Model. It is an abstract model for layered communications and computer network protocol design. There are seven layers of OSI model which, from top to bottom, are the Application, Presentation, Session, Transport, Network, Data-Link, and Physical Layers.
OSI model also referred as OSI layered model, OIS layered technology, 7 layer model, OSI seven layer model, OSI reference model.
What is the data unit of Data Link layer?
Frame
What are the difference between TCP and UDP?
·                 TCP: Connection oriented protocol, acknowledged one, Point to point communication.
·                 UDP: Connection less protocol, unreliable, less traffic
What is the port no of DNS and Telnet?
·                 DNS port no: 53
·                 Telnet port no: 23
What is the port no of SMTP and POP3?
·                 SMPT port no: 25
·                 POP3 port no: 110
What is the functionality of network layer? Name the data unint of network layer.
·                 Functionality of network layer: Path determination and logical addressing
·                 Data unit of network layer: Packet
Which three layers of OSI model is treated as "Media Layers"?
Physical layer, data link layer and network layer are treated as "Media Layers".
What is deadlock?
Deadlock is a situation when two or more processes are waiting indefinitely for an event that can be caused by only one of the waiting processes. The implementation of a semaphore with a waiting queue may result in this situation.
Mention the advantages and disadvantages of a router.
Advantages:
·                 Router can limit the collision domain and broadcast domain
·                 Router can function both on LAN & WAN.
·                 Different media & architectures can be connected among themselves through router.
·                 Router can determine best path/route for data to reach
·                 the destination.
·                 Router can filter the broadcasts.
·                 For communicating different networks, routers must be used.
Disadvantage:
·                 Router is more expensive than any other networking devices like Hub, Bridge & Switch.
·                 Router only work with routable protocols.
·                 Routing updates consume some bandwidth.
·                 Increase latency due to greater degree of packet
·                 filtering.
·                 Routers function as software based and so it's slower compared to switch.
Mention the private IP address rannge of class B and C.
·                 For Class B: 172.16.0.0 – 172.31.255.255
·                 For Class C: 192.168.0.0 – 192.168.255.255
What is the IP range of class C IP address?
240.0.0.0      255.255.255.255
What is the default subnet mask of class C IP address?
255.255.255.0
Why do you need subnet mask?
Subnet mask is required to divide a large network into several small networks.
Tell the full name: DNS, FTP
·                 DNS: Domain Name System
·                 FTP: File Transfer Protocol
What is the functionality or ARP?
ARP refers to Address Resolution Protocol. ARP is a computer networking protocol for determining a network host's link layer or hardware address when only its Internet Layer (IP) or Network Layer address is known.
Which one is reliable: TCP or UDP?
TCP is reliable and UDP is an unreliable service.
How DHCP works?
DHCP works by four-steps: (1) IP request, (2) IP offer (3) IP selection and (d) Acknowledgement.
What is POP3? Why you require POP3?
POP stands for Post Office Protocol. This is used to describe how e-mail clients interact with mail servers. The POP3 Server is a type of mail server used for incoming mail. POP is only used to receive messages.
What is the difference between Layer 2 Switch and Layer 3 Switch?
Layer 2 switch is based on MAC addresses which operates on Data Link Layer of OSI mode. And Layer 3 switching is based on network topology table populated and works on Network layer.


Cheat Chart: Some common terms
·                 ARP: Address Resolution Protocol 
·                 DNS: Domain Name System
·                 FTP: File Transfer Protocol
·                 HTTP: Hypertext Transfer Protocol
·                 IP: Internet Protocol
·                 NNTP: Network News Transfer Protocol
·                 POP3: Post Office Protocol 3
·                 PPP: Point-to-Point Protocol
·                 SMPP: Short Message Peer-to-Peer 
·                 SMTP: Simple Mail Transfer Protocol
·                 TCP: Transmission Control Protocol
·                 UDP: User Datagram Protocol
Cheat Chart: OSI layers
OSI reference model has seven layers:
·                 Application layer
·                 Presentation layer
·                 Session layer
·                 Transport layer
·                 Network layer
·                 Data link layer
·                 Physical layer
Cheat Chart: OSI layers functionality
·                 Application layer: Network process to application
·                 Presentation layer: Data representation and encryption
·                 Session layer: Interhost communication
·                 Transport layer: End-to-end connections and reliability
·                 Network layer: Path determination and logical addressing
·                 Data link layer: Physical addressing
·                 Physical layer: Media, signal and binary transmission
Cheat Chart: TCP/IP reference model
TCP/IP reference model has four layers:
·                 Application
·                 Transport
·                 Internet
·                 Network Access
Cheat Chart: Data Units of OSI layers
·                 Application layer...........Data
·                 Presentation layer.........Data
·                 Session layer.................Data
·                 Transport layer..............Segment
·                 Network layer................Packet
·                 Data link layer...............Frame
·                 Physical layer................Bit
Chear Chart: Default Port Numbers
       Service            Port No.
·                 FTP     --------   20,21
·                 SSH    --------    22
·                 telnet   --------    23
·                 SMTP  --------   25
·                 DNS    --------    53
·                 DHCP --------    67,68
·                 TFTP   --------    69
·                 HTTP   --------    80
·                 POP3   --------   110
·                 NNTP   --------   119
·                 NTP      --------   123
·                 IMAP4  --------   143
·                 LDAP   --------   389
·                 HTTPS --------    443
·                 IMAPS --------    993
·                 RADIUS--------  1812
·                 AIM       --------     5190
Cheat Chart: Public IP address ranges
Every computer in the Internet has an IP address. There are five types of IP address. In the following table, you will find all the classes of IP address and the class name:
Class    Start address Finish Address
·                 A         0.0.0.0      127.255.255.255
·                 B      128.0.0.0      191.255.255.255
·                 C      192.0.0.0      223.255.255.255
·                 D      224.0.0.0      239.255.255.255
·                 E      240.0.0.0      255.255.255.255
Cheat chart: Default subnet mask
In the following section, you will see the default subnet mask of each class:
·                 For Class A: 255.0.0.0
·                 For Class B: 255.255.0.0
·                 For Class C: 255.255.255.0
Cheat Chart: Private IP address ranges
Public IP address is not so much. That's why the concept of private IP arises. In the following, you will find all the private IP address ranges of all classes.
·                 For Class A:      10.0.0.0 – 10.255.255.255
·                 For Class B:   172.16.0.0 – 172.31.255.255
·                 For Class C: 192.168.0.0 – 192.168.255.255
Cheat Chart: Host layers and media layers
·                 Host layers: The upper four layers are known as Host layers. The layers of host layers includes : Application layer, Presentation layer, Session layer and Transport layer.
·                 Media layers: The lower three layers are known as Media layers. The layers of media layers are : Network layer, Data link layer and Physical layer.
HSRP:
Hot Standby Routing Protocol, a proprietary protocol from Cisco. HSRP is a routing protocol that provides backup to a router in the event of failure. Using HSRP, several routers are connected to the same segment of an Ethernet, FDDI or token-ring network and work together to present the appearance of a single virtual router on the LAN. The routers share the same IP and MAC addresses, therefore in the event of failure of one router, the hosts on the LAN are able to continue forwarding packets to a consistent IP and MAC address. The process of transferring the routing responsibilities from one device to another is transparent to the user.
VRRP :
Virtual Router Redundancy Protocol, an election protocol that dynamically assigns responsibility for one or more virtual router(s) to the VRRP router(s) on a LAN, allowing several routers on a multiaccess link to utilize the same virtual IP address. A VRRP router is configured to run the VRRP protocol in conjunction with one or more other routers attached to a LAN. In a VRRP setup, one router is elected as the master router with the other routers acting as backups in case of the failure of the master route
Tips Tricks And Tutorials
Related Posts Plugin for WordPress, Blogger...

Labels

accounting (1) accounting software (1) acts (1) addon (1) advertising (1) advice (2) adwords (1) after meal (1) akshay kumar (1) Album (1) amazon (2) american (1) android (1) anti-virus (2) apple (4) apple apps (1) apple iphone (2) arcitura (1) article (16) articles (8) assistant (1) athletes (1) avoiding sales mistakes (1) awards (1) aws (1) basics (3) beauty (3) belly fat loss diet (1) benefits (1) best fat burner (1) best fat loss supplement (1) best fat loss supplements (1) best jobs (1) best paid jobs (1) best seo (1) best supplements for fat loss (1) best technology jobs (1) bidding (1) BMI Calculator (1) body language (1) bollywood (2) boss 2013 (1) brands (1) browser (2) browsers (1) business (13) business applications (1) business communications (2) business go green (1) business insurance (1) Business Intelligence (1) business security (1) business services (1) business with IT (1) cakes (1) cancer (1) cancer treatment (2) career (11) career guide (5) Certification (15) chemical wars (1) chemical weapons (1) chicken recipes (1) circket (1) circket match (2) circket match updates (1) cisco (1) claims (1) cloud (5) cma awards (1) cms (1) collaboration (1) commands (1) communication skills (1) compensation (1) competitions (1) competitive differentiation (1) Computer (8) connectivity (1) cooking (3) creating opportunities (1) creations (1) customer service (1) dangerous (1) data (1) data warehouse (1) database (3) decision making (1) decision making skills (1) demo (1) diet (3) diet programs (1) difference (2) differences (1) different storage engines (1) DNS (1) download (9) Dumps (5) Easy (1) easy solutions (1) eBooks (8) ecards (1) education (1) electric zoo (1) email (1) email writing (3) employment guide (3) Employment Strategies (1) english grammar (2) entertainment (4) erp applications (1) essential (1) events (1) exercises (2) experienced (1) facebook (3) family (3) family care (1) fashion (1) fast belly fat loss (1) fast food (1) fat (2) fat loss (3) fear of failure (1) features (1) festival (1) finance (4) finance software (1) firefox (2) fitness (1) flash drive (1) food (5) football (1) for women (1) freelance (1) freeware (2) french fries (1) frequently asked questions (1) freshers (1) fruits (1) funds (1) future (2) future plan (1) games (4) good keywords (1) google (1) google applications (1) google apps (1) grammar (3) great sales meetings (1) greetings (1) guide (10) hair growth (1) hairstyle (1) handling objections (1) handmade (1) handmade creations (1) handy (1) hardware (1) hd wallpapers (2) Health (19) health benefits (1) health care (19) Health Food (2) Health Insurance (3) health issue causes (1) Healthy Food (1) help (1) hidden secrets (1) high paid jobs (1) high paying jobs (1) high paying keywords (1) highest paying jobs (1) highlights (1) hollywood (3) home made food (1) home remedies (3) homemade (1) horror (1) how to (1) how to find a job (1) how to search a job (1) how to write (1) hr tips (1) importance (2) infogineering (1) infographic (2) information (3) information engineering (1) innovative business requirements (1) inspired (1) inspired women (1) inspiring stories (4) insurance (8) Insurance Agreement (1) insurance policy (1) internet (1) interview (3) interview answers (6) interview questions (6) Interview Tips (6) investment (2) investments (1) ipad (2) ipad air (1) iphone (2) ipl (2) ipl 2013 (1) ipod (1) job portal (1) job portals in australia (1) job portals in canada (1) job portals in india (1) job portals in singapore (1) job portals in uk (1) job portals in usa (1) job searching (1) jobs (9) jobs without degree (1) Johnny Manziel (1) journalist (1) keyboard shortcuts (1) keywords (1) knowledge base (4) knowledge processing (1) labor day (1) Laptop (2) law (2) Life (2) loans (1) loss your weight (1) make money online (1) making money (1) market (1) match highlights (1) Medical Claims (1) meetings (1) messenger (1) MI vs DD (1) microsoft (4) mobile applications (6) mobile erp (1) mobile erp solutions (1) mobile os (1) mobile settings (1) Mobile Stuff (12) mobile trends (1) models (1) money (3) most common answer (1) most common question (1) mothers day (2) motivational stories (2) movie (4) Music (2) mutual (1) mysql (1) Myths (2) natural (1) natural remedies (3) network diagnose (1) network scanning (1) Network Tools (4) network utilities (1) networking (5) networking jobs (1) new phones (1) news (5) nexus (2) office (2) olympic games (1) online accounting software (1) online broadcasting (1) online business (2) online communication (1) online fax (1) online job search engines (1) online jobs (1) online security (1) online selling (1) online updates (1) open source (2) Operating System (3) opportunity (1) organizing time (1) osi model (1) outsourcing (1) outsourcing sites (1) packet sniffing (1) pages (1) paging (1) pan am games (2) pc (1) performance (1) personality development (2) photo gallery (1) poems (1) Points to remember (1) Policy Agreement (1) popular technologies (1) power point presentations (1) product review (1) products (2) protection (1) Q and A (1) RAM (2) Rebecca Maddern (1) Recipes (8) relationship (2) remake movies (1) remedies (1) remote assistance (1) review (4) risk coverage (1) Samsung (1) Sarin Gas (1) save (1) savings (4) score board (1) score update (1) scripts (1) secret formula recipes (1) secrets (1) security (2) self development (1) self learning (2) sell products online (1) shah rukh khan (1) shortcut keys (1) shortcuts (3) Simulator (1) Simulator Software (2) skills (2) skills improvement (1) skin care (2) SLA (1) small applications (1) small business (2) smart devices (1) smart watch (1) social media (1) social networking (2) Software (14) solutions (1) songs (1) speed (3) sports (3) sports events (1) stars (1) stocks (1) stories (1) strengths (1) stress (1) style (1) talent (1) team leader (1) Tech Bytes (5) technical interview (1) Technologies (14) technology (1) technology in communication (1) tell me about yourself (1) test (1) throat infection (1) time (1) time killers (1) time management (1) tips (25) Tips and Tricks (39) tools (1) top jobs (1) trailer (5) treatment (1) troubleshooting (1) tutorials (11) tweaks (1) types of health insurance (1) uncategorized (2) updates (2) Utility Software (12) veg (1) vegetarian (1) vehicle (1) video demo (2) video tutorial (4) virtual assistant (1) virtual memory (1) wallpapers (4) weaknesses (1) web based (1) Web Designing (2) Web Development (3) webcast (1) webinar (1) weight lose (3) weight loss (1) what is (2) windows (3) work balancing (1) work management (1) wrinkle removers (1) yoga (2)