Active Server Pages(ASP) - Data Base Questions Other Questions

Active Server Pages(ASP) - Data Base Questions                                                        Other Questions Dear Visitors herewith we are listing some smaple questions asked during Interview Sessions. This Questions is only for your references. Refer the suitable books and prepare the answers for this questions for your satisfaction.  How can I make my SQL queries case sensitive?  Can I use the NZ() function without getting 80040E14 errors?  Why do I get 80040E37 errors?  How do I deal with MEMO, TEXT, HYPERLINK, and CURRENCY columns?  Why does ASP give me ActiveX errors when connecting to a database?  Why do I get 80040E24 errors?  Why do I get 80040E2F errors?  Why do I get 800A0CC1 errors?  Why do I get 800A0C93 errors?  How do I start SQL Server Agent from ASP?  How do I solve 'Operation must use an updateable query' errors?  How do I enumerate through the DSNs on a machine?  How do I connect to a non-default instance of SQL Server?  How do I debug my SQL statements?  Why does Access give me 'unspecified error' messages?  How do I handle BIT / BOOLEAN columns?  How do I get the stored procedures out of a database?  How do I sort out a query with optional parameters?  What is wrong with 'LIKE *'?  Why should I avoid NULLs in my database?  Which is better, rs(0) or rs("column_name")?  Why do I get errors about master..spt_values?  How do I create a cross-tab (or "pivot") query?  How do I simulate an array inside a stored procedure?  When should I use CreateObject to create my recordset objects?  How do I get the tables out of a database?  How do I handle alphabetic pagination?  How do I use a SELECT list alias in the WHERE or GROUP BY clause?  How do I change the order of columns in a table?  How do I determine if a table exists in a SQL Server database?  How do I determine if a table exists in an Access database?  How do I return row numbers with my query?  How do I get column names and datatypes for a table?  Where can I get this 'Books Online' documentation?  Why do I get script errors in Enterprise Manager's 'taskpad' view?  How can SQL Server tell me which row was inserted last?  How do I audit changes to SQL Server data?  Should I use ADOVBS.inc for declaring constants?  Should I store images in the database or the filesystem?  How do I manage changes in SQL Server objects?  Which database platform should I use for my ASP application?  Why can't I install SQL Server on Windows XP?  Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all?  How do I document / compare my SQL Server database(s)?  How do I upsize from Access to SQL Server?  How do I get the nth row in a SQL Server table?  How do I know which version of SQL Server I'm running?  Why do I get 8004D00A errors?  How do I rename a column?  Why do I get 80040E14 errors?  How do I prevent duplicates in a table?  How do I remove duplicates from a table?  Why do I get 80040E23 errors?  Where can I get basic info about using stored procedures?  How do I calculate the median in a table?  Which tool should I use: Enterprise Manager or Query Analyzer?  What should my connection string look like?

Ascent's CAT Summer Crash Course

Ascent's CAT Summer Crash Course

Starts May 18, 2006

Ascent's CAT Crash course is a two-month long intensive CAT training classroom program. This short term CAT crash course is designed to assist students who have time only during their summer vacation to have a jump start with their CAT preparation. The crash course is presently conducted only in Chennai.

Who should opt for Ascent's short term CAT crash course?

• Students from BITS, Pilani who will be spending their summer vacation in Chennai and getting back to campus after summer holidays.
• Students from IITs, NITs and other engineering colleges who are either spending their summer holidays in Chennai or are doing their summer internship at Chennai.
• CAT aspirants who have had near misses (with over 90 percentile in the previous CAT) who want a short term CAT course that serves as an intensive CAT training.
• CAT aspirants who have other committments after July and have no time to attend classes after July.

The CAT crash course will equip you to be better prepared for facing the exacting testing standards of the best B-Schools in India, the IIMs. Our CAT training program is highly effective and has resulted in as many as 15% of our students joining premier institutes such as IIM Ahmedabad, IIM Bangalore, IIM Calcutta, IIM Lucknow and ISB each year. 

CAT Training Methodology - From the basics

The curriculum of our CAT coaching class starts right from the basics, be it Math (Quant) or English (Verbal). The level of competency expected in CAT is proficiency in 10th standard curriculum Math and first year graduation English. Though CAT tests your competency in basic Math and English, the proficiency expected is very high. Hence, our CAT preparation starts right from the basics to ensure that your fundamentals are really strong. You can build speed and accuracy after strengthening your fundamentals. 

Quant / DI - The 1, 2, 3s...

Those of us from the so called "non quant" (Arts, Commerce) background may not have done any academic Math during the last five years. Ascent's CAT course starts right from "Number Systems" and guides you through all the relevant topics.

For those of us who have a "quant" background (engineers, for instance) this CAT course will help us unlearn unhealthy habits like punching a calculator for computing the product of 32 and 38. 

Our CAT training course will acquaint you with a number of math shortcuts to solve problems in the shortest possible time.

Verbal / Comprehension - The A, B, Cs...

Familiarity breeds complacence. Most of us think we are comfortable with the English language. We speak, read and write in English. However, seldom have we adhered to the rules of English grammar, thanks to our daily "lingo." Our English classroom refreshes these basic rules and teaches techniques to answer CAT type Verbal and Comprehension questions.

Tests, tests &, tests....

Clearing the CAT test is not about knowing everything. In fact, hardly anyone attempts all of the 90 odd questions during the two hours. The key difference between those who clear CAT and those who do not lies in not how much one knows, but in being able to identify the right kind of questions and to solve them as quickly as possible.

This CAT crash course includes Speed Tests and Proficiency Tests that are designed to help you master these techniques across the four areas, viz., Mathematics (Quantitative Reasoning), Verbal, Reading Comprehension and Logical and Analytical Reasoning. 

The CAT training course will provide you with 20 Full length CAT Comprehensive Tests and 10 Mock CATs. Four of the 30 Full Length Tests will be administered on alternate Sundays during the tenure of the course. The remaining tests should be taken at your pace between August and November. In-depth analysis of the four Mock CAT tests will follow each test. Individual counseling and group counseling on test taking strategies will be held to assist you achieve your goal. 

CAT Study Material

Ascent's CAT Study material covering all the areas being tested in the Common Admission Test will be provided. The study material has been prepared by the core faculty comprising graduates from the IIMs. The study material has been developed based on recent patterns of CAT. 

GD-PI Training

The intensive CAT Crash course includes a 7-day intensive training for GD and PI which will be completed by the end of July 2006.

CAT Course Schedule and Details

Registration for the CAT Crash Course is on. The classes will commence on May 18, 2006. Classes will be held 5 days a week at our Nungambakkam Centre. The course will end on July 26, 2006

Fees

Rs.9400 (Rupees Nine Thousand Four Hundred only)

Batch

The size of the CAT Crash course batch is 15 students only

How to Enrol?

Drop into our office at 
14-B/1, Dr.Thirumurthy Nagar 1st Street
Nungambakkam
Chennai - 600 034

Or call us at +91 44 4500 8484 (Or at) +91 44 3912 4040

Or send an email to ascent@ascenteducation.com 

What is IIM's CAT (Common Admission Test) all about?

What is IIM's CAT (Common Admission Test) all about?

CAT - The Common Admission Test to the six IIMs is also the entrance test for few other top B-Schools such as SP Jain, MICA, and T A Pai. CAT tests your skills in five broad areas viz.

1. Verbal ability and reasoning
2. Reading Comprehension
3. Quantitative skills
4. Data Interpretation
5. Analytical and Logical reasoning.

The test comprised 90 questions divided into 3 sections in the year 2005. Typically this test can be expected to comprise between 75 to 150 objective type questions and is usually divided into three to four sections. Each question has a question statement followed by four alternate answer choices and the candidate has to choose the best answer for each of the questions and mark it on a special Optical Reader answer sheet.

Over the years, the number of questions being asked in CAT has been decreasing steadily. While the early 90s witnessed 180 to 200 questions, the late 90s, specifically CAT 1999 and CAT 2000 had 165 questions each. CAT 2001, CAT 2002 and CAT 2003 had only 150 questions each and these 150 questions were divided into three sections of 50 questions each. There were 123 questions in CAT 2004 and only 90 in CAT 2005. CAT 2004 and CAT 2005 both had differential marks to questions. There were 0.5 marks, 1 mark and 2 marks questions. 

The duration of the test is of 120 minutes. This literally translates to answering a CAT question in 48 seconds. Most successful aspirants do not attempt anything more than 120 plus questions. And quite a lot of them attempt between 70 and 90 marks worth of questions. The key to success, therefore, lies in two important parameters

1. The accuracy or strike rate

While each correct answer carries 0.5 or 1 or 2 positive mark, each incorrect question carries 1/3rd of the marks allocated to it as negative marks. Hence, it is important to get a strike rate of over 85% - that is reduce the number of negatives.

2. Smart Selection

As it is clear that you will not be generally able to attempt all 150 marks question, and you skip between 60 to 80 questions, key to success lies in selecting questions properly. Hence, there are no kudos, nobel prizes or awards waiting for attempting the tough questions. Be smart to choose, the easiest of the questions and the ones that you have practised a lot and smash them. Do not venture into unsafe territories or to questions which you only have a vague idea.

CAT and entrance tests of other top B Schools are a unique breed of entrance exams. They focus on testing some of the basic qualities essential for managers - the grit to work hard, smartness to choose the best alternative, quick thinking and above all perseverance.

Exams like IIT JEE test the depth of your knowledge, while the Civil Services exams test your width of knowledge. CAT evaluates your presence of mind and the ability to perform under pressure. You cannot prepare for CAT during the last 10 days, as one generally does for semester exams. A minimum of 3 to 9 months of regular preparation is essential.

Ascent's CAT classroom courses are designed to help you maximize your potential gains from these exacting entrance exams. You can choose from the Different Courses that Ascent offers. 

To get an insight into how to effectively crack CAT, you can attend Ascent'sFREE SHORTCUT CLASS. 

To register for the free shortcut class or to take a free diagnostic test drop into our office at 
14B/1, Dr.Thirumurthy Nagar 1st Street
Nungambakkam
Chennai 600 034.

Or call us at (Chennai) 91 - 44 - 4500 8484 / 3912 4040 or send a mail toshortcut@ascenteducation.com

Interview Questions

Interview Questions 

Successful Interview Tips      Successful Group Discussion Tips      How to Improve Your Listening Skills 


Dear Visitors herewith we are listing some smaple expected questions asked during Interview Sessions. This Questions is only for your references. Refer the suitable books and prepare the answers for this questions for your satisfaction. 

* Active Server Pages(ASP) - Data Base Questions  * Active Server Pages(ASP) - Components Questions  * Active Server Pages(ASP) - EMAIL Questions  * Active Server Pages(ASP) - FILESYSTEM Questions  * Active Server Pages(ASP) - Forms Questions  * Active Server Pages(ASP) - DATES Questions  * Active Server Pages(ASP) - GENERAL Questions  * Interview Questions For C++  * Interview Questions For Core Java  * Interview Questions For Enterprise Java Bean - EJB  * Interview Questions For JDBC  * Interview Questions For Servlets  * Interview Questions For Java Server Page JSP

GENERAL ABILITY TEST IN ENGINEERING

Selection Plan of the Examination:  The examination is of two parts:  (a) Written examination (b) Personality test     PART I: The written examination will comprise two sections Section I consisting only of objective type questions which is of 2 hours duration and Section II conventional papers of 3 hours duration each. Both Sections will cover the entire syllabus of the relevant engineering disciplines, viz., Civil Engineering, Mechanical Engineering, Electrical Engineering and Electronics and Telecommunication Engineering.  PART II: Personality Test carrying a maximum of 200 marks pertaining; to candidates who qualify on the basis of the written examination. Examination Subjects: The following will be the subjects for the written examination: Category I - Civil Engineering Subjects Duration Max. Marks Section I-Objective Papers  General Ability Test (Part A: General English) 2 hours  200  (Part B: General Studies)  Civil Engineering Paper I 2 hours 200  Civil Engineering Paper II 2 hours 200 Section 11-Conventional Papers  Civil Engineering Paper I 3 hours  200  Civil Engineering Paper II 3 hours 200   Category II-Mechanical Engineering Section 1-Objective Papers  General Ability Test  (Part A: General English) 2 hours 200  (Part B: General Studies)  Mechanical Engineering Paper I 2 hours 200  Mechanical Engineering Paper II  2 hours 200  Section 11-Conventional Papers  Mechanical Engineering Paper I  3 hours 200  Mechanical Engineering Paper II 3 hours 200 Category III-Electrical Engineering Section I-Objective Papers General Ability Test (Part A: General English)  2 hours  200 (Part B: General Studies)  Electrical Engineering Paper I  2 hours 200  Electrical Engineering Paper II 2 hours 200 Section II Conventional Papers  Electrical Engineering Paper I 3 hours  200  Electrical Engineering Paper II  3 hours 200  Category IV-Electronics and Telecommunication Engineering Section I-Objective Papers  General Ability Test   (Part A: General English)  2 hours 200 (Part B: General Studies)  Electronics & Telecom Engg. Paper I  2 hours 200 Electronics & Telecom Engg. Paper II 2 hours 200  Section II Conventional Papers  Electronics & Telecom Engg. Paper I 3 hours 200  Electronics & Telecom Engg. Paper II  3 hours 200 Standard of Papers  The standard of papers in General Ability Test will be as may be expected of an Engineering/ Science Graduate. The standard of papers in other subject will approximately be that of an Engineering Degree of an Indian University. There will be no practical examinations in

TSD CAT 93 QUESTIONS

TSD CAT 93 QUESTIONS

Following are the original question asked in CAT 1993.
I ‘ll put few other questions tomorrow

Q started to move from point B towards point A exactly an hour after P started frm A in the opposite direction. Q’s speed was twice that of P. when P had covered one-sixth of the distance between the points A and B, Q had also covered the same distance.

Q1. The point where P and Q would meet, is :
a. Closer to A
b. Exactly between A and B
c. Closer to B
d. P and Q will not meet at all.

Q2. How many hours would P take to reach B?
a. 2
b. 5
c. 6
d. 12

Q3. How many hours would P(compared to Q) take to complete his journey?
a. 4
b. 5
c. 6
d. 7

Q4. A group of workers was put on a job. From the second day onwards, one worker was withdrawn each day. The job was finished when the last worker was withdrawn. Had no worker been withdrawn at any stage, the group would have finished the job in two-thirds the time. How many workers were there in the group?
a. 2
b. 3
c. 5
d. 10

Q5. A shop leaves on a long voyage. When it is 18 miles from the shore, a sea plane, whose speed is ten times that of the ship, is sent to deliver mail. How far from the shore does the sea plane catch up the ship?
a. 24 miles
b. 25 miles
c. 22 miles
d. 20 miles

CAT Question types

CAT Question types 

There are 4 types of questions usually can seen in CAT examination

1. Data Interpretation - or DI, for testing the analytical and logical skills. you will be provided with graphs, charts and tables. and tests how well you interpret the data available in graphs and tables.

2. Mathematics - includes basics of algebra, geometry and trigonometry. Questions will be appearing as so simple, but very confusing

3. Relating to English language : Tests your verbal and grammatical skills in English. includes analogies, antonyms and synonyms, fill in the blanks, correcting sentences, arranging sentences etc.

4. Comprehension - Here you will be provided with a passage and have to answer the questions following.. Remember its not like a primary school exam, dont take it simple, the passages may look simple.. but the answers will be nowhere in the paragraph, you may doubt the questions are out of passage (hahaha.........)