Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. In the following query "person_id can beSELECT person_id, fname,l name, Birth_data FROM person   WHERE person_id=1;
  1.    Only Primary Key
  2.    Primary Key or any other Attribute
  3.    Only Attribute but not a primary Key
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> Primary Key or any other Attribute




Question 2. "INSERT is same as "UPDATE ?
  1.    NO
  2.    YES
  3.    May be
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> NO


"INSERT "is used to entering the data in the newly created table while "UPDATE is used to modify the data which is already inserted with help of statement "INSERT.


Question 3. Which command is used for taking "server side help in Mysql command line tool
  1.    /h
  2.    /c
  3.    /e
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> /h


/h represents help contents for Mysql.


Question 4. Which command is used for the table definition in Mysql?
  1.    DESC table_name;
  2.    DESC table_name
  3.    DESC
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> DESC table_name;




Question 5. Which command is used on Mysql command line tool to return to window command shell?
  1.    exit
  2.    exit;
  3.    exit()
  4.    exit();
 Discuss Question
Answer: Option A. -> exit




Question 6. The maximum length of the char columns is
  1.    255 bytes
  2.    65, 535 bytes
  3.    256 bytes
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> 255 bytes




Question 7. In the following query, what does "person_id stands for?CREATE TABLE person   (person_ id SMALLINT UNSIGNED,   fname VARCHAR(20),   lname VARCHAR(20) ,   CONSTRAINT pk_person PRIMARY KEY (person_id));
  1.    Normal attribute of the table
  2.    Super key
  3.    Composite key
  4.    Primary key
 Discuss Question
Answer: Option B. -> Super key


Primary key is also termed as a super key.


Question 8. Is "Datetime and "Timestamp are same data type?
  1.    Yes
  2.    No
  3.    Depends
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> Yes


"Timestamp column will automatically be populated with current Date/time by the Mysql server, when any row modified.


Question 9. Which Clause is used to select a particular row from the set of row in an existing table?
  1.    WHERE
  2.    FROM
  3.    ALTER
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> WHERE




Question 10. Which data type is more suitable for storing "documents in Mysql?
  1.    Varchar
  2.    Longtext
  3.    Mediumtext
  4.    Either a or b
 Discuss Question
Answer: Option B. -> Longtext


Longtext has largest range.


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