Sail E0 Webinar

MCQs

Total Questions : 64 | Page 6 of 7 pages
Question 51. . The data model that is produced from reverse engineering is:
  1.    a conceptual model.
  2.    an internal model.
  3.    a logical model.
  4.    None of the above is correct.
 Discuss Question
Answer: Option D. -> None of the above is correct.
Question 52. . 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.    both of these two conditions are met.
  4.    neither of these two conditions is met.
 Discuss Question
Answer: Option B. -> all rows in the subquery fail the condition.
Question 53. . 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 ALTER CONSTRAINT GradeCheck (Grade > 0);
  2.    ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
  3.    ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
  4.    None of the above is correct.
 Discuss Question
Answer: Option C. -> ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Question 54. . To drop a column that is used as a foreign key, first:
  1.    drop the primary key.
  2.    drop the table containing the foreign key..
  3.    drop the foreign key constraint.
  4.    All of the above must be done.
 Discuss Question
Answer: Option C. -> drop the foreign key constraint.
Question 55. . How many copies of the database schema are typically used in the redesign process?
  1.    One
  2.    Two
  3.    Three
  4.    Four
 Discuss Question
Answer: Option C. -> Three
Question 56. . Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
  1.    optimistic
  2.    skeptical
  3.    ambivalent
  4.    None of the above is correct.
 Discuss Question
Answer: Option B. -> skeptical
Question 57. . A tool that can help designers understand the dependencies of database structures is a:
  1.    dependency graph.
  2.    data model.
  3.    graphical display.
  4.    None of the above is correct.
 Discuss Question
Answer: Option A. -> dependency graph.
Question 58. . Which is not true of a correlated subquery?
  1.    EXISTS/NOT EXISTS is a form of a correlated subquery.
  2.    The processing of the SELECT statements is nested.
  3.    They can be used to verify functional dependencies.
  4.    They are very similar to a regular subquery.
 Discuss Question
Answer: Option D. -> They are very similar to a regular subquery.
Question 59. . To drop a column that is used as a foreign key, first:
  1.    drop the primary key.
  2.    drop the table containing the foreign key..
  3.    drop the foreign key constraint.
  4.    All of the above must be done.
 Discuss Question
Answer: Option C. -> drop the foreign key constraint.
Question 60. . Which is not true of a correlated subquery?
  1.    EXISTS/NOT EXISTS is a form of a correlated subquery.
  2.    The processing of the SELECT statements is nested.
  3.    They can be used to verify functional dependencies.
  4.    They are very similar to a regular subquery.
 Discuss Question
Answer: Option D. -> They are very similar to a regular subquery.

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