Category Archives: Career

Jewellery Design Career – How to make career in Jewellery Making?


Jewellery Design Career – How to make career in Jewellery Making?

On the rear of a sizzling growth of the jewelry trade, putting job openings and exciting entry-level salaries, several specialised institutes have mushroomed within the recent past. It is a fine era to contemplate Jewellery design as a career preference. Bharat is the largest gems and jewelry market within the world (the domestic market is Rs 63,000 crore), however mostly within the unorganised sector with a major target gold. With the entry of massive players like Tanishq, Swarovski, DeBeers, D’- damas, the shifting thrust on gems and stones instead of pure gold is giving a giant push to the union gems and jewelry trade. Your grandma’s recent jewelry is also loved and dear heirlooms, however they merely don’t hold a candle to the present designs being worn. jewelry lately is exclusive and up to date. “People are terribly image cognizant. They don’t want jewellery as a representation of financial security but to make a fashion statement and also as trends wear that suits different occasions.”

jewellery design

Getting started.

Previously, the single way to learn this skill was to be an apprentice to an experienced jeweler. But these days, one can take up a diploma course in jewellery design after school. Numerous institutes, all over India, present diploma courses in jewellery designing. A student has to pass an aptitude test and interview before qualifying for the course. One could be from any field. But an art background does help in the long run. The course gives you essential information on the diverse kinds of stones, colour schemes in jewellery, design themes, presentation and framing, designing individual jewellery pieces, men’s jewellery, costume jewellery, jewellery costing, etc. But to a professional in designing jewellery does not need formal training. A professional in any other field can take up jewellery designing workshops and set up a business production house.

What it takes..?

There ar no specific temperament traits for jewelry designers. One will learn everything whereas obtaining trained. However, you only want a passion for the profession; otherwise there’s no approach one will learn.
A sense of style is imperative. exactness and a focus to detail are equally necessary for a prosperous jeweller. One ought to be terribly artistic, ingenious and technically sound.
It’s also necessary to own a operating data regarding producing.
One ought to be well-versed with the style trade on the international front too.

The job.

Jewellery designers prepare sketches – by hand or on the PC – to create by mental act the planning. once consulting with the client or the producing team, designers fashion detail drawings, a structural model, PC simulations, or a complete paradigm.
Computer models enable superior easiness and adaptability in exploring variety of style alternatives, therefore reducing style prices and cutting the time it takes to deliver a product to promote.
Designs are created on regular or floral patterns and so generate forms by connecting completely different structures along. The vary of raw materials is complete – from economical and simply on the market stuff like paper, wood, terracotta, jute, to extremely priced Swarovski crystals!

Opportunities. One will add any of the subsequent sectors:

  • Jewellery planning house
  • Export house
  • Fashion house
  • Self-employment


Freelance planning

If you be a part of Associate in Nursing export house, you’ll see your new styles within the international market. Most of the scholars begin their own business by putting in place a production house. As a contract styleer your job is to draw a design in step with the specifications of the jewelers’ house. you furthermore may ought to direct the manufacturing of the jewellery by the craftsman of the jewellery house.

Where to study..?

  • NIFT Campus, opposite Gulmohar Park, Hauz Khas, New Delhi.
  • Srimati Nathibai Damodar Training (SNDT) Women’s University, Mumbai.
  • Gem and Jewellery Export Promotion Council, Rajasthan Bhavan, Jaipur.
  • Jewellery Export Promotion Council, D-15 Commerce Centre, Tardeo, Mumbai.
  • Indian Institute of Jewellery, Modern Centre, 101, Sane Guruji Marg, Mahalaxmi, Mumbai.
  • Jewellery Design and Technology Institute (JDTI), Noida.
  • South Delhi Polytechnic for Women, Lajpat Nagar IV, New Delhi.
  • St. Xavier’s College, Geology Department, Mumbai.
  • Small Industries Service Institute, Chennai.

If you are interested in reading more articles like SQL Interview Questions, then please visit Career Guidance section.

Tourism Management Career – Travel Jobs


With the recent developments in transportation and communication, traveling, each domestically and internationally has return to be simple. whether or not your purpose of traveling is business, journey or simply a vacation, an oversized cluster of individuals happiness to the Travel and business enterprise business square measure there to form your expertise bother free. This business is that the largest exchange wage earner and it provides employment to innumerable individuals. thus the business includes a range of career choices to supply and therefore the scope of employment is limitless. Tourism Management Career offers employment opportunities exist in each the general public and therefore the personal sector during this business. within the public sector, you’ll be able to add the Directorates and Departments of business enterprise of the middle and therefore the state, guides etc. within the personal sector, on the opposite hand you’ll be able to secure employment in an exceedingly agency, hotel, airline, transport agency or a wares company. Since this business could be a comparatively new one, there don’t seem to be an enormous range of intimate with people. Hence, you’ll be able to move up the ladder quick and establish your own agency once many years.

Tourism Management

The Career choices – Tourism Management

Travel Agencies:

These establishments facilitate travel and different services for all people traveling for vacations or business functions. Providing data regarding the destination, edifice ratings, the most cost effective and therefore the quickest mode of transport, visas, exchange etc. is the job of a travel agent. Travel agencies are divided into roughly four departments- the Accounts, Tours, Travel and Cargo. A course in travel and tourism management will help you to get a suitable job.

Tourism Department:

This department consists of reservation and counter staff, sales and marketing staff, tour planners, tour guides, information assistants and officers in the Directorate and Department of tourism. These officers for the Directorate and Department of tourism are chosen from the civil services and their job is to promote and plan tourism. Information assistants provide knowledge concerning destinations and plan itenaries. They are selected through a competitive exam which is held by the Staff Selection Commission. Guides too are divided into three categories namely regional, state and local. In order to be a guide, you must have knowledge about history, art, architecture and language.

Hotels:

Hotels provide travelers with food and accomadation services. This service industry requires skilled and professional individuals and it’s manpower requirements are vast. Jobs related to front office, operations, house keeping, food and beverages, accounting, management and public relations are available. A course in hotel management would help you to get a suitable job.

Transport:

Transport refers to means of traveling from one place to another. Air, railways, road and sea are the basic categories that transport is divided into.

Road transport:

Coaches and tourist cars provide scope for self employment. Drivers with good conversation skills and knowledge of different languages are ideal for this job.

Airlines:

This sector of the travel and tourism management industry is in great demand. The ground staff and the airlines need smart and presentable professionals with a degree in hotel management or travel and tourism. Traffic assistants, reservation and counter staff, air hostess & flight pursuers, sales and marketing staff and people to provide customer services are all required. Airlines like Indian Airlines, Emirates, British Airways and Air Republic of India pay engaging salaries and give a range of superimposed advantages too. Tour operators: These people organize tours and manage travel and keep of their shoppers. They conduct tours to best-known tourist attractions and a few of them facilitate the tourists from journey sports like stream rafting and climbing. to try to to this job, you’ve got to possess a nice temperament, elaborated information regarding travel and language skills.

Time share firms:

These firms own/manage vacation resorts with time shares closely-held by totally different members of those companies. It ends up in another set of firms which give services about sale/transfer/exchange of those time shares with a global network of resorts. you’ve got the choice of operating with resort owning firms or time share exchange firms like RCI. vacation consultants: this can be a comparatively new career possibility within the travel and business enterprise business. These professionals give all the knowledge to their shoppers. They sell the vacation, set up the itenary, build the itinerary, book the tickets and supply all the opposite details that square measure needed. Banks: Banks need individuals to help tourists and travelers on exchange. typically MBA professionals square measure most popular for this job. Banks facilitate in edifice and price ticket bookings additionally.

If you are interested in reading more articles like SQL Interview Questions, then please visit Career Guidance section.

Fashion Designing Career – Fashion Designing Course


Career in Fashion Designing – Fashion Designing Course

Fashion Designing Career has got into lot of demand worldwide. The term ‘fashion’ forthwith conjures up pictures of tawdriness and glamour. and lots of youngsters, attracted by these attributes attempt to intrude on fashion solely to understand that what they see outside isn’t the within story. Admittedly, there are some glamourous aspects to the current business. As a part of the fash fraternity (fashion fraternity for the uninformed), you’ll get to rub shoulders with the made and notable, however reaching there’s sheer diligence.

fashion designing

The Fashion style may be divided into 3 main branches — Garment style, animal skin style, accent & jewelry style.

Here we’ll specialize in Garment style. While the old chestnut “clothes make the man” deserves discussion, the very fact is we have a tendency to not wear garments to stay ourselves coated or heat, however to specific our temperament and “attitude”. this is often wherever the style designer steps in, to assist United States of America create the proper fashion statement. making a method, exploitation the correct material, the correct cut and a decent end, the designer seems either a singular creation (one of its kind) that will sell for a king’s ransom, or additional typically, outfits that may reach a retail outlet in several sizes and colors. In bound cases, the garment could even be factory-made for a particular market.

Garments embrace things of normal vesture, usually western vogue, though there’s a growing native marketplace for Indian vogue designer wear like salwar-kameez, sherwanis, ghagra-cholis, kurtis so on.

There area four fashion designing courses of action that you just will adopt to begin the career of your dreams:

  • Lawyers in camera observe typically work for long and irregular hours meeting shoppers,
  • researching and reading concerning new
  • Apprenticeship under a flourishing, well-known designer.
  • Employment in an export house or garment manufacturing unit.

Freelancing for fashion houses and boutiques.

Self-employment, as in opening your boutique or manufacturing unit or an export outfit to showcase your talent.

Nothing will compare with absolutely the joy once your creation is loved and appreciated for its vogue and end. and therefore the high-voltage message and clapping as you proceed for the bow at the top of a surprising show won’t hurt either. Nowadays fashion designers share equal area on Page three as models and film stars. What it takes? A question typically asked by youngsters is whether or not they really want to be trained to be a designer. Most youngsters are able to sketch well  and have an interest in fashion believe their talent and interest already qualifies them for the style trade. however fashion style isn’t almost about sketching pretty garments. blackball a couple of exceptions wherever talent borders on genius, it’s definitely suggested that you just pursue a course in fashion style. And you’ll be able to do therefore straight when college. There area unit a range of courses accessible to suit completely different desires and budgets.While the educational necessities don’t seem to be terribly high, you wish extended power and talent to be tagged “designer” material. you want to be extremely artistic to mix colors, shades and textures, and specific your concepts through sketches. If you’ll be able to visualise styles and revel in operating with materials and accessories you’re watching the correct career. beside fashion consciousness and creativeness, you furthermore may want wonderful communication skills to articulate your concepts and perceive the client’s necessities. information of the market and a decent eye for detail area unit the opposite must-haves.Beware although fashion is the maximum amount concerning technique as concerning vogue. you wish to be clued in on producing technology, time and motion studies, plant potency, labour motivation, zero-defect production — all area unit extraordinarily relevant to the current trade. Before you become a reputation to reckon with, be ready to place in loads of diligence and running around. However, fashion style is simply one among the numerous careers that a student of fashion style prepares for. There area unit variety of others like selling and mercantilism, fashion co-ordination, fashion journalism, etc.

Employment Opportunities

In Asian country, the style trade has simply begun to come back older. Because it remains in its fledgling stage, it offers lots of opportunities for overenthusiastic, proficient and exhausting operating kids. Prospects for fashion style graduates area unit pretty smart due to the {large|the massive} and still growing demand for “designer wear” and therefore the equally large volume of exports. What with the sheer selection and handiness of materials – from ancient silks and ikats to jamawars and handlooms in vivacious weaves and dyes – Asian country may be a fashion designer’s dream.Until a couple of years past, there wasn’t one Indian name within the international fashion scene. but with the institution of NIFT and a few alternative fashion colleges, a band of precocious designers is already creating its mark on the style surface. nowadays names like Ritu Kumar, Ritu Beri, Rohit Bal, Sunit Verma, JJ Vallaya and Tarun Tahiliani have just about become home names – what with the media showcasing their talent across double-page spreads in shiny magazines and varied fashion-related programmes on TV.What you’ll make?The fancy salaries and therefore the promotion that you just examine within the glossies is just for those that area unit extremely proficient to start with or those passing out of the premier institutes. For the remainder, finding a good toehold may be pretty robust. conjointly considering the very fact that almost about most are dashing into fashion planning, it should be knowing want a number of the opposite courses like mercantilism, accent planning, Garment producing Technology, etc., all of that have a element of fashion style in them.Having same that, the money is pretty smart.

If you are interested in reading more articles like Fashion Designing Career guidance, then please visit Career Guidance section.

How to get a Public Relations Job


In the last decade, public relations job (PR) has gained quality and importance. The speed of communication and therefore the unclear amendment and progress in varied fields has resulted within the rise of PR as a profession. PR encompasses a key role to play in informing the general public concerning a corporation and changing cognitive content into information and understanding. Generating public interest and turning hostility into acceptance in some cases is additionally the work of a PR manager. PR analyzes the consequences of structure policies and therefore the reactions of the general public. the general public could be a important a part of a corporation and is crucial for its survival and success.

public relations job

The basic elements of Public Relations Job embody the following:

Counseling:

This involves providing recommendation to management regarding policies, relationships and communications.Research: determinant attitudes and behaviors of the general public so as to set up public methods.Media Relations: operating with mass media in seeking substance or responding to their interests within the organization.

Publicity:

disseminative planned messages through chosen media to market the organization’s interests.Employee/Member Relations: Responding to issues, informing, associated motivating an organization’s workers or members.Community Relations: Planned activity with a community to take care of associate atmosphere that advantages each the organization and therefore the community.

Public Affairs:

Developing effective involvement publically policy and serving to a corporation adapt to public expectations. The term is additionally employed by government agencies to explain their packaging activities associated by several companies as an umbrella term to explain multiple packaging activities.

Government Affairs:

Relating directly with legislatures and restrictive agencies on behalf of the organization. Lobbying is a locality of the govt. affairs program. problems Management: distinguishing and addressing problems with public concern that have an effect on the organization.

Financial Relations:

Making and maintaining capitalist confidence and building smart relationships with the monetary community. conjointly called capitalist Relations or stockholder Relations. trade Relations: Relating with alternative companies within the trade of a corporation and with trade associations.

Development/Fund-Raising:

Demonstrating the necessity for development and inspiring the general public to support a corporation, primarily through monetary contributions. Special Events: Stimulating associate interest in a very person, product or organization by means that of a centered “happening”; conjointly, activities designed to move with publics and hear them.

Selling Communications:

Combination of activities designed to sell a product, service, or idea, together with advertising, collateral materials, publicity, promotion, spam, trade shows and special events.

The Work

If you intend on coming into this field, public relations job provides you with a large vary of labor opportunities.

Corporations:

you’ll work for departments UN agency look for to safeguard and enhance a company’s name. Providing info to the general public similarly on special audiences like stockholders, monetary analysts and workers would be a locality of your job.Non-profit organizations: Trade and environmental organizations, social and cultural teams, hospitals and health agencies conjointly supply jobs to PR professionals. the work typically involves fund-raising.

Diversion, Sports and Travel:

Practitioners in these measures are typically involved with substance for people and promotion of events starting from soccer games to motion photos.

Government and therefore the military:

This space includes promotion of political problems, generally through lobbying, work with politicians, dissemination of knowledge concerning government activities to voters, and distribution of knowledge concerning the defense force. Education: At the faculty level, you’d primarily work with alumni, college and administration, students, and therefore the public to market the school’s image, recruit students and lift fund. Secondary colleges typically have specialists to handle community relations. International public relations: The huge growth of virtually instant international communications has opened associate intriguing new space, particularly for practitioners with language skills and familiarity with alternative cultures.

Personal Attributes

Ability with words, analytical talent, inventive ability, associate instinct for persuasion and therefore the ability to form compelling and polished shows square measure essential needs if you’re trying to become a PR skilled. sense, fabulous organizing ability, smart judgement, judgment, creativity, flexibility and therefore the temperament to figure long and inconvenient hours also are vital attributes that you simply should posses.

Salary

Over the years, the standing of public relations job professionals has modified and evolved. to stay pace with changes, businesses and journalists have begun to place confidence in PR professionals.

If you are interested in reading more articles like SQL Interview Questions, then please visit Career Guidance section.

Linux Interview Questions – Linux Application Programming Questions


Linux Application Programming Questions – Linux Interview Questions

In this article on Linux Interview Questions, we have tried to list down Linux Application Programming Questions and Answers.

linux interview questions

Explain the distinction between a static library and a dynamic library?

– Static library is joined into the feasible, whereas a dynamic library (or shared object) is loaded at the time when executable is loaded.

How does one produce a static library?

– If you’ve got a collection of object (.o) files, one can do it by executing ar command. Usually a static library contains a .a extension, one can link it into an executable by providing -l libraryname to gcc.

Where should the developed libraries be put in on the system?

– it is recommended to use /usr/local/bin for binaries and /usr/local/lib for libraries.

What’s LD_LIBRARY_PATH?

– It’s an environment variable to list all the directories that should be searches for libraries before the standard directories are searched.

How does one produce a shared library?

– first one should create the object file with -fPIC for position-independent code, then run gcc with -shared option.

How does one install a shared library?

– Run ldconfig within the standard directory that it’s put in in.

What will ldd do?

– It shows a listing of already installed shared libraries.

How does one dynamically load a library in your app?

– Use dlopen()

What will nm command do?

– It reports the list of symbols in an exceedingly given library.

If you are interested in reading more articles like SQL Interview Questions, then please visit Career Guidance section.

Asp Net Interview Questions


Asp Net Interview Questions and Answers

Want to clear ASP.NET interview then please refer following ASP Net Interview Questions and Answers.

asp net interview questions

Question:-What does one mean by Share purpose Portal ?
Answer: Here I actually have taken data relating to Share purpose Portal Server 2003 provides in the main access to the crucial business data and applications.With the assistance of Share purpose Server we are able to server data between Public Folders, Data Bases, File Servers and also the websites that ar supported Windows server 2003. This Share purpose Portal is integrated with MSAccess and Windows servers,So we are able to get a large vary of document management practicality. we are able to additionally produce a full featured portal with readymade navigation and structure.

Question:-What is cross page posting in ASP.NET2.0 ?
Answer: we tend to|once we|after we} got to post information from one page to a different in application we used server.transfer methodology however during this the address remains identical however in cross page posting there’s very little totally different there’s traditional post back is completed however in target page we are able to access values of server management within the supply page.This is quite straightforward we’ve got to solely set the PostBackUrl property of Button,LinkButton or imagebutton that specifies the target page.In target page we are able to access the PreviousPage property.And we got to use the @PreviousPageType directive.We can access management of PreviousPage by exploitation the findcontrol methodology.When we set the PostBackURL property ASP.NET framework bind the hypertext markup language and Javascript operate mechanically.

If you are interested in reading more articles like ASP Net Interview Questions, then please visit Career Guidance section for more career guidance and interview questions and answers on different technologies. This list of questions and answers is evolving, so please keep visiting this section every now and then.

SQL Interview Questions – MS SQL Server Interview Q&A


SQL Interview Questions and Answers

Looking out for SQL interview questions and answers to clear SQL Server interview with ease and confidence.

sql interview questions

SQL Interview Questions – What is normalization?

– Well a database is largely composed of tables that contain connected data. that the method of organizing this information into tables is truly brought up as normalisation.

SQL Interview Questions – What is a keep Procedure?

– Its nothing however a collection of T-SQL statements combined to perform one task of many tasks. Its primarily sort of a Macro thus once you invoke the keep procedure, you really run a collection of statements.

SQL Interview Questions – Can you offer associate example of keep Procedure?

– sp_helpdb , sp_who2, sp_renamedb square measure a collection of system outlined keep procedures. we are able to even have user outlined keep procedures which may be referred to as in similar means.

What is a trigger?

– Triggers square measure primarily wont to implement business rules. Triggers is additionally like keep procedures. The distinction is that it are often activated once information is other or emended or deleted from a table during a info.

What is a view?

– If we’ve many tables during a dB and that we need to look at solely specific columns from specific tables we are able to select views. it might additionally answer the requirements of security some times permitting specfic users to visualize solely specific columns supported the permission that we are able to tack together on the read. Views also reduce the effort that is required for writing queries to access specific columns every time.

SQL Interview Questions – What is an Index?

– When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much faster when we have an index.

What are the types of indexes available with SQL Server?

– There are basically two types of indexes that we use with the SQL Server. Clustered and the Non-Clustered.

What is the basic difference between clustered and a non-clustered index?

– The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

What are cursors?

– Well cursors help us to do an operation on a set of data that we retreive by commands such as Select columns from table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retreival one by one and remove rows which have duplicate values.

When do we use the UPDATE_STATISTICS command?

– This command is basically used when we do a large processing of data. If we do a large amount of deletions any modification or Bulk Copy into the tables, we need to basically update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

Which TCP/IP port does SQL Server run on?

– SQL Server runs on port 1433 but we can also change it for better security.

From where can you change the default port?

– From the Network Utility TCP/IP properties < Port number. both on client and the server.

Can you tell me the difference between DELETE & TRUNCATE commands?

– Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

– No. We cannot use Truncate command on a table with Foreign Key because of referential integrity.

What is the use of DBCC commands?

– DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.

Can you give me some DBCC command options?(Database consistency check)

– DBCC CHECKDB – Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC – To check that all pages in a db are correctly allocated. DBCC SQLPERF – It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP – Checks all tables file group for any damage.
What command do we use to rename a db? – sp_renamedb ‘oldname’ , ‘newname’
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases? – In such cases we can first bring to db to single user using sp_dboptions and then we can rename that db and then we can rerun the sp_dboptions command to remove the single user mode.

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

– Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

What do you mean by COLLATION?

– Collation is basically the sort order. There are three types of sort order Dictionary case sensitive, Dictonary – case insensitive and Binary.

What is a Join in SQL Server?

– Join actually puts data from two or more tables into a single result set.

Can you explain the types of Joins that we can have with Sql Server?

– There are three types of joins: Inner Join, Outer Join, Cross Join
When do you use SQL Profiler? – SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs etc..

What is a Linked Server?

– Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements.

Can you link only other SQL Servers or any database servers such as Oracle?

– We can link any server provided we have the OLE-DB provider from Microsoft to allow a link. For Oracle we have a OLE-DB provider for oracle that microsoft provides to add it as a linked server to the sql server group.

Which stored procedure will you be running to add a linked server?

– sp_addlinkedserver, sp_addlinkedsrvlogin
What are the OS services that the SQL Server installation adds? – MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator)

Can you explain the role of each service?

– SQL SERVER – is for running the databases SQL AGENT – is for automation such as Jobs, DB Maintanance, Backups DTC – Is for linking and connecting to other SQL Servers

How do you troubleshoot SQL Server if its running very slow?

– First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to ascertain for the users and current SQL activities and jobs running which could be a retardant. Third would be to run UPDATE_STATISTICS command to update the indexes

Lets say because of N/W or Security problems consumer isn’t ready to hook up with server or contrariwise. how does one troubleshoot?

– 1st i’ll look to confirm that port settings square measure correct on server and consumer Network utility for connections. ODBC is correctly organized at consumer finish for association

——Makepipe & readpipe square measure utilities to ascertain for association. Makepipe is run on Server and readpipe on consumer to ascertain for any association problems.

What square measure the authentication modes in SQL Server?

– Windows mode and mixed mode (SQL &amp; Windows).

Where does one assume the users names and passwords are going to be keep in sql server?

– They get keep in master dB within the sysxlogins table.

What is log shipping? will we have a tendency to do logshipping with SQL Server 7+.

– Logshipping may be a new feature of SQL Server 2000. we must always have 2 SQL Server – Enterprise Editions. From Enterprise Manager we are able to tack together the logshipping. In logshipping the transactional log file from one server is mechanically updated into the backup info on the opposite server. If one server fails, the opposite server can have constant dB and that we will use this because the DR (disaster recovery) set up.

Let us say the SQL Server crashed and you’re reconstruction the infos as well as the master database what procedure to you follow?

– For restoring the master dB we’ve to prevent the SQL Server 1st so from program line we are able to kind SQLSERVER –m which can primarily bring it into the upkeep mode when that we are able to restore the master dB.

Let us say master dB itself has no backup. currently you have got to reconstruct the dB thus what quite action does one take?

– (I am not sure- however i feel we’ve a command to try and do it).

SQL Interview Questions – What is BCP? once will we use it?

– BulkCopy may be a tool wont to copy immense quantity of information from tables and views. however it won’t copy the structures of constant.

What ought to we have a tendency to do to repeat the tables, schema and views from one SQL Server to another?

– we’ve to put in writing some psychosis packages for it.

If you are interested in reading more articles like SQL Interview Questions, then please visit Career Guidance section.

System Development Life Cycle (SDLC) Model


SDLC is also called as Classic Life Cycle Model (or) Linear consecutive Model (or) Waterfall methodology.

This model has the subsequent activities:

1. System/Information Engineering and Modeling

As software system is often of an outsized system (or business), work begins by establishing the needs for all system parts then allocating some set of those requirements to software system. This technique read of SDLC is crucial once the software system should interface with alternative parts like hardware, individuals and alternative resources. System is that the basic and extremely essential demand for the existence of software system in any entity. Therefore if the system is not in place, the system ought to be designed and put in place. In some cases, to extract the utmost output, the system ought to be re-engineered and clothed . Once the perfect system is designed or tuned, the event team studies the software system demand for the system.

2. Software System Demand Analysis

This method is additionally called feasibleness study of SDLC. during this section, the event team visits the client and studies their system. They investigate the requirement for potential software system automation within the given system. By the tip of the feasibleness study, the team furnishes a document that holds the various specific recommendations for the candidate system. It additionally includes the personnel assignments, costs, project schedule, target dates etc…. the necessity gathering method is intense and focussed specially on software system. to know the character of the program(s) to be engineered, the system engineer or “Analyst” should perceive the knowledge domain for the software system, likewise as needed operate, behavior, performance and interfacing. The essential purpose of this section is to seek out the requirement and to outline the matter that has to be resolved .

SDLC
3. System Analysis and Style

In this section, the software system development method, the software’s overall structure and its nuances area unit outlined. In terms of the client/server technology, the amount of tiers required for the package design, the info style, the info structure style etc… area unit all outlined during this section. A software system development model is so created. Analysis and style area unit terribly crucial within the whole development cycle. Any defect within the style section can be terribly dear to unravel within the later stage of the software system development. a lot of care is taken throughout this section. The system of rules of the merchandise is developed during this phase.

4. Code Generation

The design should be translated into a machine-readable kind. The code generation step performs this task. If the planning is performed during a elaborate manner, code generation will be accomplished while not a lot of complication. Programming tools like compilers, interpreters, debuggers etc… area unit wont to generate the code. totally different high level programming languages like C, C++, Pascal, Java area unit used for cryptography. With reference to the kind of application, the correct artificial language is chosen.

5. Testing

Once the code is generated, the software system program testing phase of SDLC begins. totally different testing methodologies area unit obtainable to unravel the bugs that were committed throughout the previous phases. totally different testing tools and methodologies area unit already obtainable. Some corporations build their own testing tools that area unit tailor created for his or her own development operations.

6. Maintenance

The software system will certainly endure modification once it’s delivered to the client. There will be several reasons for this alteration to occur. modification might happen due to some sudden input values into the system. additionally, the changes within the system might directly have an effect on the software system operations. The software system ought to be developed to accommodate changes that would happen throughout the post implementation amount.

For more project management related information, visit Project Management Articles