Sail E0 Webinar

MCQs

Total Questions : 286 | Page 16 of 29 pages
Question 151. In SQL, the CREATE TABLESPACE is used
  1.    to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
  2.    to create a database trigger
  3.    to add/rename data files, to change storage
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
Question 152. In SQL, which command is used to remove a stored function from the database?
  1.    REMOVE FUNCTION
  2.    DELETE FUNCTION
  3.    DROP FUNCTION
  4.    ERASE FUNCTION
  5.    None of the above
 Discuss Question
Answer: Option C. -> DROP FUNCTION
Question 153. Which of the following is not the responsibility of the utilities component of DBMS software?
  1.    creating the physical and logical designs
  2.    removing flagged records for deletion
  3.    creating and maintaining the data dictionary
  4.    monitoring performance
  5.    None of the above
 Discuss Question
Answer: Option A. -> creating the physical and logical designs
Question 154. 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 155. 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 156. 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 157. 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 158. 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 159. 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 160. 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