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 9875Which 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 7955If 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 12228What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 11190what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 7757what 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 1970Post New HCL SQL PLSQL Interview Questions
what is used of Property........End Property loop ? how to write the script for it?
can i change the runtime properties of an object ? How can i check if a parameter exists in database ?
What is normal radiation field out side the reactor building?
what are the different phases in delivering the project during development and maintenance?
what is pouring and explain
what is machine tpm
what is the uniform public construction cost accounting act?
i know the syllabus for the tax assistantexam but i would appreciate some tips fromyou on how to prepare for the general awareness paper.
what do you know about US culture?
What are the causes if one cylinder in a diesel engine has a high temperature?
write test case for gmail login page
can you explain about the design calculations and procedure of boiler
The sodium vapor lamp is not glows when it is connected a distance of 5 meters above from gearbox, why ?
What are the main components of the CERT Taxonomy?
all possible test cases for normal number field,name field date field,check box,
- C (112)
- STL (1)
- OOPS (28)
- C++ General (21)
- MFC (19)
- ATL (2)
- COM DCOM (2)
- Win32API (3)
- VC++ AllOther (2)
- Delphi (2)
- PHP (24)
- Programming Languages AllOther (23)
- ASP (8)
- CGI Perl (2)
- JavaScript (6)
- VB Script (3)
- JSP (7)
- Tcl (5)
- Scripts AllOther (2)
- SNMP (4)
- TCP IP (18)
- Protocols AllOther (7)
- Networking Administration (56)
- Networking Security (6)
- Networking AllOther (16)
- Visual Basic (10)
- C Sharp (39)
- ASP.NET (42)
- 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 (1)
- 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 (2)
- 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 (62)
- 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 (18)
- 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 (66)
- 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)
- 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 (14)
- English (19)
- General Aptitude (52)
- 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)
