Tutorial 1, page 3 Context: jobsEngine: oracle

Each table in the database has a number of columns. These columns are known as attributes. To list attributes you use the SELECT command, listing all the attribute you are interested in (separated by commas) followed by FROM and then the name of the table. For instance, listing the attributes empno and surname from a table called employee would be:

SELECT empno,surname FROM employee;

Notice when you run the SQL the result is shown and then the computer assesses you answer. Make sure it shows 100% correct before trying the next question.

Try listing all course titles (the "cname" attribute) of the table "course".

Active SQL index Previous Question Next Question

SQL To Be Executed