5 Replies - 2865 Views - Last Post: 01 March 2013 - 10:50 AM Rate Topic: -----

#1 k.s110  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 60
  • Joined: 13-February 13

DBMS question

Posted 25 February 2013 - 06:16 PM

I think the answer is C because the syntax for WHERE suggests :

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

therefore WHERE Author = "Lucas Bailey"

would notify any members which have read her book.

seems like the answer..

Posted Image

Uploaded with ImageShack.us

Is This A Good Question/Topic? 0
  • +

Replies To: DBMS question

#2 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 795
  • View blog
  • Posts: 1,681
  • Joined: 30-January 09

Re: DBMS question

Posted 25 February 2013 - 06:56 PM

C is indeed the correct answer, but are you able to say why A, B and D are incorrect? Each of them has a syntax issue that would cause an error.
Was This Post Helpful? 0
  • +
  • -

#3 B12-DBA  Icon User is offline

  • New D.I.C Head

Reputation: -2
  • View blog
  • Posts: 5
  • Joined: 22-February 13

Re: DBMS question

Posted 28 February 2013 - 04:49 PM

The answer is "A" because all the three tables must be used to meet the librarian needs.
Was This Post Helpful? -2
  • +
  • -

#4 andrewsw  Icon User is online

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3526
  • View blog
  • Posts: 12,037
  • Joined: 12-December 12

Re: DBMS question

Posted 28 February 2013 - 04:57 PM

View PostB12-DBA, on 28 February 2013 - 04:49 PM, said:

The answer is "A" because all the three tables must be used to meet the librarian needs.

No it is not, because A is not a valid part of a SQL statement. Yes, all three tables are needed, but that is NOT the question.
Was This Post Helpful? 0
  • +
  • -

#5 B12-DBA  Icon User is offline

  • New D.I.C Head

Reputation: -2
  • View blog
  • Posts: 5
  • Joined: 22-February 13

Re: DBMS question

Posted 28 February 2013 - 06:43 PM

View Postandrewsw, on 28 February 2013 - 04:57 PM, said:

View PostB12-DBA, on 28 February 2013 - 04:49 PM, said:

The answer is "A" because all the three tables must be used to meet the librarian needs.

No it is not, because A is not a valid part of a SQL statement. Yes, all three tables are needed, but that is NOT the question.

Quote

I don't know why it's not a valid SQL statement

Was This Post Helpful? 0
  • +
  • -

#6 mojo666  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 352
  • View blog
  • Posts: 771
  • Joined: 27-June 09

Re: DBMS question

Posted 01 March 2013 - 10:50 AM

Compare the tables listed in "A" to the tables in the question.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1