Murdoch University ICT285 ALL Quiz + Answers| All Answers Correct
80 views 0 purchase
Course
ICT285 ALL Quiz + Answers
Institution
ICT285 ALL Quiz + Answers
When you log in to using SSH, your user name is:
Select one:
a. dtoohey
b. V(followed by your student number)
c. 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...
your user name is select one a dtoohey b vfollowed by your student number c putty d your student number correct fee
Written for
ICT285 ALL Quiz + Answers
All documents for this subject (1)
Seller
Follow
Examhack
Reviews received
Content preview
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. 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Examhack. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
