TestLead
  • Home
  • Jobs
  • About Us
  • Home
  • Jobs
  • About Us

Database Testing

  • SQL commands

    Order By Order By clause used to retrieve the records in a sorted order. Syntax: Select < Fields Name> from < Table Name > order by < Field Name> Example: Select * from Employee order by EmployeeName; Here * indicate all the Fields if user wants to show only specific fields than in the below query you have to mention the name of the fields Example: Select Address, Age from Employee order by EmployeeName; By Default it shows the records in the Ascending order. Group […]

    Read More...
  • What should I do if we are facing the issue while installing the oracle and there is one instance is already exist on system ?

    •Uninstall all Oracle components using the Oracle Universal Installer (OUI). •Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entries for all Oracle products. •Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora* It should be pretty obvious which ones relate to Oracle. •Reboot your machine. •Delete the “C:\Oracle” directory, or whatever directory is your ORACLE_BASE. •Delete the “C:\Program Files\Oracle” directory. •Empty the contents of your “C:\temp” directory. •Empty your recycle bin.  

    Read More...
  • What are the key checkpoints for database testing ?

    Verification of the Table name Data type, Size ,column name Verification of the Default values fr0m valid value set. Verification of static table data Verification of the date format throughout the database. Verification of the constraints like primary key, foreign key , composite key , NULL Not NULL

    Read More...
  • What is Normalization and various form of normalization?

    First NF: Duplicate columns should be eliminated. Second NF: Should be 1NF. Should remove subsets of data that repeats in multiple rows and place them in separate table. Third NF: Should be in 2NF. Repeat columns that are not dependent upon the primary key. Boyce-Codd NF: Should be in 3NF. A relation is in BCNF if every determinant is a candidate key. Fourth NF: Should be in 3NF and BCNF. A relation is in 4NF if it has no more than one multi-valued or multiple […]

    Read More...
  • Displayed the duplicate row and no of occurrence ?

    SELECT NAME, COUNT (NAME) FROM TABLE1 GROUP BY NAME HAVING COUNT (NAME) > 1

    Read More...
  • 1
  • 2
  • Search

  • Subscribe for newsletter




  • Recent Posts

    • How to setup WordPress website on local host

      5 Jan 2021

    • What is difference between QA, QC and Software Testing?

      27 Jan 2020

    • SQL commands

      4 Dec 2013

    • Describe the Key features of JMeter , SOAP UI and LISA Tool ?

      4 Dec 2013

    • What do you mean by User acceptance Testing and when can be start the UAT?

      3 Dec 2013

    • What is Software Quality Assurance?

      3 Dec 2013

    • TIBCO Testing VS Traditional Testing ?

      24 Nov 2013

    • What are the TIBCO Business work methodology ?

      1 Nov 2013

    • Displayed Pallets are Dependent on which factors ?

      31 Oct 2013

    • What are Activity output and Group ?

      30 Oct 2013




  • Tweets by @Test_Lead

  • Search



  • Audible Books

  • Newsletter

    Delivered by FeedBurner

  • Testlead
  • Links

    • Software Engineering
    • Database Testing
    • TIBCO TESTING
    • Manual Testing
    • Web Service
    • WIN Runner
    • UNIX
    • QTP
© 2013 TestLead All Rights Reserved
  • Home
  • About Us
  • Privacy Policy
  • Sitemap