Sail E0 Webinar

MCQs

Total Questions : 32 | Page 2 of 4 pages
Question 11. Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
  1.    DML(Data Manipulation Language)
  2.    Query
  3.    Relational Schema
  4.    DDL(Data Definition Language)
 Discuss Question
Answer: Option D. -> DDL(Data Definition Language)
Question 12. A set of objects that share a common structure and a common behavior is called:
  1.    Object
  2.    Class
  3.    Entity
  4.    None of these
 Discuss Question
Answer: Option B. -> Class
Question 13. Address field of a person should not be part of primary key, since it is likely to ?
  1.    Dependent
  2.    Too long
  3.    Changed
  4.    Not changed
 Discuss Question
Answer: Option C. -> Changed
Question 14. The level of data abstraction which describes how the data is actually stored is
  1.    Conceptual level
  2.    Physical level
  3.    File level
  4.    None of these
 Discuss Question
Answer: Option B. -> Physical level
Question 15. In the relational model, cardinality is termed as
  1.    A number of tuples.
  2.    A number of attributes.
  3.    A number of tables.
  4.    number of constraints.
 Discuss Question
Answer: Option A. -> A number of tuples.
Question 16. A table joined with itself is called
  1.    Join
  2.    Self Join
  3.    Outer Join
  4.    Equi Join
 Discuss Question
Answer: Option A. -> Join
Question 17. What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table is 5
  1.    Degree 15, Cardinality 16
  2.    Degree 8 Cardinality 16
  3.    Degree 15 cardinality 60
  4.    Degree 8 Cardinality 60
 Discuss Question
Answer: Option D. -> Degree 8 Cardinality 60
Question 18. Which statement is used to extract data from a database?
  1.    Extract
  2.    Get
  3.    Open
  4.    Select
 Discuss Question
Answer: Option D. -> Select
Question 19. In a relational Database a referential integrity constraint cab be specified with the help of
  1.    Primary Key
  2.    Secondary key
  3.    Foreign key
  4.    None of these
 Discuss Question
Answer: Option C. -> Foreign key
Question 20. In the architecture of the Database System, external level is the
  1.    Physical level
  2.    Logical level
  3.    Conceptual level
  4.    View level
 Discuss Question
Answer: Option D. -> View level

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