Sail E0 Webinar

MCQs

Total Questions : 286 | Page 15 of 29 pages
Question 141. Which command is used to select distinct subject (SUB) from the table (BOOK)?
  1.    SELECT ALL FROM BOOK
  2.    SELECT DISTINCT SUB FROM BOOK
  3.    SELECT SUB FROM BOOK
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> SELECT DISTINCT SUB FROM BOOK
Question 142. The master list of an indexed file
  1.    is sorted in ascending order
  2.    contains only a list of keys and record numbers
  3.    has a number assigned to each record
  4.    both (b) and (c)
  5.    None of the above
 Discuss Question
Answer: Option C. -> has a number assigned to each record
Question 143. 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 144. 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 145. 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 146. The database administration function includes
  1.    application programming
  2.    computer operations management
  3.    database access planning
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> database access planning
Question 147. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
  1.    tables
  2.    relations
  3.    tuple
  4.    both (a) and (b)
  5.    None of the above
 Discuss Question
Answer: Option D. -> both (a) and (b)
Question 148. A command that lets you change one or more fields in a record is
  1.    Insert
  2.    Modify
  3.    Look-up
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> Modify
Question 149. Which command is used to select distinct subject (SUB) from the table (BOOK)?
  1.    SELECT ALL FROM BOOK
  2.    SELECT DISTINCT SUB FROM BOOK
  3.    SELECT SUB FROM BOOK
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> SELECT DISTINCT SUB FROM BOOK
Question 150. The master list of an indexed file
  1.    is sorted in ascending order
  2.    contains only a list of keys and record numbers
  3.    has a number assigned to each record
  4.    both (b) and (c)
  5.    None of the above
 Discuss Question
Answer: Option C. -> has a number assigned to each record

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