Sail E0 Webinar

MCQs

Total Questions : 18 | Page 2 of 2 pages
Question 11. Using which language can a user request information from a database ?
  1.    Query
  2.    Relational
  3.    Structural
  4.    Compiler
 Discuss Question
Answer: Option A. -> Query


QueryQuery language is a method through which the database entries can be accessed.


Question 12. A domain is atomic if elements of the domain are considered to be ____________ units.
  1.    Different
  2.    Indivisbile
  3.    Constant
  4.    Divisible
 Discuss Question
Answer: Option B. -> Indivisbile


Indivisbile


Question 13. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
  1.    Instance, Schema
  2.    Relation, Schema
  3.    Relation, Domain
  4.    Schema, Instance
 Discuss Question
Answer: Option D. -> Schema, Instance


Schema, InstanceInstance is a instance of time and schema is a representation.


Question 14. The tuples of the relations can be of ________ order.
  1.    Any
  2.    Same
  3.    Sorted
  4.    Constant
 Discuss Question
Answer: Option A. -> Any


AnyThe values only count .The order of the tuples does not matter.


Question 15. Student(ID, name, dept name, tot_cred)
In this query which attribute form the primary key?
  1.    Name
  2.    Dept
  3.    Tot_cred
  4.    ID
 Discuss Question
Answer: Option D. -> ID


ID
The attributes name ,dept and tot_cred can have same values unlike ID .


Question 16. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
  1.    Union
  2.    Intersect
  3.    Difference
  4.    Projection
 Discuss Question
Answer: Option B. -> Intersect


IntersectThe union operator gives the result which is the union of two queries and difference is the one where query which is not a part of second query .


Question 17. A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
  1.    Schema diagram
  2.    Relational algebra
  3.    Database diagram
  4.    Schema flow
 Discuss Question
Answer: Option A. -> Schema diagram


Schema diagram


Question 18. The _________ provides a set of operations that take one or more relations as input and return a relation as an output
  1.    Schematic representation
  2.    Relational algebra
  3.    Scheme diagram
  4.    Relation flow
 Discuss Question
Answer: Option B. -> Relational algebra


Relational algebra


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