Sail E0 Webinar

MCQs

Total Questions : 286 | Page 14 of 29 pages
Question 131. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
  1.    DEFINE TABLE
  2.    MODIFY TABLE
  3.    ALTER TABLE
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> ALTER TABLE
Question 132. In SQL, the ALTER TABLESPACE command is used
  1.    to add/rename data files
  2.    to change storage characteristics
  3.    to take a tablespace online/offline
  4.    to begin/end a backup
  5.    All of the above
 Discuss Question
Answer: Option E. -> All of the above
Question 133. The language used in application programs to request data from the DBMS is referred to as the
  1.    DML
  2.    DDL
  3.    query language
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> DML
Question 134. A database management system might consist of application programs and a software package called
  1.    FORTRAN
  2.    AUTOFLOW
  3.    BPL
  4.    TOTAL
  5.    None of the above
 Discuss Question
Answer: Option C. -> BPL
Question 135. An audit trail
  1.    is used to make back-up copies
  2.    is the recorded history of operations performed on a file
  3.    can be used to restore lost information
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> is the recorded history of operations performed on a file
Question 136. A race condition occurs when
  1.    Two concurrent activities interact to cause a processing error
  2.    two users of the DBMS are interacting with different files at the same time
  3.    both (a) and (b)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> Two concurrent activities interact to cause a processing error
Question 137. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
  1.    forecasting report
  2.    exception report
  3.    regularly scheduled report
  4.    on demand report
  5.    None of the above
 Discuss Question
Answer: Option D. -> on demand report
Question 138. An indexing operation
  1.    sorts a file using a single key
  2.    sorts file using two keys
  3.    establishes an index for a file
  4.    both (b) and (c)
  5.    None of the above
 Discuss Question
Answer: Option C. -> establishes an index for a file
Question 139. If you want your database to include methods, you should use a _____ database.
  1.    Network
  2.    Distributed
  3.    Hierarchical
  4.    Object-Oriented
  5.    None of the above
 Discuss Question
Answer: Option D. -> Object-Oriented
Question 140. In SQL, which command(s) is(are) used to create a synonym for a schema object?
  1.    CREATE SCHEMA
  2.    CREATE SYNONYM
  3.    CREATE SAME
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> CREATE SYNONYM

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