Murdoch University ICT285 ALL Quiz + Answers| All Answers Correct

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 text The very first time you log in to SQLPlus on , 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 textIn 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.00Question 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 . 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.00Question text You need to create a column in a table that will store numbers in the form (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 textData models have the following features: Select one: a. Structure, operators, constraints CORRECT b. Entity integrity, referential integrity, domain integrity c. Relations, attributes, tuples d. Relational algebra, relational calculus, SQL Feedback The correct answer is: Structure, operators, constraints Question 10 Incorrect Mark 0.00 out of 1.00 Question text MyInfo is an example of a(n ): Select one: a. Application Program b. Database c. Database Management System (DBMS) See Kroenke p. 40 'The components of a database system' d. Database System Feedback See Kroenke p. 40 'The components of a database system' The correct answer is: Application Program Question 11 Correct Mark 1.00 out of 1.00 Question text The relational model ___________ . Select one:a. was first proposed in the late 1960's/early 1970's b. was developed by E.F Codd c. was developed at IBM d. resulted in the DBMS product, DB2 e. All of the above. CORRECT Feedback Page 55 of the text, 'The Emergence and Dominance of the Relational Model' The correct answer is: All of the above. Question 12 Correct Mark 1.00 out of 1.00 Question text Logical data independence means: Select one: a. Being able to make changes at the internal level without affecting the external level b. Being able to make changes to the conceptual schema without affecting the internal level c. Being able to make changes at the conceptual level without affecting the external level d. Being able to make changes at the external level without affecting the internal level Feedback Your answer is correct. The correct answer is: Being able to make changes at the conceptual level without affecting the external level Question 13 Correct Mark 1.00 out of 1.00 Question text Physical data independence means:Select one: a. Being able to make changes at the internal level without affecting the conceptual level b. Being able to make changes at the conceptual level without affecting the external level c. Being able to make changes at the external level without affecting the conceptual level d. Being able to make changes at the conceptual level without affecting the internal level Feedback Your answer is correct. The correct answer is: Being able to make changes at the internal level without affecting the conceptual level Question 14 Correct Mark 1.00 out of 1.00 Question text An example of physical independence would be: Select one: a. Adding an application to an existing database b. Adding an index to an existing database c. Adding a table to an existing database d. Adding a record to an existing database Feedback Your answer is correct. The correct answer is: Adding an index to an existing database Question 15 Incorrect Mark 0.00 out of 1.00 Question text Which of the following is not a database administration responsibility of a DBA? Select one: a. Managing the database structureb. Managing data activity c. Managing the DBMS d. Maintaining the data dictionary e. All of the above are database administration responsibilities of a DBA. Feedback The correct answer is: All of the above are database administration responsibilities of a DBA. Quiz 2 In the relational database terminology, a table is synonymous with: Select one: a. A column b. A row c. An attribute d. A relation CORRECT Feedback See the section RM Concepts in the Topic 01 lecture slides The correct answer is: A relation Question 2