ICT 285 Quiz 01 (assessable) Attempt review | 2025 Update -
Murdoch University.
Status Finished
Started Saturday, 17 May 2025, 3:30 PM
Completed Saturday, 17 May 2025, 3:47 PM
Duration 16 mins 27 secs
Marks 13.00/15.00
Grade 86.67 out of 100.00
Question 1
Correct
Mark 1.00 out of 1.00
When you log in to Rhea.ad.murdoch.edu.au using SSH, your user name is:
Select one:
a. username@murdoch
b. V(followed by your student number)
c. putty
d. Your student number CORRECT
Please see Section 1 of Lab 01.
The correct answer is: Your student number
Question 2
Correct
Mark 1.00 out of 1.00
The very first time you log in to SQLPlus on Rhea.murdoch.edu.au, your password is:
Select one:
a. Your student number
b. The same as your SQL user name CORRECT
c. Your MyInfo password
d. oracle_u
See Section 1.0 "Logging into Oracle SQLPlus..."
The correct answer is: The same as your SQL user name
, Question 3
Correct
Mark 1.00 out of 1.00
In Lab 01, why does the command ‘SELECT * FROM Artist;’ not work?
Select one:
a. There isn't a There is a table called Artist, you just don't have SELECT privileges for it. But it's a bit ambiguous as this answer
table in the is implied by the error message you get in the lab (Table or view does not exist), so I'll mark it correct as well.
database But remember that this particular error message often implies a lack of privileges.
called Artist
b. There is an error in the syntax
c. The table name should be in capital letters
d. I don't have select privileges for a table called artist
See Section 2 of Lab 01.
The correct answers are: There isn't a table in the database called Artist, I don't have select privileges for a table called artist
Question 4
Correct
Mark 1.00 out of 1.00
What SQL command would you execute in Oracle to show the structure of a table called Workshop?
Select one:
a. DESCRIBE Workshop; CORRECT
b. SHOW Workshop;
c. DEMONSTRATE Workshop;
d. SELECT * FROM Workshop;
See Section 4 of Lab 01
The correct answer is: DESCRIBE Workshop;
Murdoch University.
Status Finished
Started Saturday, 17 May 2025, 3:30 PM
Completed Saturday, 17 May 2025, 3:47 PM
Duration 16 mins 27 secs
Marks 13.00/15.00
Grade 86.67 out of 100.00
Question 1
Correct
Mark 1.00 out of 1.00
When you log in to Rhea.ad.murdoch.edu.au using SSH, your user name is:
Select one:
a. username@murdoch
b. V(followed by your student number)
c. putty
d. Your student number CORRECT
Please see Section 1 of Lab 01.
The correct answer is: Your student number
Question 2
Correct
Mark 1.00 out of 1.00
The very first time you log in to SQLPlus on Rhea.murdoch.edu.au, your password is:
Select one:
a. Your student number
b. The same as your SQL user name CORRECT
c. Your MyInfo password
d. oracle_u
See Section 1.0 "Logging into Oracle SQLPlus..."
The correct answer is: The same as your SQL user name
, Question 3
Correct
Mark 1.00 out of 1.00
In Lab 01, why does the command ‘SELECT * FROM Artist;’ not work?
Select one:
a. There isn't a There is a table called Artist, you just don't have SELECT privileges for it. But it's a bit ambiguous as this answer
table in the is implied by the error message you get in the lab (Table or view does not exist), so I'll mark it correct as well.
database But remember that this particular error message often implies a lack of privileges.
called Artist
b. There is an error in the syntax
c. The table name should be in capital letters
d. I don't have select privileges for a table called artist
See Section 2 of Lab 01.
The correct answers are: There isn't a table in the database called Artist, I don't have select privileges for a table called artist
Question 4
Correct
Mark 1.00 out of 1.00
What SQL command would you execute in Oracle to show the structure of a table called Workshop?
Select one:
a. DESCRIBE Workshop; CORRECT
b. SHOW Workshop;
c. DEMONSTRATE Workshop;
d. SELECT * FROM Workshop;
See Section 4 of Lab 01
The correct answer is: DESCRIBE Workshop;
