FirstRanker.com

Search results for: “ic”

  • How To Decode A Job Posting

    Jerome Young, Forbes.com

    During your job search you will review hundreds of job postings. Some will be very well written and provide quality information, while others will tell you little about the employer’s needs. The majority of them have a similar format and characteristics, and they provide insight into what the employer wants–if you know what to look for.

    As the founder of AttractJobsNOW.com, I have conducted extensive research on the job market and the recruiting process employers use to find and choose candidates to fill open requisitions. In the process I’ve learned a lot about what you can divine from a simple job posting.

    In Pictures: The Industries Where Jobs Are Growing Most

    In Pictures: The Companies Hiring The Most Right Now

    In Pictures: The Companies Hiring The Most Right Now

    In Pictures: The Companies Hiring The Most Right Now

    Full List: Companies Hiring The Most Right Now

    Postings can be written by a hiring manager or a recruiter, but it’s usually the recruiter who receives and screens the applications. With this in mind you should be sure that your r?sum? will make a recruiter feel confident that you are qualified. By making the most of the insight you can glean from the following three sections of a typical job posting, you can better position yourself to impress recruiters and get interviews:

    The job title: Every job posting includes a job title. It is often what first piques your interest in the posting, and it’s the first thing the hiring manager thought of when he or she decided to create the position. Most job seekers overlook the intelligence the job title provides and suffer for it. The job title gives you the most likely keywords that will be used to find qualified candidates for the job, and because of that you can use it to your advantage.

    At AttractJobsNOW.com we use the job title as our guide in creating effective customized r?sum?s by ensuring that each candidate’s summary statement and areas of expertise are in line with the job title. We ensure that the words in the job title appear prominently throughout the r?sum?, so that our clients will appear at the top of candidate searches. As a result, more than 95% of our candidates succeed in getting job interviews at their companies of interest.

    Responsibilities: The responsibilities section describes what will be expected of the employee in the position. You’ll often find that there are five to 10 bullet points in this section, but in our research with recruiters and hiring managers we’ve found that the first three responsibilities are the most important. Job postings are usually based on a primary business need to which additional responsibilities are added to create a full-time position. Your r?sum? should focus on your experience, results and accomplishments in the tasks outlined in the first three bullets in the responsibilities section. Also you’ll find keywords in those first three bullets that recruiters will use in searching for qualified candidates.

    Qualifications: The qualifications section provides insight into the experience, skills and education the hiring manager has in mind for the person they feel will be capable of excelling in the role. As in the responsibilities section, the first three qualifications are usually the most important. If you meet those top three qualifications, you should directly say so in the summary section at the top of your r?sum?, to instantly inform the hirer that you’re qualified and to persuade them to read the rest of your r?sum?. If you don’t meet the top three qualifications but have others strengths that qualify you to excel, definitely mention them in your summary section.

    Taking the time to analyze job postings and customize your r?sum? based on their job titles, responsibilities and qualifications is often the difference between receiving interviews and being screened out of the recruiting process.

    Jerome Young is the founder and president of AttractJobsNOW.com, a job search and recruiting consulting firm.

  • Anna University B.E/B.Tech CSE – Cs 1301 – Database Mmanagement Systems (DBMS) Question paper

    QUESTION PAPER CODE: C 3203
    B.E./B.TECH. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2008
    FIFTH SEMESTER
    COMPUTER SCIENCE AND ENGINEERING
    CS 1301 — DATABASE MANAGEMENT SYSTEMS
    (COMMON TO B.E.(PART-TIME)FOURTH SEMESTER REGULATION 2005) (REGULATION 2004)
    TIME: THREE HOURS MAXIMUM: 100 MARKS

    ANSWER ALL QUESTIONS.

    PART A — (10*2=20 MARKS)

    1. What is Database management system? Why do we need DBMS?

    2. What are the three characteristics of a Relational Database system?

    3. State the differences between security and integrity.

    4. What is decomposition and how does it address redundancy?

    5. What us a heap file? How are pages organized in a heap file?

    6. How does a B-tree differ from a B+ – tree? Why is a B+ – tree usually preferred as an access structure to a data file?

    7. Give the meaning of the expression ACID transition.

    8. When are two schedules conflict equivalent?

    9. Define the terms fragmentation and replication, in terms of where data is stored.

    10. What are structured data types? What are collection types, in particular?

    PART B –(5*16=80 MARKS)

    11(a) (i) Explain the component modules of a DBMS and their interactions with the architecture.[10]

    (ii) Construct an ER diagram to a model online book store.[6]

    Or

    (b) (i) Explain the basic Relational Algebra operations with the symbol used and an example for each.[10]
    (ii) Discuss about Tuple Relational calculus and Domain Relational Calculus.[6]

    12 (a) (i) Write short notes on the following:[10]

    Data Manipulation Language (DML)

    Data Definition Language (DDL)

    Transaction Control Statements (TCS)

    Data Control Language (DCL)

    Data Administration Statements (DAS).

    (ii) Consider the database given by the following schemas:[6]

    Customer(Cust_No,Sales_Person_No,City)

    Sales_Person(Sales_Person_No,Sales_Person_Name,Common_Prec,Year_of_Hire)

    Give an expression in SQL for each of the following queries:

    Display the list of all customers by Cust_No with the city in which each is located.

    List the names of the sales persons who have accounts in Delhi.

    Or

    (b) (i) Consider the universal relation R(A,B,C,D,E,F,G,H,I,J) and the set of FD’s.

    G=({A,B}->{C}->{B,D}->{E,F},{A,D}->{G,H},{A}->{I},{H}->{J}) what is the key of R?

    Decompose R into 2NF, then 3NF relations.[10]

    (ii) Discuss how schema refinement through dependency analysis and normalization can improve schemas

    Obtained through ER design.[6]

    13 (a) (i) Describe the different types pf file organization? Explain using a sketch of each of them with their advantages and disadvantages.[10]

    (ii) Describe static hashing and dynamic hashing.[6]

    Or

    (b) (i) Explain the index schemas used in database systems.[10]

    (ii) How does a DBMS represent a relational query evaluation plan?[6]

    14 (a) (i) Explain Timestamp-Based Concurrency Control protocol and the modifications implemented in it.[10]

    (ii) Describe shadow paging recovery technique.[6]

    Or

    (b) (i) Describe Strict Two-phase Locking protocol.[10]

    (ii) Explain Log based recovery technique.[6]

    15 (a) (i) Explain 2-phase commitment protocol and the behaviour of this protocol

    during lost messages and site failures.[12]

    (ii) Describe X path and X query with an example.[4]

    Or

    (b) (i) Explain Data Mining and Data Warehousing.[12]

    (ii) Describe the anatomy of XML document.[4]

error: Content is protected !!