Sail E0 Webinar

MCQs

Total Questions : 286 | Page 13 of 29 pages
Question 121. In SQL, which command is used to add a column/integrity constraint to a table
  1.    ADD COLUMN
  2.    INSERT COLUMN
  3.    MODIFY TABLE
  4.    ALTER TABLE
  5.    None of the above
 Discuss Question
Answer: Option D. -> ALTER TABLE
Question 122. In SQL, which command(s) is(are) used to enable/disable a database trigger?
  1.    ALTER TRIGGER
  2.    ALTER DATABASE
  3.    ALTER TABLE
  4.    MODIFY TRIGGER
  5.    All of the above
 Discuss Question
Answer: Option A. -> ALTER TRIGGER
Question 123. In a relational schema, each tuple is divided into fields called
  1.    Relations
  2.    Domains
  3.    Queries
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> Domains
Question 124. In SQL, which command is used to changes data in a table?
  1.    UPDATE
  2.    INSERT
  3.    BROWSE
  4.    APPEND
  5.    None of the above
 Discuss Question
Answer: Option A. -> UPDATE
Question 125. What name is given to the collection of facts, items of information or data which are related in some way?
  1.    Database
  2.    Directory information
  3.    Information tree
  4.    Information provider
  5.    None of the above
 Discuss Question
Answer: Option A. -> Database
Question 126. In a large DBMS
  1.    each user can "see" only a small part of the entire database
  2.    each user can access every sub¬schema
  3.    each subschema contains every field in the logical schema
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> each user can "see" only a small part of the entire database
Question 127. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
  1.    COMPILE PROCEDURE
  2.    ALTER PROCEDURE
  3.    MODIFY PROCEDURE id) All of the above
  4.    None of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> ALTER PROCEDURE
Question 128. A _____ means that one record in a particular record type may be related to more than one record of another record type.
  1.    One-to-one relationship
  2.    One-to-many relationship
  3.    Many-to-one relationship
  4.    Many-to many relationship
  5.    None of the above
 Discuss Question
Answer: Option B. -> One-to-many relationship
Question 129. Internal auditors should review data system design before they are
  1.    developed
  2.    implemented
  3.    modified
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 130. Which command(s) is(are) used to redefine a column of the table in SQL ?
  1.    ALTER TABLE
  2.    DEFINE TABLE
  3.    MODIFY TABLE
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> ALTER TABLE

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

Chapter 3.1 : Overview of Finance & Accounts Department Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An overview Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024