Sail E0 Webinar

MCQs

Total Questions : 64 | Page 5 of 7 pages
Question 41.  Database redesign is not terribly difficult if the:
  1.    database is structured.
  2.    database is well-designed.
  3.    database has no data.
  4.    database is relatively small.
 Discuss Question
Answer: Option C. -> database has no data.
Question 42.  The process of reading a database schema and producing a data model from that schema is known as:
  1.    data modeling.
  2.    database design.
  3.    reverse engineering.
  4.    None of the above is correct.
 Discuss Question
Answer: Option C. -> reverse engineering.
Question 43.  Which of the following modifications may not succeed?
  1.    Changing a column data type from char to date
  2.    Changing a column data type from numeric to char
  3.    Both of the above actions should succeed.
  4.    Neither of the above actions will succeed.
 Discuss Question
Answer: Option A. -> Changing a column data type from char to date
Question 44.  Which SQL-92 standard SQL command can be used to change a table name?
  1.    RENAME TABLE
  2.    CHANGE TABLE
  3.    ALTER TABLE
  4.    None of the above is correct.
 Discuss Question
Answer: Option D. -> None of the above is correct.
Question 45.  Before any changes to database structure are attempted one should first:
  1.    clearly understand the current structure and contents of the database only.
  2.    test any changes on a test database only.
  3.    create a complete backup of the operational database only.
  4.    All of the above should be done.
 Discuss Question
Answer: Option D. -> All of the above should be done.
Question 46.  How can you find rows that do not match some specified condition?
  1.    EXISTS
  2.    Double use of NOT EXISTS
  3.    NOT EXISTS
  4.    None of the above is correct.
 Discuss Question
Answer: Option B. -> Double use of NOT EXISTS
Question 47. . The EXISTS keyword will be true if:
  1.    any row in the subquery meets the condition only.
  2.    all rows in the subquery fail the condition only.
  3.    both of these two conditions are met.
  4.    neither of these two conditions is met.
 Discuss Question
Answer: Option A. -> any row in the subquery meets the condition only.
Question 48. . What SQL command can be used to add columns to a table?
  1.    MODIFY TABLE TableName ADD COLUMN ColumnName
  2.    MODIFY TABLE TableName ADD ColumnName
  3.    ALTER TABLE TableName ADD COLUMN ColumnName
  4.    ALTER TABLE TableName ADD ColumnName
 Discuss Question
Answer: Option D. -> ALTER TABLE TableName ADD ColumnName
Question 49.  A regular subquery can be processed:
  1.    from the top down.
  2.    from the bottom up.
  3.    by nesting.
  4.    None of the above is correct.
 Discuss Question
Answer: Option B. -> from the bottom up.
Question 50. . Changing cardinalities in a database is:
  1.    a common database design task.
  2.    a rare database design task, but does occur.
  3.    a database design task that never occurs.
  4.    is impossible to do, so a new database must be constructed and the data moved into it.
 Discuss Question
Answer: Option A. -> a common database design task.

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