- World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.

  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!

    Send your Resume to 6000 Companies

    Question :
    With SQL, how can you return the number of records in the ?Persons? table?
    a) SELECT COLUMNS (*) FROM Persons
    b) SELECT COLUMNS () FROM Persons
    c) SELECT COUNTS () FROM Persons
    d) SELECT COUNTS (*) FROM Persons

    Posted by: kritika on 6/8/2010

    Contact kritika Contact kritika
    Category Oracle Interview Questions
    Rating (0.4) By 2411 users
    Added on 6/8/2010
    Views 1622
    Rate it!

    Answer is
    d) SELECT COUNTS (*) FROM Persons

    Posted by: Vinay    

    Contact Vinay Contact Vinay

    select count(*) from persons

    Posted by: kranthikumar    

    Contact kranthikumar Contact kranthikumar

    With Oracle, all the options dont seem to work. Please try below.

    Select count(1) from all_tab_columns
    where table_name='<table_Name>';

    Posted by: Susil Kumar    

    Contact Susil Kumar Contact Susil Kumar

    d) SELECT COUNTS (*) FROM Persons

    Posted by: p anil kumar    

    Contact p anil kumar Contact p anil kumar

    d) SELECT COUNTS (*) FROM Persons

    Posted by: Sindhu Priya    

    Contact Sindhu Priya Contact Sindhu Priya

    d) SELECT COUNTS (*) FROM Persons

    Posted by: JAMES    

    Contact JAMES Contact JAMES


    Posted by: Kishan.R.Khamitkar    

    Contact Kishan.R.Khamitkar Contact Kishan.R.Khamitkar

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

    Related Questions
    View Answer
    What is difference between using cursor variable(Ref cursor) and collections(like record with associative array)
    View Answer
    Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each?
    View Answer
    Explain the difference between a data block, an extent and a segment?
    View Answer
    What is the function of redo log?
    View Answer
    What is a redo log?
    View Answer
    What are the characteristics of data files?
    View Answer
    What is a datafile?
    View Answer
    How to define data block size?
    View Answer
    What is data block?
    View Answer
    What is Restricted Mode of Instance Startup ?
    View Answer
    What are the different modes of mounting a Database with the Parallel Server ?
    View Answer
    What are the steps involved in Database Startup ?
    View Answer
    What is Current record attribute property?
    View Answer
    What is OLE automation ?
    View Answer
    What are savepoint mode and cursor mode properties?
    View Answer
    What is path setting for DLL?
    View Answer
    Can you pass values to-and-fro from foreign function ? how ?
    View Answer
    What is mouse navigate property of button?
    View Answer
    What are property classes ? Can property classes have trigger?
    View Answer
    Can you store objects in library?
    View Answer

    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here - Best Freshers & Experienced Jobs Website.

    View ALL Oracle Interview Questions

    User Options
    Sponsored Links

    Copyright ©2003-2015, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

    Cache = 0 Seconds