Tag: databases

Questions Related to databases

  1. It gives the name and marks of all the students.

  2. It does not return anything.

  3. It shows an error saying” INVALID SYNTAX ERROR”

  4. It shows an error saying” Single-row subquery returns more than one row


Correct Option: D
  1. Add new rows to a table

  2. Modify existing rows of a table

  3. Remove existing rows from a table

  4. All of the above


Correct Option: D
  1. Insert to table tablename (….);

  2. Insert into table tablename (….);

  3. Insert into table tablename values (…..);

  4. Any one of the above


Correct Option: C
  1. Date

  2. Sysdate

  3. Current Date

  4. System Date


Correct Option: B
  1. Acquisition

  2. Transaction

  3. Application

  4. Clean Up


Correct Option: A,C
  1. Define the target table

  2. Define the Work table

  3. Define the input file

  4. Define the Error table


Correct Option: C