Skip to main content

Posts

EXAM PATTERN for the upcoming CCC exam?

      EXAM PATTERN  for the upcoming CCC exam?     • The examination conducted will be in objective form. • There will be 100 questions and time given will be 90minutes so the candidates have 90 minutes to solve multiple choice questions. • The result will not come in the form of marks it will in grades and certificate will be given to the candidates scoring minimum 50%. • This exam is done every month so no qualification is needed. • Candidates will have to go through the online tests this will actually help the housewives and the person who wants some basic knowledge.        
Post a Comment
Read more
Recent posts

How to remove shortcut virus from USB drive ?

How to  remove shortcut  virus from USB drive ? Press win+R it will open run window       Enter cmd and press ok. In command window type attrib and hit enter. Now type “attrib -h -r -s /s /d e:\*.*” and hit enter (Remove e:\ with sutaible USB Drive Level) After successfully run the script you will get following windows 
Post a Comment
Read more

How to view MYSQL Users with their Privileges

  To Find list of users and permission granted them in MYSQL run following command :          select user,host from MySQL.user; Here (i) host component tells on which host they are connecting from.          (ii)%  is a wild card character interprets as 'any ' host. To find the privilege(s) granted to a particular MySQL account: --> show grants for 'super'@'%';  Here super is user name and host name user concatenated by @ .
Post a Comment
Read more

How to Grant Privilages to an account in MYSQL

MYSQL 'GRANT' statement allows you to grant access privileges to database account. To achieve same ,syntax  is as follow: Syntax:- GRANT privileges [Column_List] ON  [Object_Type] Privilege_level To account [IDENTIFIED BY 'password'] [ REQUIRE encryption ] WITH with_option ; Detailed explanation: Privileges:- It indicates that you have assign privileges to account. column_List : - (1) Its  optional.                          (2) Column(s) to which privileges apply. Privileges_level :- Level at which privileges apply. You can use global  privileges,database privileges,table specific privileges, column privileges etc. Account :- Which  account is being granted privileges. Password: - Specifies password.It replace old password. Required:- Clause specify whether the account has to connect to database server over secure connec...
Post a Comment
Read more

MYSQL Administration

Crating New User in MYSQL: Syntax:  Create user <UserName@localhost> Idendified By  '<paswword>'; Eg.: Create user dbadmin@localhost Identified By 'dbadmin' ;
Post a Comment
Read more

Introduction of database concept

 A collection of data is referred to as database and a database (management) system is  basically a computer based record keeping system.  It maintains any information that may be necessary to the decision-making processes involved  in the management of the organization.  The intention of a database is that the same collection of data should serve as many       applications as possible.  Database would permit not only the retrieval of data but also continuous modification of data needed for control of operations.  It may be possible to search the database to obtain answers to queries or information for planning purpose.  
Post a Comment
Read more