Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Books tables, evaluate the following SELECT statement: Books Tables ISBN BOOK TITLE LANGUAGE NUMBER OF PAGES PUBLISHER_NAME AUTHER_NAME PUBLISH_DATE PRICE 28564 The Stranger Fransh

image text in transcribed

Using Books tables, evaluate the following SELECT statement: Books Tables ISBN BOOK TITLE LANGUAGE NUMBER OF PAGES PUBLISHER_NAME AUTHER_NAME PUBLISH_DATE PRICE 28564 The Stranger Fransh 123 Vintage International Albert Camus 28-Mar-1989 7.3 20154 Big Data English 352 Prentic Hall Batric Henrik 11-Sep-2002 10-May-2011 97861 100 ways for him Arabic 178 Dar Al-Fiker Ali Al-Hamadi 10 97877 100 ways for her Arabic 170 Dar Al-Fiker Ali Al-Hamadi 05-Jul-2012 10 97899 9 secrets of memorizing Quran Arabic 182 Alwataniya Maji Obaid 01-Jan-1970 5 97803 Introduction To Database Systems English 254 Microsoft Corporation Desai, Bipin c 12-Apr-2000 8.5 1318 Mastering MATLAB 7 English 544 Prentic Hall Hanselman, Duane C 19-Dec-2005 19.4 what will be the output of the SELECT statements? 1- SELECT instr(book_title, 'D') FROM books WHERE price is null; Answer: 2- SELECT length (book_title) FROM books WHERE price 10; Answer: 5- SELECT NVL2 (number_of_pages, price, 0) FROM books WHERE ISBN = 1318

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

More Books

Students also viewed these Databases questions