What is a Scheduled Jobs or What is a Scheduled Tasks? 2008-04-11 08:24:53 Scheduled tasks let user automate processes that run on regular or predictable cycles. User canschedule administrative tasks, such as cube processing, to run during times of slow business activity.User can also determine the order in which tasks run by creating job steps within a SQL Server Agentjob. E.g. Back up database, Update Stats of Tables. Job steps give user control over flow of execution.If one job fails, user can configure SQL Server Agent to continue to run the remaining tasks or to stopexecution. Read more:Tasks
What is Identity? 2008-04-11 08:24:26 Identity (or AutoNumber) is a column that automatically generates numeric values. A start andincrement value can be set, but most DBA leave these at 1. A GUID column also generates numbers,the value of this cannot be controled. Identity/GUID columns do not need to be indexed.
How to get @@error and @@rowcount at the same time? 2008-04-11 08:24:09 If @@Rowcount is checked after Error checking statement then it will have 0 as the value of@@Recordcount as it would have been reset.And if @@Recordcount is checked before the error
-checking statement then @@Error would get reset.To get @@error and @@rowcount at the same time do both in same statement and store them in localvariable. SELECT @RC = @@ROWCOUNT, @ER = @@ERROR
What is De-normalization? 2008-04-11 08:23:50 De-normalization is the process of attempting to optimize the performance of a database by addingredundant data. It is sometimes necessary because current DBMSs implement the relational modelpoorly. A true relational DBMS would allow for a fully normalized database at the logical level, whileproviding physical storage of data that is tuned for high performance. De-normalization is a techniqueto move from higher to lower normal forms of database modeling in order to speed up database access.
What are the properties of the Relational tables? 2008-04-11 08:23:24 Relational tables have six properties:· Values are atomic.· Column values are of the same kind.· Each row is unique.· The sequence of columns is insignificant.· The sequence of rows is insignificant.· Each column must have a unique name.
What is data integrity? Explain constraints? 2008-04-11 08:21:15 Data integrity is an important feature in SQL Server. When used properly, it ensures that data isaccurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within applications.A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table shouldhave a primary key constraint to uniquely identify each row and only one primary key constraint can becreated for each table. The primary key constraints are used to enforce entity integrity.A UNIQUE constraint enforces the uniqueness of the values in a set of columns, so no duplicate valuesare entered. The unique key constraints are used to enforce entity integrity as the primary keyconstraints.A FOREIGN KEY constraint prevents any actions that would destroy links between tables with thecorr
What is an execution plan? When would you use it? How would you view the execution plan? 2008-04-13 12:11:04 An execution plan is basically a road map that graphically or textually shows the data retrieval methodschosen by the SQL Server query optimizer for a stored procedure or ad-hoc query and is a very usefultool for a developer to understand the performance characteristics of a query or stored procedure sincethe plan is the one that SQL Server will place in its cache and use to execute the stored procedure orquery. From within Query Analyzer is an option called "Show Execution Plan" (located on the Querydrop-down menu). If this option is turned on it will display query execution plan in separate windowwhen query is ran again.
OPENXML 2008-04-13 12:10:44 OPENXML is a Transact-SQL keyword that provides a relational/rowset view over an in-memory XMLdocument. OPENXML is a rowset provider similar to a table or a view. OPENXML provides a way toaccess XML data within the Transact-SQL context by transferring data from an XML document into therelational tables. Thus, OPENXML allows you to manage an XML document and its interaction with therelational environment.
How do SQL server 2000 and XML linked? Can XML be used to access data? 2008-04-13 12:10:21 How do SQLserver
2000 and XMLlinked
? Can XML be used to access data?FOR XML (ROW, AUTO, EXPLICIT)Ans:You can execute SQL queries against existing relational databases to return results as XML rather thanstandard rowsets. These queries can be executed directly or from within stored procedures. To retrieveXML results, use the FOR XML clause of the SELECT statement and specify an XML mode of RAW, AUTO,or EXPLICIT.
What is OLTP(OnLine Transaction Processing)? 2008-04-13 12:09:42 In OLTP - online transaction processing systems relational database design use the discipline of datamodeling and generally follow the Codd rules of data normalization in order to ensure absolute dataintegrity. Using these rules complex information is broken down into its most simple structures (a table)where all of the individual atomic level elements relate to each other and satisfy the normalizationrules. Read more:Transaction
, Processing
What is DataWarehousing? 2008-04-13 12:09:24 · Subject-oriented, meaning that the data in the database is organized so that all the dataelements relating to the same real-world event or object are linked together;· Time-variant, meaning that the changes to the data in the database are tracked and recordedso that reports can be produced showing changes over time;· Non-volatile, meaning that data in the database is never over-written or deleted, oncecommitted, the data is static, read-only, but retained for future reporting;· Integrated, meaning that the database contains data from most or all of an organization'soperational applications, and that this data is made consistent.
List few advantages of Stored Procedure. 2008-04-13 12:08:53 · Stored procedure can reduced network traffic and latency, boosting application performance.· Stored procedure execution plans can be reused, staying cached in SQL Server's memory,reducing server overhead.· Stored procedures help promote code reuse.· Stored procedures can encapsulate logic. You can change stored procedure code withoutaffecting clients.· Stored procedures provide better security to your data. Read more:Procedure
What is Cross Join? 2008-04-13 12:07:59 A cross join that does not have a WHERE clause produces the Cartesian product of the tables involvedin the join. The size of a Cartesian product result set is the number of rows in the first table multipliedby the number of rows in the second table. The common example is when company wants to combineeach product with a pricing table to analyze each product at each price. Read more:Cross
What is Self Join? 2008-04-13 12:07:20 This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A selfjoin can be of any type, as long as the joined tables are the same. A self join is rather unique in that itinvolves a relationship with only one table. The common example is when company have a hierarchalreporting structure whereby one member of staff reports to another.
How to copy the tables, schema and views from one SQL server to another? 2008-04-13 12:07:04 Microsoft SQL
Server 2000 Data Transformation Services (DTS) is a set of graphical tools andprogrammable objects that lets user extract, transform, and consolidate data from disparate sourcesinto single or multiple destinations. Read more:server
, views
Can SQL Servers linked to other servers like Oracle? 2008-04-13 12:06:29 SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link.E.g. Oracle
has a OLE-DB provider for oracle that Microsoft provides to add it as linked
server to SQLServer group. Read more:SQL
, servers
Can we rewrite subqueries into simple select statements or with joins? 2008-04-13 12:06:14 Subqueries can often be re-written to use a standard outer join, resulting in faster performance. As wemay know, an outer join uses the plus sign (+) operator to tell the database to return all non-matchingrows with NULL values. Hence we combine the outer join with a NULL test in the WHERE clause toreproduce the result set without using a sub-query
Accenture test paper for interview 2008-04-15 01:53:21 The recruitment process (four round) is quite a long. It goes as follows:--I. Written Test 1 HrsII. GD 15 Mins.III. Technical 20-30 Mins.IV. HR 10 Mins.Total students appear for Written =190For GD =116For Technical=79For HR=50Final Selection = 33 of which six from MCA.( I ) WRITTEN TEST for interview
Written Test Consist of 55 question to be answer in 1 Hrs. & a short ESSAY on a given topic.Written Test consist of Three Section:1) Verbal 20 Questions2) Aptitude 20 Questions3) Analytical 15 Questions1) VERBAL SECTION for interviewIt consist of question likefill in the blanks using given words,fill in the blanks using given ARTICLE,2-3 question from synonymsTwo passage were given one on SQL language & another on DBMS.5 - Question from each passage.Its quite a easy one.2) APTITUDE3 Read more:paper
ACCENTURE Placement Paper January 2006 2008-04-15 01:52:43 Accenture Interview Test paperFor Aptitude R.S Agarwal is enough to crack this.For technical u have to grill the "Test ur C & C++ Skill" books.Most of the questions r repeated from prev. question paper.In C++,Mostly from Polymorphism,inheritence,virtual functions,constructors.In C,Mostly from scope of variable,pointers,structures.Its quite easy when compare to C++.Go on. Be a Tiger.HR Interview:Its cool & relax round.1.First they will ask u to intro urself.2.Ur strength & weakness.Be clear abt this.3.Ur acheivements4.They are very particular abt the GAPS in our studies.5.Ur Hobbies.6.Why u choose accenture & tell abt it.7.Willing to relocate.(Say Yes &.ready to work anywhere for accenture)Technical Interview for job:1.Abt Ur project.(u will be grilled by them)2.Be con Read more:Placement
, January
LATEST 2008 january ACCENTURE Employment Questions paper 2 2008-04-15 01:52:07 Accenture Test paper
31)question papers will repete2)Be careful in HR Round(its an elimination round) 2.1)dont lie in hr,becoz to cover that lie you need to say bigger lies & u will be trapped somewhere 2.2)always be a keen listner with a pleasent face(if u are NOT atleast act like that)2.3)finally HR will say "Do you have any Questions??". its very important because that question reveals your attitude & knowledge about the industry you are going to work.Ask some startling, unexpected questions!!!3)Technical round If you are from Computer science prepare well in3.1) DBMS(normalization,1NF,2NF,3NF,BCNF,4NF,5NF with examples,Database architecture,schema architecture,DDL,DML,role of s/m administrator,concurrency control(locking,timestamps))3.2) Datastructuressorting
LATEST 2007 December ACCENTURE Employment Questions 2008-04-15 01:51:38 Accenture Test paper 2There was three different phases for job inteview test(1) written exam(2) HR(3) techniqual interviewfnd there were 4 section in the written exam(i) english section [15 questions](ii) aptitude [30 questions](iii) lang "c" [15 quests](iv) lang c++ [15 quests]english sections -----------question given here are just based on my memory, & may not be exactlysame .so just get the idea of the questions---(i)_ university named with cusat is situated there.[ans-a](ii) we study in _university,rather in school.[ans-a](iii) mr riju works _ the supervision of mr ram.[ans-under]like that 10 questions wr based on article & preposition.(2 synonyms & antonyms)5 questions wr based on the comprehension.. that was not very hard. but i'll prefer to do i Read more:December
ACCENTURE Interview Employment Questions Pattern 2008-04-15 01:50:56 Accenture test paper for interview The recruitment process (four round) is quite a long. It goes as follows:--I. Written Test 1 HrsII. GD 15 Mins.III. Technical 20-30 Mins.IV. HR 10 Mins.Total students appear for Written =190For GD =116For Technical=79For HR=50Final Selection = 33 of which six from MCA.( I ) WRITTEN TEST for interviewWritten Test Consist of 55 question to be answer in 1 Hrs. & a short ESSAY on a given topic.Written Test consist of Three Section:1) Verbal 20 Questions2) Aptitude 20 Questions3) Analytical 15 Questions1) VERBAL SECTION for interviewIt consist of question likefill in the blanks using given words,fill in the blanks using given ARTICLE,2-3 question from synonymsTwo passage were given one on SQL language & another on DBMS.5 - Question from each passa Read more:Pattern
2008 Latest Accenture Placement test pattern 2008-04-15 01:50:17 Latest Accenture test pattern for interviewstep1: (i)aptitute test (quant+verbal+reasoning)time limit-1hr 10mins,no sectional cutoffs, no negative marking, difficulty level-easy, overall cutoff-high, sets of papers distributed-two.important topics covered- venn diagrams, symbol based problems, direction problems, word meanings/opposites, prepositions, articles, comprehensions. (ii)essay time limit-15mins, word limit-none, topic- current affairs.step 2: group discussions. time limit- 15mins max. , importance level- very high, topics- current affairs.step 3: hr interview type- easy but tricky. be careful. memorise every small detail about d company said in ppt.step 4: technical interview type- easy, a little bit tricky, try to answer smartly, topic-anything u Read more:Placement
ACCENTURE Placement Paper January 2006 2008-04-15 01:49:44 Accenture Interview Test paperFor Aptitude R.S Agarwal is enough to crack this.For technical u have to grill the "Test ur C & C++ Skill" books.Most of the questions r repeated from prev. question paper.In C++,Mostly from Polymorphism,inheritence,virtual functions,constructors.In C,Mostly from scope of variable,pointers,structures.Its quite easy when compare to C++.Go on. Be a Tiger.HR Interview:Its cool & relax round.1.First they will ask u to intro urself.2.Ur strength & weakness.Be clear abt this.3.Ur acheivements4.They are very particular abt the GAPS in our studies.5.Ur Hobbies.6.Why u choose accenture & tell abt it.7.Willing to relocate.(Say Yes &.ready to work anywhere for accenture)Technical Interview for job:1.Abt Ur project.(u will be grilled by them)2.Be con Read more:Placement
, January
LATEST 2008 january ACCENTURE Employment Questions paper 2 2008-04-15 01:49:13 Accenture Test paper
31)question papers will repete2)Be careful in HR Round(its an elimination round) 2.1)dont lie in hr,becoz to cover that lie you need to say bigger lies & u will be trapped somewhere 2.2)always be a keen listner with a pleasent face(if u are NOT atleast act like that)2.3)finally HR will say "Do you have any Questions??". its very important because that question reveals your attitude & knowledge about the industry you are going to work.Ask some startling, unexpected questions!!!3)Technical round If you are from Computer science prepare well in3.1) DBMS(normalization,1NF,2NF,3NF,BCNF,4NF,5NF with examples,Database architecture,schema architecture,DDL,DML,role of s/m administrator,concurrency control(locking,timestamps))3.2) Datastructuressorting
LATEST 2007 December ACCENTURE Employment Questions 2008-04-15 01:48:34 Accenture Test paper 2There was three different phases for job inteview test(1) written exam(2) HR(3) techniqual interviewfnd there were 4 section in the written exam(i) english section [15 questions](ii) aptitude [30 questions](iii) lang "c" [15 quests](iv) lang c++ [15 quests]english sections -----------question given here are just based on my memory, & may not be exactlysame .so just get the idea of the questions---(i)_ university named with cusat is situated there.[ans-a](ii) we study in _university,rather in school.[ans-a](iii) mr riju works _ the supervision of mr ram.[ans-under]like that 10 questions wr based on article & preposition.(2 synonyms & antonyms)5 questions wr based on the comprehension.. that was not very hard. but i'll prefer to do i Read more:December
LATEST 2008 january ACCENTURE Employment Questions PATTERN 1 2008-04-15 01:45:42 ACCENTURE Aptitude test for jobInterview process will consist of1. aptitude test2. g.d [1 year back there was no g.d}3. H.R (human resource) interview4. Technical interviewaptitude TEST:Written Test Consist of 55 question to be answered in 1 Hr. &5 minutes for a short ESSAY on a given topic. the topic for my batchwas impact of modernisation in india.Written Test consist of Three Section: 1) Verbal 20 Questions 2) Aptitude 20 Questions 3) Analytical 15 Questions1) VERBAL SECTIONIt consisted of question likefill in the blanks using correct prepostions :3-4 queseg: - india about 73 percentege -the population live- rural areas. ans: in,of infill in the blanks using given ARTICLE :3-4 ques2-3 question from synony
2008 Latest Accenture Placement test pattern 2008-04-15 01:44:50 Latest Accenture test pattern for interviewstep1: (i)aptitute test (quant+verbal+reasoning)time limit-1hr 10mins,no sectional cutoffs, no negative marking, difficulty level-easy, overall cutoff-high, sets of papers distributed-two.important topics covered- venn diagrams, symbol based problems, direction problems, word meanings/opposites, prepositions, articles, comprehensions. (ii)essay time limit-15mins, word limit-none, topic- current affairs.step 2: group discussions. time limit- 15mins max. , importance level- very high, topics- current affairs.step 3: hr interview type- easy but tricky. be careful. memorise every small detail about d company said in ppt.step 4: technical interview type- easy, a little bit tricky, try to answer smartly, topic-anyth Read more:Placement
Recommend Site To A Friend
