.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 43 44 45 46 47 48 49 50 51 52 53 … > >>   Sort: Date

What is SIX sigma
What is SIX sigma? Sigma means deviation in Greek language. Deviation means how much variations exist in a set of data. For instance let’s say in a software maintenance project out of 100 defects 68 defects are rectified to the mark and remaining bounce back that means your bug fixing process is on ... 2007-10-30, 5468👍, 0💬

What is Modeling and why UML ?
What are advantages of using UML? As the name suggest UNIFIED MODELING LANGUAGE. Modelling has been around for years, not only in software field but also in other trades like civil, mechanical etc. Example in civil engineering drawing the main architecture built of diagram is a model by itself. Mode... 2007-10-26, 5468👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ... 2007-05-11, 5468👍, 0💬

How To Get Execution Path Reports on Query Statements
How To Get Execution Path Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial... 2007-04-30, 5468👍, 0💬

How to Loop through an Array
How to Loop through an Array? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations The best way to loop through an array is to use the "foreach" statement. There are two forms of "foreach" statements: foreach ($array as $value) {} - This gives you only one temporary variable to ho... 2007-04-20, 5468👍, 0💬

What Is a Join
What Is a Join? Join is the form of SELECT command that combines info from two or more tables. Types of Joins are Simple (Equijoin and Non-Equijoin), Outer and Self join. Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause. Non-Equijoin r... 2007-04-15, 5467👍, 0💬

Can You Provide a List of Assertion Methods Supported by JUnit 4.4
Can You Provide a List of Assertion Methods Supported by JUnit 4.4? You should be able to answer this question by looking up the org.junit.Assert class API document. Here is a list of assertino methods supported by JUnit 4.4: assertEquals(expected, actual) assertEquals(message, expected, actual) ass... 2008-01-22, 5466👍, 0💬

How To Dump a Table to a File with "mysqldump"
How To Dump a Table to a File with "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise: >cd \mysql\bin >mysqldump ... 2007-05-11, 5466👍, 0💬

What Is a Result Set Object
What Is a Result Set Object? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in t... 2007-05-10, 5466👍, 0💬

What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks
What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks? - MySQL FAQs - Transaction Management: Commit or Rollback If you are using transactions with REPEATABLE READ isolation level and transaction safe storage engines in your applications, data locks, lock timeouts, and dead lock d... 2007-05-08, 5466👍, 0💬

What is Cache Callback in Cache
What is Cache Callback in Cache ? Cache object is dependent on its dependencies example file based, time based etc...Cache items remove the object when cache dependencies change.ASP.NET provides capability to execute a callback method when that item is removed from cache. 2007-10-23, 5464👍, 0💬

How To Delete All Rows a Table
How To Delete All Rows a Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELETE statement. The t... 2007-04-21, 5464👍, 0💬

Two of your resources have conflicts between them how would you sort it out
You have people in your team who do not meet there deadlines or do not perform what are the actions you will take ? In such kind of question they want to see your delegation skills. The best answer to this question is a job of a project manager is managing projects and not problems of people, so I w... 2007-10-30, 5463👍, 0💬

How To Rebuild an Index
How To Rebuild an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME T... 2007-04-27, 5459👍, 0💬

How To Use NULL as Conditions
How To Use NULL as Conditions? - Oracle DBA FAQ - Understanding SQL Basics If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "&lt;>" against NULL. The sample script below shows you some good examples: SELECT 'A' IS... 2007-04-23, 5459👍, 0💬

How To Submit Values without a Form
How To Submit Values without a Form? - PHP Script Tips - Processing Web Forms If you know the values you want to submit, you can code the values in a hyper link at the end of the URL. The additional values provided at the end of a URL is called query string. There are two suggestions on how to use q... 2007-04-22, 5458👍, 0💬

How To Pass Parameters to Procedures
How To Pass Parameters to Procedures? - Oracle DBA FAQ - Introduction to PL/SQL Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQ... 2007-04-26, 5457👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create loc... 2007-04-17, 5457👍, 0💬

Declaring Methods within JSP Pages
How can I declare methods within my JSP page? You can declare methods for use within your JSP page as declarations. The methods can then be invoked within any other methods you declare, or within JSP scriptlets and expressions. Do note that you do not have direct access to any of the JSP implicit ob... 2007-04-03, 5457👍, 0💬

What Happens If Unique Value Constraints Are Violated
What Happens If Unique Value Constraints Are Violated? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you are inserting a new record that has values violating a unique constraint, you will get an error. Note that primary key column has a unique value constraint by default. ... 2007-05-11, 5456👍, 0💬

How can we use Culture Auto in project
How can we use Culture Auto in project? We will make a simple login screen which we will try to use for English as well as Greek. The login screen will display English settings when an English user logs in and Greek Settings when a Greek user logs in. So below are the steps to start with. In the abo... 2007-11-01, 5455👍, 0💬

Do you know Use Case points
Do you know Use Case points? In CD we have a complete free PDF tutorial of how to prepare software quotation. It has all the estimation technology that today’s software industry uses. 2007-10-30, 5454👍, 0💬

How to use a checkbox in a datagrid
How can I track event in checkbox which is one of the columns of a datagrid ? Note: - This is normally asked when the interviewer want to see that have you really worked practically on a project. Following are the steps to be done :- 1. In ASPX page you have to add Itemtemplate tag in datagrid. &... 2007-10-24, 5454👍, 0💬

How To Write a Left Outer Join with the WHERE Clause
How To Write a Left Outer Join with the WHERE Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)".... 2007-04-19, 5454👍, 0💬

<< < … 43 44 45 46 47 48 49 50 51 52 53 … > >>   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML