How To ?

Installing Python Package in offline System (Production System) : Mostly we have work  to work in production system , where there is no internet connectivity , so  question is this how we are going to  install package in offline system. so i am telling you my experience , how i have done it in steps  : Step 1: --  Off course you have to download package in from a internet , so how to do it ...     A :- Make a directory in desktop , where you want to download the package :     B:-  pip install pysftp --download="/home/usr/sfpt" Ex. I have downloaded  package for sftp : pysftp  , shown a  screen shot for your reference  :             so all dependence python will also be downloaded  .  as show in mentioned pic : Step 2: So now you are having  .whl file along pysft-0.2.9.tar.gz . .whl file are python   built-package format for Python. A   wheel   is a ZIP-format archive with a specially formatted filename and the .whl extension. It is de

Q -   What are prime and non prime attribute  ? Ans : Prime Attributes –   Attribute set that belongs to any candidate key are called Prime Attributes. If A is Candidate Key, and X→A, then, X is also Candidate Key .  Non Prime Attribute –  Attribute set does not belongs to any candidate key are called Non                  Prime  Attributes .  For Understanding   about Prime and Non Prime Attribute below are few example  . 

Q : How to add group then user in linux . ? Ans : 1: add group by using command groupadd 2: add a user into the group by   command  useradd  -G   . for adding a user in multiple group  just seperate user by  useradd -G , ,   3:  now add password to  user by command passwd 4:  ensure that user has been added to group use command id ,you will see information         of user id ,group id  . 5:  add a existing user to existing group           usermod -a -G         -a option is used for adding user in supplementry group . 6  :  adding user  to  a derive .         useradd  -d /directory               ->  this will add user to a directory .       Now come to  password        use command          password   7: how to install .Net  in RHEL 7 .  Ans  :  https://www.microsoft.com/net/core#redhat         8: how to delete a user      userdel --remove 9: how to stop ftp(21) in linux server .      iptables -A INPUT -p tcp --destination-port 21 -j DROP 10:  To check w

Q: what are different version of c# and their framework support  ? Ans : c#1.0 ,1.2,2.0,3.0,4.0,5. and 6.0 are different version of c# .  Frame work  - dot net version  .Net Framework 1.0  =  c#1.0  visual studio 2002  .Net Framework 1.1   = c#1.2 Visual studio 2003  .Net Framework 2.0  =  c# 2.0    = visual studio 2005  .Net Framework 2.0 ,3.0, 3.5   =  c#3.0 =  visual studio 2008 , visual studio 2010  .Net Framework 4.0  = c#4.0   visual studio 2010  .Net Framework 4.5  = c#5.0  = visual studio 2012, 2013  .Net Framework 4.6  = c#6.0  = visual studio 2015 Q : what are method in c# ? Ans : Method or function(will have return type) will be used  for writing a programme in more manageable way , syntax for methods  :  [attribute]   access-modifiers  return type  method name(parameter)    {       //body    } Method can be declare in two type  1 : Instance  2 : Static , for declaring  a method as static use keyword static in method e.g. public static void hello()

Installing MySql 5.6 in  My Linux Server RHEL6 , but problem was that there was no internet connectivity in server . so for installing  MySql need to download  three .rpm file , that you can download from any other   another internet connected pc  and put those rpm file in RHEL6 Machine . MySQL-server-5.6.16-1.el6.X86_64.rpm MySQL-client-5.6.16.el6.x84_64.rpm MySQL-embeded-5.6.16-1.el6.x86_64.rpm i have installed all three rpm by using command : rpm -ivh server   then  rpm -ivh embeded  then rpm - client . but when i started service ,service shows ,there is no mysql service available in ,so i tried to uninstall by using command rpm -ev .rpm file .......................................... but  it is showing rpm file is not installed . after searching from multiple troubleshoot ,i have found a solution to uninstall rpm file by using below mentioned command  : rpm -ev --nonscripts   make sure , remove .rpm extension from the file name for uninstalling the file .. after u

Hello  Friends ,In this topic  we will discuss about  administrator task  and few basic concept , how Resolve the basic problems in My Sql  . First You should know about variables or parameter  that are used by the MySql Application  because as load will be increase in database ,then you should know which parameter is going to be  change for smooth performance of mysql .. Q : how to check variable list in Mysql ? Ans :  Mysqladmin variables or   show variables  command in msysql cli . can be used to get the variable list  of msql . For example  Few Variable List :  have_innodb  for  checking inndob enable or not  have_isam    for indicates whether ISAM tables are available . key_buffer_size  : sets the size of buffer used for indexes shared among thread .  log  : indicate whether logging is enable for all queries or not . Q : What are support config file  used  in MySql  for defining  setting of msyql . Ans  : my-small.cnf ,my-medium.cnf , my-large.cnf , my-heavy.cnf  .  

Q : how to optimize select statement  ? Ans  : first check with permission set up when you issue with grant statement enables MySQL to reduce permission checking overhead when clients execute statement. example  : table or column level privileges , server need to check table_priv and columns_priv tables. if your problem with some specific MySQL expression or function , use BENCHMARK() function from mysql client  to perform timing test   . Syntax  : select benchmark(100000,1=1) ; result executed in some second . so bench mark is a great tool to find out any problem with query . Q : Difference between describe and explain  in MySQL ans : Describe keyword is used for table structure while explain is used to obtain query execution                plan .explain works on select ,delete ,insert ,update or replace. Q : how to analyze table ? Ans :   analyze table table_name ; Q : How to Optimize Table . Ans : optimize table command is equal to mysqlcheck -with --optimize opti

MySQL Storage Engines MySQL is very different from other databases, in that it's storage engine is pluggable, what I mean by this is that the MySQL server core code is separate from the storage engine, which means that you can have a pluggable storage engine that fits your application. MySQL has over 20 storage engines, here is a list of the common ones Storage Engine Transactional Support Locking Level Online Non-blocking Backup Server Version(s) available InnoDB (default) Yes Row Yes 5.1, 5.5, 5.6 MyISAM/Merge No Table No 5.1, 5.5, 5.6 Memory No Table No 5.1, 5.5, 5.6 Marta Yes Row No 5.1, 5.5, 5.6 Falcon Yes Row Yes 5.6 PBXT Yes Row Yes 5.1, 5.5, 5.6 FEDERATED No n/a n/a 5.1, 5.5, 5.6 NDB

Q : how to know Mysql Server is running on your Server . Ans : Just do telnet  localhost 3306 ; then press enter  , if blank window appear just after it ,means server is running other wise not before doing also check whether telnet is enable on your server or not . Q : how to connect a mysql server .   Ans:   Mysql -hlocalhost -uroot -p press enter  .then it will ask for password  ,enter your                    password  ,a prompt like  MySql  > will be shown means you are connected  . Q : how to create user in Mysql and providing privilege and checking for existing user      in mysql . Ans  :             "  create user 'username'@'localhost'  identified by password 'password' ."       if you want to give access to user that can access on network or remote user % sign in       place  of localhost . so command will look as below .                " create user 'username'@'%'  identified by password 'password&#

Question  :  Introduce Your self  ? Ans            : Normally first question starts with point  "Introduce Your self "  either guy is fresher or experience  , so if you are experience  then it is always good start telling from your career then academy  -- then personal achievement  and if it is necessary then family background . if you are fresher , start with academy ,and then some personnel achievement , and try to correlate how you personal achievement with  your current job  interview . Q  :  What is PL/SQL .   ? Ans   : PL/SQL  stands for procedure  programming language for structured query language . Q : Why PL/SQL is needed  ?  Ans  : Normal sql is having some limitation  to work with database , you can not do much more in       in single line query  .. , in this case p/sql is always beneficial  in terms of  you can multi line query  as method or function , you can create a package  , triggers ,cursors , overall in one word ,you can manage your code