Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)
6 10234Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
6 8314If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 12661What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 11603what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 8004what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
1 2137Post New HCL SQL PLSQL Interview Questions
What is the ignititon temprecher of Diesel,Petrol&Carosion oil.
how synchronous motor use to improve the power factor
Design an underground tank of internal dimensions 6m x 3m x 3m. The soil surrounding the tank always remains dry. The tank shall be provided with a roof slab. The soil weighs 16000 N/m3 having an angle of repose of 30.
Let arr be an array of 20 integers. Write a program that first fills the array with up to 20 input values and then finds and displays both the subscript of the largest item in arr and the value of the largest item. • Use an IDE to develop and save your work
How do you Export a session ?
do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com
Explain joiner transformation in informatica
Hi, My name is Dinesh.I want to prepare for ISTQB certification , So can anyone please email me the syllabus of it and what is criteria for giving exam.Please email me answers at: dinesh0323@live.com
CATIA:SPRING WITH SOME RADIUS AXIS
why we are using benzene, anyline in acetic anhdride assay titration method?
What are combiners and its purpose?
why h parameter are called as hybrid parameter?
how do u implement configuration management in Informatica?
From where can be monitor the status of a Process Scheduler in PIA (write the navigation path)?
What are backlinks?
- C (112)
- STL (1)
- OOPS (28)
- C++ General (21)
- MFC (19)
- ATL (2)
- COM DCOM (2)
- Win32API (3)
- VC++ AllOther (2)
- Delphi (2)
- PHP (25)
- Programming Languages AllOther (23)
- ASP (8)
- CGI Perl (2)
- JavaScript (6)
- VB Script (3)
- JSP (7)
- Tcl (5)
- jQuery (1)
- Scripts AllOther (2)
- SNMP (4)
- TCP IP (18)
- Protocols AllOther (7)
- Networking Administration (56)
- Networking Security (6)
- Networking AllOther (17)
- Visual Basic (10)
- C Sharp (39)
- ASP.NET (43)
- VB.NET (4)
- ADO.NET (8)
- IIS (4)
- Crystal Reports (2)
- BizTalk (1)
- Dot Net Framework (4)
- Dot Net Remoting (2)
- Dot Net WindowsForms (2)
- Dot Net General (2)
- Dot Net AllOther (5)
- Exchange Server (9)
- Microsoft Related AllOther (7)
- Oracle General (16)
- Architecture (3)
- Database Management (11)
- Forms Reports (4)
- Oracle AllOther (9)
- SQL Server (63)
- MySQL (4)
- Sybase (2) SQL PLSQL (24)
- Databases AllOther (2)
- SDK (2)
- Windows Threads (3)
- Windows General (7)
- Windows AllOther (11)
- Linux Commands (16)
- Linux Socket Programming (1)
- Linux System Calls (2)
- Linux General (4)
- Linux AllOther (2)
- Unix Commands (13)
- Unix IPC (4)
- Unix AllOther (5)
- Solaris Commands (5)
- Solaris System Calls (1)
- Solaris General (4)
- Solaris AllOther (14)
- Operating Systems General Concepts (16)
- Operating Systems AllOther (3)
- WinRunner (4)
- Load Runner (6)
- QTP (39)
- Test Director (3)
- Rational TestSuite (2)
- Silk Test (1)
- Selenium (15)
- Automation Testing AllOther (4)
- Manual Testing (156)
- QA Concepts (10)
- Mobile Testing (3)
- Test Cases (13)
- Test Documents Reporting (1)
- Testing AllOther (12)
- Tomcat (1)
- Apache (2)
- Servers AllOther (1)
- COBOL (28)
- JCL (11)
- CICS (5)
- DB2 (7)
- ADABAS (1)
- Assembler (6)
- MVS (2)
- VSAM (4)
- IBM MainFrame AllOther (2)
- RPG400 (13)
- COBOL400 (1)
- DB400 (3)
- IBM AS400 AllOther (9)
- Core Java (65)
- Advanced Java (26)
- Swing (1)
- EJB (9)
- Servlets (13)
- Struts (14)
- JDBC (8)
- J2EE (5)
- Weblogic (26)
- Java J2EE AllOther (13)
- Java Related AllOther (10)
- CORBA (1)
- MQSeries (1)
- XML XSLT RSS (3)
- Teradata (3)
- Business Objects (18)
- Cognos (67)
- Informatica (47)
- Actuate (1)
- Ab Initio (7)
- Data Stage (26)
- SAS (9)
- ETL (4)
- Data Warehouse General (6)
- HR Questions (42)
- UML (1)
- OOAD (1)
- Requirements Management (1)
- Project Planning (6)
- Project Management (1)
- CTC (1)
- Theoritical (1)
- Visual Studio IDE (2)
- Telecom Routers Switches (1)
- VoIP IP Telephony (1)
- GSM (1)
- BlueTooth (1)
- Telecom General (3)
- Telecom AllOther (1)
- SAP Basis (28)
- SAP ABAP (67)
- SAPScript (4)
- SAP SD (39)
- SAP MM (10)
- SAP PP (4)
- SAP FI CO (46)
- SAP HR (7)
- SAP CRM (2)
- SAP SRM (1)
- SAP Business Warehouse (9)
- SAP Security (6)
- SAP Netweaver (2)
- SAP ALE IDocs (4)
- SAP B1 (3)
- PeopleSoft HRMS (2)
- PeopleSoft Tools (1)
- ERP General (1)
- Oracle Apps Technical (7)
- Oracle Apps Financial (32)
- 86 Family (3)
- VLSI (1)
- Client Server General (1)
- AI Neural Networks (1)
- Digital Certificates (1)
- Ciphers (2)
- WebMethods (3)
- TIBCO (2)
- JCAPS (1)
- Software Integration & Release (5)
- Program Management (3)
- Image Processing AllOther (2)
- Pega (16)
- Zoology (2)
- Geo Physics (1)
- Organic Chemistry (1)
- General Science (5)
- Sciences AllOther (1)
- Civil Engineering (7)
- Mechanical Engineering (17)
- Electrical Engineering (90)
- Electronics Communications (56)
- Chemical Engineering (3)
- Industrial Engineering (1)
- Instrumentation (9)
- Engineering AllOther (31)
- Business Administration (1)
- Marketing Sales (10)
- Banking Finance (4)
- Human Resources (9)
- Industrial Management (1)
- Infrastructure Management (1)
- IT Management (1)
- Non Technical (1)
- Business Management AllOther (2)
- Audit (2)
- Taxation (10)
- Accounting General (23)
- Accounting AllOther (27)
- Architecture Design AllOther (1)
- Call Centre AllOther (204)
- UPSC AllOther (1)
- SSC History (1)
- SSC General Studies (1)
- SSC AllOther (3)
- RRB (7)
- CDS (1)
- NDA (2)
- POs (4)
- BSRB Clerical (3)
- Group I (2)
- APPSC AllOther (5)
- General Knowledge_Current Affairs (29)
- Government AllOther (3)
- Law AllOther (1)
- Tourism Hotel AllOther (1)
- Funny Interview Questions (3)
- Everything Else AllOther (15)
- English (19)
- General Aptitude (88)
- Puzzles (11)
- Placement Papers (26)
- CCNA (70)
- CCDA (1)
- Microsoft Certifications (6)
- Sun Certifications (1)
- CISA Certification (1)
- Oracle Certifications (2)
- ISTQB Certification (1)
- Certifications AllOther (8)
- H1B Visa (2)
- USA Student Visa F1 Visa (1)
- L1 Visa (9)
- USA Business Visa B1 Visa (1)
- USA Dependent Visa H4 Visa (3)
- UK Visa (1)
- Australia Visa (2)
- Canada Visa (4)
- C Code (49)
- C++ Code (4)
- J2SE Code (2)
- ASP.NET Code (1)
- VB.NET Code (1)
- C Sharp Code (1)
- ADO.NET Code (1)
- PHP Code (1)
- JavaScript Code (2)
- WinRunner Code (1)
- GATE (2)
- OPENMAT (1)
- ICET (3)
- C C++ Errors (9)
- Oracle Errors (5)
- SQLServer Errors (1)
- Scripts Errors (1)
