SQL and PL/SQL Interview Questions and Answers

All Categories >> Databases Programming >> SQL and PL/SQL >> ▼

Explore the Structure Query Language (SQL) and PLSQL Interview Questions and Answers

  1. SQL and PL/SQL questions updated at 01 Jul 10 in Category Databases Programming and visited 2874 Times

SQL and PL/SQL Questions and Answers:

1 :: What is the use of CASCADE CONSTRAINTS?

When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
0/5 Rating (0 vote)
Is This Answer Correct?    5 Yes 5 No
Place Your Answer

2 :: BETWEEN ... AND operators in SQL.

SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.
0/5 Rating (0 vote)
Is This Answer Correct?    4 Yes 2 No
Place Your Answer

3 :: The IN operator may be used if you know the exact value you want to return for at least one of the columns.

SELECT column_name FROM table_name WHERE column_name IN (value1,value2,..)
0/5 Rating (0 vote)
Is This Answer Correct?    4 Yes 1 No
Place Your Answer

4 :: Sort the Rows in SQL.

Sort the Rows:
SELECT column1, column2, ... FROM table_name ORDER BY columnX, columnY, ..
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC, columnY ASC
0/5 Rating (0 vote)
Is This Answer Correct?    4 Yes 0 No
Place Your Answer

5 :: The Delete Statements in SQL.

DELETE FROM table_name WHERE column_name = some_value

Delete All Rows:
DELETE FROM table_name or DELETE * FROM table_name
0/5 Rating (0 vote)
Is This Answer Correct?    2 Yes 2 No
Place Your Answer

Rate This Category:
0/5 Rating (0 vote)
 Place Your Question



Top: SQL and PL/SQL Interview Questions and Answers
SQL and PL/SQL Interview Questions and Answers

Top Frequently Asked SQL and PL/SQL Question
Frequently Asked SQL and PL/SQL Job Interview Question


Top Frequently opened Databases Programming Job Interview categories
Most popular Databases Programming Job Interview categories

Comments About SQL and PL/SQL Interview Questions and Answers

Share your valuable opinions, ideas and suggestions about SQL and PL/SQL Interview Questions and Answers
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

  1. Webmaster 23rd of May 2012

    Webmaster Said

    Tell us what you feel about SQL and PL/SQL Interview Questions and Answers
    All comments will be published after review. No login or registration is required to post a comment on SQL and PL/SQL Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
    So start sharing your thoughts regarding SQL and PL/SQL Interview Questions and Answers
    Thank you.

    Reply

Leave a Comment

Leave a Comment
  4.  Enter This Verification Code  Regenerate Verification Code  



Your reply will be added to the comment above (Below any other replies to this comment) -

Top Comments About: SQL and PL/SQL Interview Questions and Answers
Comments on SQL and PL/SQL Interview Questions and Answers

 
Top of Link batk to SQL and PL/SQL Interview Questions and Answers
Link batk to SQL and PL/SQL Interview Questions and Answers

Privacy Policy | Terms and Conditions | Contact Us »