What will be the output of the query given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='HEAD TELLER' AND start_date=2008-11-24; Options: A . &nbspAll columns B . &nbspOnly those columns which are mention with SELECT" clause C . &nbspColumns mention with SELECT" clause and only those rows which contain 'HEAD TELLER' as a title" and start_date as 2008-11-24 D . &nbspNone of the mentioned

What will be the output of the query given below?SELECT emp

Question

What will be the output of the query given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='HEAD TELLER' AND start_date=2008-11-24;

Options:

A . All columns

B . Only those columns which are mention with SELECT" clause

C . Columns mention with SELECT" clause and only those rows which contain 'HEAD TELLER' as a title" and start_date as 2008-11-24

D . None of the mentioned

Answer: Option B

"WHERE clause is used to filter out unwanted rows and "SELECT clause is used to select columns from table.

Was this answer helpful ?

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

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