Paragon Placement Paper -: SQL Questions With Answers

Paragon Previous Years Solved Sample Placement Papers

1. An object can have which of the following multiplicities?
   

   A. Zero

   B. One

   C. More than one

   D. All of the above Answer: Option D

2. When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.
   

   A. True Answer: Option A

   B. False

3. Decide the Big-O complexity of the following function:
   

   def sum_of_divisors(n)
       result = 0
       i = 1
       while i < n
           if n % i == 0
               result += i
           end
           i += 1
       end
       return result
   end
           

   Solution: The complexity of the function is O(n) as the loop runs from 1 to n-1.

4. Using ODL, you can define which of the following?
   

   A. Attribute

   B. Structure

   C. Operation

   D. All of the above Answer: Option D

5. Which of the following is an ordered collection of elements of the same type?
   

   A. Set

   B. Bag Answer: Option B

   C. List

   D. Dictionary

6. To run a compiled Java program, the machine must have what loaded and running?
   

   A. Java virtual machine Answer: Option A

   B. Java compiler

   C. Java bytecode

   D. A Web browser

7. A relation is considered a:
   

   A. Column

   B. One-dimensional table

   C. Two-dimensional table Answer: Option C

   D. Three-dimensional table

8. A tuple is a(n):
   

   A. Column of a table

   B. Two-dimensional table

   C. Row of a table Answer: Option C

   D. Key of a table

9. For some relations, changing the data can have undesirable consequences called:
   

   A. Referential integrity constraints

   B. Modification anomalies Answer: Option B

   C. Normal forms

   D. Transitive dependencies

10. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
    

    A. Supertype entity

    B. Subtype entity

    C. Archetype entity Answer: Option C

    D. Instance entity

11. Correct the sentence:
    The Diary of Anne Frank “SHOWED A YOUNG GIRL’S COURAGE” during two years of hiding.
    

    A. Has shown a young girl’s courage

    B. Did show a young girl's courage

    C. Shows a young girl’s courage

    D. Showed a young girl’s courage Answer: Option D

    E. Showed a young girl's courage

12. Correct the sentence grammatically:
    To “NO ONES SURPRISE,” Joe didn’t have his homework ready.
    

    A. No ones surprise

    B. No one’s surprise Answer: Option B

    C. Noones surprise

    D. No ones’ surprise

    E. No-ones surprise

13. In the question below, a sentence is broken into parts. Join these parts to make a meaningful sentence. The correct order of parts is the answer:
    1. was 2. and 3. Suresh 4. kind 5. loving
    

    A. 31425 Answer: Option A

    B. 54213

    C. 34251

    D. 15243

    E. 12345

14. In the question below, a sentence is broken into parts. Join these parts to make a meaningful sentence. The correct order of parts is the answer:
    1. tea 2. have 3. That 4. some 5. before
    

    A. 43251

    B. 24315

    C. 24153 Answer: Option C

    D. 52431

    E. 41325