Sail E0 Webinar

MCQs

Total Questions : 109 | Page 9 of 11 pages
Question 81. Select the right statement to insert values to the student table.
  1.    INSERT student VALUES (
  2.    INSERT VALUES (
  3.    INSERT INTO student VALUES (
  4.    INSERT VALUES INTO student (
 Discuss Question
Answer: Option C. -> INSERT INTO student VALUES (
Question 82. In SQL, which of the following is not a data definition language commands?
  1.    REVOKE
  2.    RENAME
  3.    UPDATE
  4.    GRANT
 Discuss Question
Answer: Option C. -> UPDATE
Question 83. ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.
  1.    EQUIJOIN
  2.    NON-EQUIJOIN
  3.    OUTER JOIN
  4.    NATURAL JOIN
 Discuss Question
Answer: Option B. -> NON-EQUIJOIN
Question 84. In SQL, which command is used to change a table's storage characteristics?
  1.    ALTER TABLE
  2.    MODIFY TABLE
  3.    CHANGE TABLE
  4.    None of these
 Discuss Question
Answer: Option A. -> ALTER TABLE
Question 85. What is a record?
  1.    Each column in a table is a Record
  2.    Only One name is a Record
  3.    Every table is a Record
  4.    Each row in a table is a Record
 Discuss Question
Answer: Option D. -> Each row in a table is a Record
Question 86. Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?
  1.    PLS_INTEGER
  2.    NUMBER
  3.    Both A & B
  4.    None of the above
 Discuss Question
Answer: Option A. -> PLS_INTEGER
Question 87. DBMS is an Interface between?
  1.    Database and developer
  2.    Database and Administrator
  3.    Database and Software
  4.    Database and End User
 Discuss Question
Answer: Option D. -> Database and End User
Question 88. Which operator is used to select values within a range?
  1.    RANGE
  2.    WITHIN
  3.    BETWEEN
  4.    None of these
 Discuss Question
Answer: Option C. -> BETWEEN
Question 89. What is used in the database for entering data by a user?
  1.    Excel Sheets
  2.    Forms
  3.    SQL software
  4.    PL SQL Software
 Discuss Question
Answer: Option B. -> Forms
Question 90. What is the most common type of join?
  1.    JOINED
  2.    INNER JOIN
  3.    INSIDE JOIN
  4.    JOINED TABLE
 Discuss Question
Answer: Option B. -> INNER JOIN

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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0