Which of the following is illegal?(a) SELECT SYSDATE – SYSDATE FROM DUAL;(b) SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;(c) SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;(d) None of the MentionedThe question was asked in my homework.The above asked question is from Structured Query Language in section SQL Basics of Oracle

Which of the following is illegal?(a) SELECT SYSDATE – SYSDATE FROM

1.	Which of the following is illegal?(a) SELECT SYSDATE – SYSDATE FROM DUAL;(b) SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;(c) SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;(d) None of the MentionedThe question was asked in my homework.The above asked question is from Structured Query Language in section SQL Basics of Oracle
Answer» Right answer is (d) None of the Mentioned The BEST explanation: SELECT SYSDATE – SYSDATE FROM DUAL; outputs 0 SELECT SYSDATE – (SYSDATE – 2) FROM DUAL; outputs 2 SELECT SYSDATE – (SYSDATE + 2) FROM DUAL; outputs -2.

Discussion

No Comment Found

Related InterviewSolutions

_________commands in SQL allow controlling access to data within database.(a) Database(b) Data(c) Data control(d) All of the MentionedThe question was asked by my college professor while I was bunking the class.I want to ask this question from DCL,TCL Command topic in division SQL Basics of Oracle
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________(a) DCL(b) DML(c) DDL(d) All of the MentionedThis question was posed to me in a job interview.This question is from DCL,TCL Command in division SQL Basics of Oracle
To obtain the structure of an Oracle table, the command to use is:(a) STRUCTURE [TableName].(b) DESCRIBE [TableName].(c) DESCRIBE STRUCTURE [TableName].(d) DESC TABLE [TableName].The question was posed to me in class test.My query is from DCL,TCL Command in section SQL Basics of Oracle
The Database Language That Allows You To Access Or Maintain Data In A Database(a) DCL(b) DML(c) DDL(d) All of the MentionedThe question was asked in class test.I'm obligated to ask this question of DCL,TCL Command topic in portion SQL Basics of Oracle
A transaction completes its execution is said to be(a) Committed(b) Aborted(c) Rolled back(d) FailedThe question was posed to me in semester exam.This intriguing question originated from DCL,TCL Command topic in division SQL Basics of Oracle
Which of the following keyword is used with Data Control Language (DCL) statements?(a) SELECT(b) INSERT(c) DELETE(d) GRANTI have been asked this question in an online interview.This key question is from DCL,TCL Command in chapter SQL Basics of Oracle
DCL Provides Commands To Perform Actions Like _____________(a) Change The Structure Of Tables(b) Insert, Update Or Delete Records And Data Values(c) Authorizing Access And Other Control Over Database(d) None of the MentionedThe question was asked in my homework.This intriguing question comes from DCL,TCL Command in portion SQL Basics of Oracle
In an SQL statement, which of the following parts states the conditions for row selection?(a) Where(b) From(c) Order By(d) Group ByThis question was addressed to me in final exam.I would like to ask this question from DCL,TCL Command topic in chapter SQL Basics of Oracle
A type of query that is placed within a WHERE or HAVING clause of another query is called(a) Master query(b) Sub query(c) Super query(d) Multi-queryI had been asked this question in a job interview.This is a very interesting question from DML Command in chapter SQL Basics of Oracle
TCL stands for:(a) Transaction control languages(b) Transaction command languages(c) Transaction connect languages(d) None of the MentionedThis question was posed to me in an online quiz.My question is based upon DCL,TCL Command in section SQL Basics of Oracle

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment