Sail E0 Webinar

MCQs

Total Questions : 32 | Page 1 of 4 pages
Question 1. Which of the following is not a definition of NULL Value?
  1.    NULL is not the same as zero or a blank space
  2.    Arithmetic operations on a NULL value does not always return a NULL Value
  3.    NULL Value is the absence of any character,zero,blank space
  4.    none of the above
 Discuss Question
Answer: Option B. -> Arithmetic operations on a NULL value does not always return a NULL Value
Question 2. The restrictions or conditions applied on data are known as ______________
  1.    Constraints
  2.    data models
  3.    relations
  4.    none of the above
 Discuss Question
Answer: Option A. -> Constraints
Question 3. The Oracle environment of database is called as ___________
  1.    Database Schema
  2.    Database Instances
  3.    Data Structure
  4.    All of the Mentioned
 Discuss Question
Answer: Option A. -> Database Schema
Question 4. Which of the following SQL clauses is used to DELETE tuples from a database table?
  1.    DELETE
  2.    REMOVE
  3.    DROP
  4.    CLEAR
 Discuss Question
Answer: Option A. -> DELETE
Question 5. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation
  1.    Candidate
  2.    Primary
  3.    Super
  4.    Sub
 Discuss Question
Answer: Option B. -> Primary
Question 6. The HAVING clause does which of the following?
  1.    Acts like a WHERE clause but is used for groups rather than columns.
  2.    Acts like a WHERE clause but is used for rows rather than columns.
  3.    Acts like a WHERE clause but is used for columns rather than groups.
  4.    Acts like a WHERE clause but is used for groups rather than rows.
 Discuss Question
Answer: Option A. -> Acts like a WHERE clause but is used for groups rather than columns.
Question 7. The term attribute refers to a ___________ of a table
  1.    Record
  2.    Tuple
  3.    Column
  4.    Key
 Discuss Question
Answer: Option C. -> Column
Question 8. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
  1.    DML(Data Manipulation Langauge)
  2.    DDL(Data Definition Langauge)
  3.    Query
  4.    Relational Schema
 Discuss Question
Answer: Option B. -> DDL(Data Definition Langauge)
Question 9. Logical design of database, is known to be
  1.    Database relation
  2.    Database instance
  3.    Database entity
  4.    Database Schema
 Discuss Question
Answer: Option D. -> Database Schema
Question 10. The set of all possible values that an attribute may contain is called the ___________ of an attribute
  1.    Domain
  2.    Relation
  3.    Set
  4.    Schema
 Discuss Question
Answer: Option A. -> Domain

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