Quiz 1
When you log in to arion.murdoch.edu.au using SSH, your user name is:
Select one:
a. dtoohey
b. V(followed by your student number)
c.
... [Show More] putty
d. Your student number
CORRECT
Feedback
Please see Section 1 of Lab 01.
The correct answer is: Your student number
Question 2
Incorrect
Mark 0.00 out of 1.00
Question text
The very first time you log in to SQLPlus on arion.murdoch.edu.au, your password is:
Select one:
a. Your student number
b. The same as your SQL user name
c. Your MyInfo password
No. It is your student number prefixed with a V
d. oracle_u
Feedback
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
Question text
In Lab 01, why does the command ‘SELECT * FROM Artist;’ not work?
Select one:
a. There isn't a table in the database called Artist
There is a table called Artist, you just don't have SELECT privileges for it. But it's a bit
ambiguous as this answer 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. But remember that this particular error message
often implies a lack of privileges.
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
Feedback
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
Question text
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;
Feedback
See Section 4 of Lab 01
The correct answer is: DESCRIBE Workshop;
Question 5
Correct
Mark 1.00 out of 1.00
Question text
What is the main difference between the Oracle SQL data types VARCHAR2 and CHAR?
Select one:
a. CHAR is variable in length
b. VARCHAR2 is variable in length
CORRECT
c. CHAR allows for numbers and text
d. VARCHAR2 has a maximum length of 255 characters
Feedback
The Oracle VARCHAR2(n ) data type is variable in length and will expand up to a maximum
length of n. The CHAR(n ) data type is fixed in length, meaning that if the value entered is
less than this length, the remainder of the string is padded with blanks.
The correct answer is: VARCHAR2 is variable in length
Question 6
Incorrect
Mark 0.00 out of 1.00
Question text
You need to create a column to store mobile phone numbers, such as 0421 123 345. What
would be the most appropriate data type?
Select one:
a. NUMBER(10)
It is not a number as it has spaces. It also starts with a 0 which would be dropped if it was a
number.
b. VARCHAR2(15)
c. CHAR(10)
d. NUMBER(15)
Feedback
The correct answer is: VARCHAR2(15)
Question 7
Correct
Mark 1.00 out of 1.00
Question text
You need to create a column in a table that will store numbers in the form nnn.xx (e.g.,
145.67) What data type is this?
Select one:
a. NUMBER(5)
b. NUMBER(3,2)
c. FLOAT(3,2)
d. NUMBER(5,2)
CORRECT
Feedback
See Section 5 of Lab 01.
The correct answer is: NUMBER(5,2)
Question 8
Correct
Mark 1.00 out of 1.00
Question text
What do the privileges associated with your role (the STUDENT role) allow you to do?
Select one:
a. Create tables
b. Drop tables
c. Create triggers
d. All of the above
CORRECT
Feedback
See Section 3 of Lab 01
The correct answer is: All of the above
Question 9
Correct
Mark 1.00 out of 1.00
Question text [Show Less]