Sail E0 Webinar

MCQs

Total Questions : 40 | Page 2 of 4 pages
Question 11. The data model that is produced from reverse engineering is:
  1.    None of these
  2.    a conceptual model.
  3.    a logical model.
  4.    an internal model.
 Discuss Question
Answer: Option A. -> None of these
Question 12. To drop a column that is used as a foreign key, first:
  1.    drop the foreign key constraint.
  2.    All of these
  3.    drop the primary key.
  4.    drop the table containing the foreign key.
 Discuss Question
Answer: Option A. -> drop the foreign key constraint.
Question 13. Changing cardinalities in a database is:
  1.    is impossible to do, so a new database must be constructed and the data moved into it.
  2.    a database design task that never occurs.
  3.    a rare database design task, but does occur.
  4.    a common database design task.
 Discuss Question
Answer: Option D. -> a common database design task.
Question 14. The NOT EXISTS keyword will be true if:
  1.    any row in the subquery meets the condition.
  2.    all rows in the subquery fail the condition.
  3.    neither of these two conditions is met.
  4.    both of these two conditions are met.
 Discuss Question
Answer: Option B. -> all rows in the subquery fail the condition.
Question 15. The EXISTS keyword will be true if:
  1.    neither of these two conditions is met.
  2.    any row in the subquery meets the condition only.
  3.    all rows in the subquery fail the condition only.
  4.    both of these two conditions are met.
 Discuss Question
Answer: Option B. -> any row in the subquery meets the condition only.
Question 16. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
  1.    ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
  2.    None of these
  3.    ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
  4.    ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
 Discuss Question
Answer: Option D. -> ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Question 17. Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
  1.    optimistic
  2.    None of these
  3.    ambivalent
  4.    skeptical
 Discuss Question
Answer: Option D. -> skeptical
Question 18. How many copies of the database schema are typically used in the redesign process?
  1.    Two
  2.    One
  3.    Three
  4.    Four
 Discuss Question
Answer: Option C. -> Three
Question 19. Which is not true of a correlated subquery?
  1.    The processing of the SELECT statements is nested.
  2.    They are very similar to a regular subquery.
  3.    They can be used to verify functional dependencies.
  4.    EXISTS/NOT EXISTS is a form of a correlated subquery.
 Discuss Question
Answer: Option B. -> They are very similar to a regular subquery.
Question 20. A tool that can help designers understand the dependencies of database structures is a:
  1.    data model.
  2.    graphical display.
  3.    None of these
  4.    dependency graph.
 Discuss Question
Answer: Option D. -> dependency graph.

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0