SQL Interview Questions in HCL - 2017-2018 StudyChaCha

Go Back   2017-2018 StudyChaCha > StudyChaCha Discussion Forum > General Topics




  #1  
Old December 14th, 2016, 02:10 PM
Unregistered
Guest
 
Posts: n/a
Default SQL Interview Questions in HCL

Can you provide me some SQL language interview questions for preparation for the interview section for recruitment in HCL Technologies?
Reply With Quote
  #2  
Old December 14th, 2016, 02:48 PM
Educhamp's Avatar
Super Moderator
 
Join Date: May 2011
Location: Delhi
Posts: 33,319
Default Re: SQL Interview Questions in HCL

Some SQL language interview questions for preparation for the interview section for recruitment in HCL Technologies are as follows:


What is the purpose of the PL/SQL language?
Say True or False. If False, explain why.
Routines written in PL/SQL can be called in Oracle call interface, Java, Pro*C/C++, COBOL etc.

Say True or False. If False, explain why.
PL/SQL does not have data types or variables.

State few notable characteristics of PL/SQL.
Name few schema objects that can be created using PL/SQL?
State some features or programming constructs supported by PL/SQL.
What are the three basic sections of a PL/SQL block?
What is wrong in the following assignment statement?
balance = balance + 2000;

Write a single statement that concatenates the words ‘Hello’ and ‘World’ and assign it in a variable named greeting.
Which operator has the highest precedence among the following −
AND, NOT, OR?

Which of the following operator has the lowest precedence among the following −
**, OR, NULL ?

What does the colon sign (: ) implies in the following statement?
:deficit := balance – loan;

What is the purpose of %type data type? Explain with example.
What is the purpose of %rowtype data type? Explain with example.
What is a PL/SQL package?
What is a trigger?
What are the PL/SQL cursors?
Say True or False. If False, explain why.
PL/SQL engine is part of Oracle Server.

Say True or False. If False, explain why.
The BEGIN declaration starts the variable declaration sections of a PL/SQL block.

Say True or False. If False, explain why.
The PL/SQL engine executes the procedural commands and passes the SQL commands for the Oracle server to process.

Say True or False. If False, explain why.
PL/SQL supports the CREATE command.

What is returned by the cursor attribute SQL%ROWCOUNT?
What is returned by the cursor attribute SQL%FOUND?
What is returned by the cursor attribute SQL%NOTFOUND?
Which command/commands allow iteration a use of loops in a PL/SQL block?
What is the difference in execution of triggers and stored procedures?
What are the uses of triggers?
Say True or False. If False, explain why.
Triggers can be associated to a view.

Say True or False. If False, explain why.
When a trigger is associated to a view, the base table triggers are normally disabled.

Say True or False. If False, explain why.
A trigger can perform the role of a constraint, forcing an integrity rule.

Say True or False. If False, explain why.
A trigger can execute the COMMIT, ROLLBACK, or SAVEPOINT commands.

What is the use of a WHEN clause in a trigger?
Say True or False. If False, explain why.
Statement level triggers are triggered only once.

What is the purpose of the optional argument [OR REPLACE] in a CREATE TRIGGER command?
Say True or False. If False, explain why.
INSTEAD OF is a valid option only for triggers in a table.

Write a statement to disable a trigger named update_marks.
Which command is used to delete a trigger?
Which command is used to delete a procedure?
What is the difference between a function and a stored procedure?
How do you declare a user-defined exception?
What do you understand by explicit cursors?
What are the steps that need to be performed to use an explicit cursor? Discuss briefly.
PL/SQL packages usually have two parts. What are these two parts?
Which command(s) are used for creating PL/SQL packages?
How do you refer to the types, objects and subprograms declared within a package?
Say True or False. If False, explain why.
PL/SQL allows subprogram overloading feature within a package.

Which command is used to delete a package?
What is the difference between implicit and explicit cursors?
Say True or False. If False, explain why.
The %NOTFOUND attribute returns true when the cursor is not created explicitly.

Say True or False. If False, explain why.
The %ROWCOUNT attribute returns the total number of rows returned by the FETCH command.
__________________
Answered By StudyChaCha Member
Reply With Quote
Sponsored Links






















Other Discussions related to this topic
Thread
Interview Questions for MBA
Interview questions that are asked in TNPSC Group II interview exam
Best Questions Ask MBA Interview
Interview questions for CTS
PSC Interview Questions
SAS Key Questions In Interview
Interview questions for C#
Interview Questions L&t BIS
4 yrs exp c# interview questions
TCS HR Interview Questions
Interview Questions for L&T
Interview questions for TCS
TCS Interview Questions MBA HR
IES Interview Questions
CDS Interview Questions
SSC Interview Questions
MBA IT Interview Questions
US MBA Interview Questions
DBA Interview Questions
IIM Questions Interview






Have a Facebook Account? Ask your Question Here



Reply


Forum Jump


All times are GMT +6.5. The time now is 01:02 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8 9