Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




HCL SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is meant by DML?

5 7394

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 9951

Which 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 8035

If 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 12320

Types of locks in database ?

8 68410





What is normalization ?

9 14348

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 11300

Can a table have two primary keys?

44 66221

what is the boundary line in varrays?

1 5326

When we give SELECT * FROM EMP; How does oracle respond?

24 35467

Write one update command to update seqno field of a table on the basis of row number.

4 12935

what is indexing, searching and user interface?

1 3020

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 7827

i want to display 1 to 10 numbers using one select statement.

18 28048

what 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 2018

Post New HCL SQL PLSQL Interview Questions



Un-Answered Questions

Diff b/w Health care domain and Banking Domain?

3575


What is difference between Warm and Lukewarm Water as per pharmacopia.

271


ABOUT IDENTITY?

831


How does a cherry seed germinate?

882


we have syntax like for(int var : arrayName) this syntax is to find whether a number is in the array or not.but i want to know how to find that number's location.

856






i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?

2501


What are the main differences between Loadrunner and QTP tools? Describe briefly a "real world" scenario that would make you use the first one versus the other? Thank you for your answers....

1659


Sir, I have applied for the of section engineer at RRB chennai. please send me all RRB-chennai solved papers in the year of 2001 tO till date. i requested send me the papers to my id as soon as possible.

1127


What is the TDS rate in Maharastra, Tamil Nadu, Karnakata,Odisha & West Bengal. What is about Profession Tax.

695


What is interlacing?

331


how are reversing the direction of dc motor

487


1). explain need of software testing? 2). explain difference between developer testing & test engineers testing? 3). explain difference between verification & validation 4). which process your organization follows to develop an application? 5). explain v-model? & what is the meeting point in v-model?

1534


adams a debtor for R600 had been declared insolvent and part of his debts has to be written off. The attorneys informed you that an amount of 25c in the rand will be paid and the rest must be written off

511


why dont we assign not null constraint as table level constraint.

1599


draw the fig of bridge rectifier?

961






HCL SQL PLSQL Interview Questions
  • 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 (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)
  • 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)