Using SQL in models

Question 1

SQL is preferred over graphical modeling?

Answer 1

False, graphical modeling should be used whenever possible

Question 2

What’s the difference between DDL, DML, DCL?

Answer 2

DDL is the language for creating and maintaining database objects
DML is the language to create and maintain data
DCL is the language to control data access

Question 3

Where is SQL console launched from?

Answer 3

WEB IDE

Question 4

What are two ways of adding comments in the SQL console?

Answer 4

-- (everything after the double hyphen
/*
everything between /* and */ is a comment
*/

Question 5

What does the SOME comparison predicate do?

Answer 5

I have no idea?

Question 6

Is DAYS_BETWEEN a valid command in open SQL

Answer 6

I don’t know?

Question 7

Which of the following can be used in open sql?

ADD_DAYS, ADD_MONTHS, ADD_YEARS, DAYNAME

Answer 7

I don’t now