Sail E0 Webinar

MCQs

Total Questions : 109 | Page 6 of 11 pages
Question 51. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs
  1.    Hi
  2.    FLASE
  3.    TRUE
  4.    Nothing
 Discuss Question
Answer: Option D. -> Nothing
Question 52. Which of the following is illegal?
  1.    SELECT SYSDATE - SYSDATE FROM DUAL;
  2.    SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
  3.    SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
  4.    None of these
 Discuss Question
Answer: Option D. -> None of these
Question 53. Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return
  1.    less than 10 rows
  2.    more than 10 rows
  3.    exactly 10 rows
  4.    None of these
 Discuss Question
Answer: Option C. -> exactly 10 rows
Question 54. If a query involves NOT, AND, OR with no parenthesis
  1.    NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
  2.    NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
  3.    AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
  4.    The order of occurrence determines the order of evaluation.
 Discuss Question
Answer: Option A. -> NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
Question 55. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints
  1.    10
  2.    9
  3.    5
  4.    0
 Discuss Question
Answer: Option D. -> 0
Question 56. Which of the following SQL commands can be used to add data to a database table?
  1.    ADD
  2.    UPDATE
  3.    APPEND
  4.    INSERT
 Discuss Question
Answer: Option D. -> INSERT
Question 57. Which of the following is NOT a type of SQL constraint?
  1.    PRIMARY KEY
  2.    ALTERNATE KEY
  3.    FOREIGN KEY
  4.    UNIQUE
 Discuss Question
Answer: Option B. -> ALTERNATE KEY
Question 58. Which of the following join is also called as an 'inner-join'?
  1.    Non-Equijoin
  2.    Self-Join
  3.    Equijoin
  4.    None of these
 Discuss Question
Answer: Option C. -> Equijoin
Question 59. What is an SQL virtual table that is constructed from other tables?
  1.    view
  2.    A relation
  3.    Just another table
  4.    Query results
 Discuss Question
Answer: Option A. -> view
Question 60. When using the SQL INSERT statement:
  1.    rows cannot be copied in mass from one table to another only.
  2.    rows can be modified according to criteria only.
  3.    rows can either be inserted into a table one at a time or in groups.
  4.    rows can be inserted into a table only one at a time only.
 Discuss Question
Answer: Option C. -> rows can either be inserted into a table one at a time or in groups.

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