Sail E0 Webinar

MCQs

Total Questions : 262 | Page 6 of 27 pages
Question 51. In a relational schema, each tuple is divided into fields called
  1.    Domains
  2.    All of the listed here
  3.    Relations
  4.    Queries
 Discuss Question
Answer: Option A. -> Domains
Question 52. In SQL, which command is used to changes data in a table?
  1.    INSERT
  2.    UPDATE
  3.    BROWSE
  4.    APPEND
 Discuss Question
Answer: Option B. -> UPDATE
Question 53. In a large DBMS
  1.    all of the listed here
  2.    each user can access every sub¬schema
  3.    each subschema contains every field in the logical schema
  4.    each user can "see" only a small part of the entire database
 Discuss Question
Answer: Option D. -> each user can "see" only a small part of the entire database
Question 54. What name is given to the collection of facts, items of information or data which are related in some way?
  1.    Directory information
  2.    Information provider
  3.    Information tree
  4.    Database
 Discuss Question
Answer: Option D. -> Database
Question 55. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
  1.    MODIFY PROCEDURE
  2.    None of the listed here
  3.    ALTER PROCEDURE
  4.    COMPILE PROCEDURE
 Discuss Question
Answer: Option C. -> ALTER PROCEDURE
Question 56. 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
 Discuss Question
Answer: Option B. -> One-to-many relationship
Question 57. In SQL, the ALTER TABLESPACE command is used
  1.    to change storage characteristics
  2.    to add/rename data files
  3.    to take a tablespace online/offline
  4.    All of the listed here
 Discuss Question
Answer: Option D. -> All of the listed here
Question 58. Which command(s) is(are) used to redefine a column of the table in SQL ?
  1.    ALTER TABLE
  2.    MODIFY TABLE
  3.    DEFINE TABLE
  4.    all of the listed here
 Discuss Question
Answer: Option A. -> ALTER TABLE
Question 59. Internal auditors should review data system design before they are
  1.    All of the listed here
  2.    developed
  3.    implemented
  4.    modified
 Discuss Question
Answer: Option A. -> All of the listed here
Question 60. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
  1.    DEFINE TABLE
  2.    All of the listed here
  3.    MODIFY TABLE
  4.    ALTER TABLE
 Discuss Question
Answer: Option D. -> 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

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