Soal UAS
Bagian I
1. Tulis Hierarchical Query untuk menampilkan bagan organisasi dari table employees. Pastikan query dimulai dari employee yang tidak memiliki manager. Tampilkan level, first name dan last name dari employee dan last name managernya.
2. Tulis query yang dapat menampilkan department_id, job_id dan total salary untuk setiap job_id di dalam department. Buat query yang mengembalikan subtotal dari salary tiap department_id dan grand total untuk semua salary dalam perusahaan. Gunakan table employees untuk query ini.
3. Tulis sebuah query yang dapat mengembalikan kolom-kolom: employee first dan last_name, department_id, job_id, and salary dari table employee, employee_id, start_date, end_date, and job_id dari tabel job_history dan department_name dan location_id dari tabel department.
4. Buat query untuk menampilkan country_name dari employee yang job_idnya adalah “IT_PROG”
5. Buat query untuk menampilkan nama departemen dan kota dari departemennya.
Bagian I
1. Tulis Hierarchical Query untuk menampilkan bagan organisasi dari table employees. Pastikan query dimulai dari employee yang tidak memiliki manager. Tampilkan level, first name dan last name dari employee dan last name managernya.
2. Tulis query yang dapat menampilkan department_id, job_id dan total salary untuk setiap job_id di dalam department. Buat query yang mengembalikan subtotal dari salary tiap department_id dan grand total untuk semua salary dalam perusahaan. Gunakan table employees untuk query ini.
3. Tulis sebuah query yang dapat mengembalikan kolom-kolom: employee first dan last_name, department_id, job_id, and salary dari table employee, employee_id, start_date, end_date, and job_id dari tabel job_history dan department_name dan location_id dari tabel department.
4. Buat query untuk menampilkan country_name dari employee yang job_idnya adalah “IT_PROG”
5. Buat query untuk menampilkan nama departemen dan kota dari departemennya.
Section 6 Quiz Database Design Oracle dan Section 1 Quiz Database Design Oracle
The normalize() method removes extraneous elements from a qualified path. True or false?
True (*)
False
A specialized type of software, which controls and manages the hardware in a computer system. Mark for Review
(1) Points
Operating System (*)
Hardware
Software
Client
The Files class lets you check for file properties. True or false?
True (*)
False
Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points
True
False (*)
The read() method lets you read a character at a time. True or false? Mark for Review
True (*)
False
The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. Mark for Review
(1) Points
True
False (*)
Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT ORDER
ATTRIBUTES:
# CLIENT ID
# ORDER ID
FIRST NAME
LAST NAME
ORDER DATE
CITY
ZIP CODE
Mark for Review
(1) Points
1st Normal Form.
2nd Normal Form. (*)
3rd Normal Form.
None of the above, the entity is fully normalised.
A candidate UID that is not chosen to be the Primary UID is called: Mark for Review
(1) Points
Composite
Secondary (*)
Simple
Artificial
Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
(1) Points
(Choose all correct answers)
GUI software (*)
Internet Browser software (*)
Operating System software (*)
Server software
Java 7 requires you create an instance of java.io.File class. True or false? Mark for Review
True
False (*)
What is the rule of Second Normal Form? Mark for Review
(1) Points
No non-UID attributes can be dependent on any part of the UID.
Some non-UID attributes can be dependent on the entire UID.
All non-UID attributes must be dependent upon the entire UID. (*)
None of the above
Software cannot operate without Hardware. True or False? Mark for Review
(1) Points
True (*)
False
Prior to Java 7, you write to a file with a call to the BufferedWriter class's write() method. True or false? Mark for Review
True (*)
False
Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information? Mark for Review
(1) Points
Data
Information (*)
Both
Neither
Information which was gained from data is the same as: (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Intelligence (*)
There is no difference between data and information.
Raw Materials
Knowledge (*)
A serialized class implements which interface? Mark for Review
Serializing
Serialized
Serializer
SerializedObject
Serializable (*)
Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information? Mark for Review
(1) Points
Data (*)
Information
Both
Neither
Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:
ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE
Mark for Review
(1) Points
STORE LOCATION (*)
CUSTOMER ID
DATE
STORE ID
An OutputInputStream lets you read a serialized object. True or false? Mark for Review
True
False (*)
Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False? Mark for Review
(1) Points
True (*)
False
If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: Mark for Review
(1) Points
Do nothing, an entity does not have to be in 1st Normal Form
Create an additional entity and relate it to the original entity with a M:M relationship.
Make the attribute optional
Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False? Mark for Review
(1) Points
True (*)
False
What is the definition of a logic error? Mark for Review
Wrong syntax that will be caught at compile time.
Bugs in code that make your program run different than expected (*)
Computer malfunction that makes your code run incorrectly.
Something that causes your computer to crash.
When is an entity in 2nd Normal Form? Mark for Review
(1) Points
When all non-UID attributes are dependent upon the entire UID. (*)
When attributes with repeating or multi-values are present.
When no attritibutes are mutually independent and all are fully dependent on the primary key.
None of the Above.
An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review
(1) Points
True
False (*)
SQL became the most commonly used query language in the 1980s. True or False? Mark for Review
(1) Points
True (*)
False
When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: Mark for Review
(1) Points
Non-dependency
Functional dependency
Dependency
Transitive dependency (*)
Is this the correct syntax for catching an exception?
Try(inputStream = "missingfile.txt"); Catch(exception e);
True or false?
True
False (*)
Which of the following represents the correct sequence of steps in the Database Development Process? Mark for Review
(1) Points
Design, Build, Analyze
Analyze, Build, Design
Analyze, Design, Build (*)
Build, Analyze, Design
Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
ORDER ID
STREET
ZIP CODE
Mark for Review
(1) Points
1st Normal Form. (*)
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised.
The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False? Mark for Review
(1) Points
True (*)
False
Multiple catch statements can be used for a single try statement.
True or false? Mark for Review
True (*)
False
The main subject areas taught by the Oracle Academy are: Mark for Review
(1) Points
Systems programming and computer architecture
Database performance tuning
Computer Repairs
Data Modeling, SQL, and PL/SQL (*)
Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
STREET
CITY
ZIP CODE
Mark for Review
(1) Points
1st Normal Form.
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised. (*)
The demand for Information Technology professionals in today's market is increasing. True or False? Mark for Review
(1) Points
True (*)
False
When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
(1) Points
Reduction
Multiplication
Normalization (*)
Normality
The demand for Information Technology professionals in today's market is increasing. True or False? Mark for Review
(1) Points
True (*)
False
A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. Mark for Review
(1) Points
True (*)
False
The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False? Mark for Review
(1) Points
True (*)
False
When will a finally statement be executed? Mark for Review
Only if an exception is thrown.
Only if an exception is not thrown.
Always; no matter if an exception is thrown or not. (*)
Only if multiple exceptions are caught and thrown.
Never; it is there for visual purposes.
Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? Mark for Review
(1) Points
True (*)
False
Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review
(1) Points
False. Business requirements can and will change. For instance new legal requirements may arise. (*)
True. Users delay the delivery of a system by changing their minds and adding new requirements.
True. The only requirement for creating a perfect system is a perfect programmer.
True. Users never know what they want anyway, so building systems is best left to the professionals.
To resolve a 2nd Normal Form violation, we: Mark for Review
(1) Points
Do nothing, an entity does not need to be in 2nd Normal Form.
Delete the attribute that was causing the violation.
Move the attribute that violates 2nd Normal Form to a new ERD.
Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: Mark for Review
(1) Points
Make the attribute optional
Do nothing, an entity does not have to be in 1st Normal Form
Create an additional entity and relate it to the original entity with a M:M relationship.
Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
What is special about including a resource in a try statement? Mark for Review
(Choose all correct answers)
The resources will auto-close. (*)
The program will fail if the resource does not open.
An error will be thrown if the resources does not open. (*)
In the grid computing model, resources are pooled together for efficiency. True or False? Mark for Review
(1) Points
True (*)
False
When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
(1) Points
Multiplication
Normality
Reduction
Normalization (*)
Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
(1) Points
(Choose all correct answers)
Operating System software (*)
Server software
GUI software (*)
Internet Browser software (*)
Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
STREET
CITY
ZIP CODE
Mark for Review
(1) Points
1st Normal Form.
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised. (*)
A specialized type of software, which controls and manages the hardware in a computer system. Mark for Review
Software
Hardware
Operating System (*)
Client
An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False? Mark for Review
(1) Points
True
False (*)
Software cannot operate without Hardware. True or False? Mark for Review
(1) Points
True (*)
False
Any Non-UID attribute must be dependent upon the entire UID. True or False?
Mark for Review
(1) Points
True (*)
False
The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. Mark for Review
(1) Points
True
False (*)
When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: Mark for Review
(1) Points
Functional dependency
Dependency
Transitive dependency (*)
Non-dependency
Information which was gained from data is the same as: (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Knowledge (*)
There is no difference between data and information.
Intelligence (*)
Raw Materials
Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? Mark for Review
(1) Points
True (*)
False
Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information? Mark for Review
(1) Points
Data (*)
Information
Both
Neither
As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False? Mark for Review
(1) Points
True
False (*)
Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information? Mark for Review
(1) Points
Data
Information (*)
Both
Neither
A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. Mark for Review
(1) Points
True (*)
False
When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: Mark for Review
(1) Points
Transitive dependency (*)
Functional dependency
Dependency
Non-dependency
The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. True or False? Mark for Review
(1) Points
True (*)
False
Every time you shop online, it is likely you will be accessing a database. True or False? Mark for Review
(1) Points
True (*)
False
A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. Mark for Review
(1) Points
True (*)
False
There is no limit to how many columns can make up an entity's UID. True or False? Mark for Review
(1) Points
True (*)
False
Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False? Mark for Review
(1) Points
True (*)
False
The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False? Mark for Review
True (*)
False
Every time you shop online, it is likely you will be accessing a database. True or False? Mark for Review
(1) Points
True (*)
False
SQL became the most commonly used query language in the 1980s. True or False? Mark for Review
(1) Points
True (*)
False
Data Modeling is the last step in the database development process. True or False? Mark for Review
(1) Points
True
False (*)
Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points
True
False (*)
An entity can only have one Primary UID. True or False? Mark for Review
(1) Points
True (*)
False
Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement, and Distribution? True or False? Mark for Review
(1) Points
True (*)
False
When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
(1) Points
Reduction
Normality
Multiplication
Normalization (*)
What is the difference between "information" and "data"? Mark for Review
(1) Points
Information is held and understood only by users.
Data is held and understood only by users.
Information and data have no differences - they are two words for the same thing.
Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False? Mark for Review
(1) Points
True (*)
False
The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs. Mark for Review
(1) Points
Yes, this is the way UID's are named. (*)
No, each Entity can only have one UID, the secondary one.
No, it is not possible to have more than one UID for an Entity.
No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
Oracle was one of the first relational database systems available commercially. True or False? Mark for Review
(1) Points
True (*)
False
Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information? Mark for Review
(1) Points
Data
Information (*)
Both
Neither
If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False? Mark for Review
(1) Points
True (*)
False
Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review
True. The only requirement for creating a perfect system is a perfect programmer.
True. Users never know what they want anyway, so building systems is best left to the professionals.
False. Business requirements can and will change. For instance new legal requirements may arise. (*)
True. Users delay the delivery of a system by changing their minds and adding new requirements.
Information which was gained from data is the same as: (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Knowledge (*)
There is no difference between data and information.
Intelligence (*)
Raw Materials
1. The main subject areas taught by the Oracle Academy are: Mark for Review
(1) Points
Computer Repairs
Systems programming and computer architecture
Database performance tuning
Data Modeling, SQL, and PL/SQL (*)
2. Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review
(1) Points
True. Users never know what they want anyway, so building systems is best left to the professionals.
False. Business requirements can and will change. For instance new legal requirements may arise. (*)
True. Users delay the delivery of a system by changing their minds and adding new requirements.
True. The only requirement for creating a perfect system is a perfect programmer.
3. The demand for Information Technology professionals in today's market is increasing. True or False? Mark for Review
(1) Points
True (*)
False
4. Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information? Mark for Review
(1) Points
Data (*)
Information
Both
Neither
5. Which of the following are examples of data becoming information: Mark for Review
(1) Points
A. Student age -> average age of all students in class
B. Bank deposit amount -> total account balance
C. Winning time for a race -> length of race
D. Price of a computer -> total sales of all computers for a company
E. A, B, and D (*)
6. What is the difference between "information" and "data"? Mark for Review
(1) Points
Information and data have no differences - they are two words for the same thing.
Data is held and understood only by users.
Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
Information is held and understood only by users.
A unique identifier can only be made up of one attribute. True or False? Mark for Review
(1) Points
True
False (*)
Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs. Mark for Review
(1) Points
Composite
Simple
Secondary
Candidate (*)
The main subject areas taught by the Oracle Academy are: Mark for Review
(1) Points
Data Modeling, SQL, and PL/SQL (*)
Systems programming and computer architecture
Computer Repairs
Database performance tuning
When all attributes are single-valued, the database model is said to conform to: Mark for Review
(1) Points
2nd Normal Form
4th Normal Form
1st Normal Form (*)
3rd Normal Form
The demand for Information Technology professionals in today's market is increasing. True or False? Mark for Review
(1) Points
True (*)
False
If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: Mark for Review
(1) Points
Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
Make the attribute optional
Create an additional entity and relate it to the original entity with a M:M relationship.
Do nothing, an entity does not have to be in 1st Normal Form
Which term describes the physical components of a computer system? Mark for Review
(1) Points
Hardware (*)
Operating System
Software
Client
Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Address
Employee ID (*)
Social Security Number (*)
Last Name
Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.
In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.
In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.
Mark for Review
(1) Points
No
Yes (*)
When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
(1) Points
Reduction
Normality
Multiplication
Normalization (*)
Which of the following represents the correct sequence of steps in the Database Development Process? Mark for Review
(1) Points
Analyze, Build, Design
Design, Build, Analyze
Build, Analyze, Design
Analyze, Design, Build (*)
8. Entities are transformed into Tables during the Database Design process. True or False? Mark for Review
(1) Points
True (*)
False
9. Every time you shop online, it is likely you will be accessing a database. True or False? Mark for Review
(1) Points
True (*)
False
10. Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False? Mark for Review
(1) Points
True (*)
False
11. Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points
True
False (*)
Which of the following are examples of e-businesses that use database software? Mark for Review
(1) Points
(Choose all correct answers)
Online research paper
Online clothing store (*)
Online personal web page
Online book store (*)
Online personal shopping service (*)
Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False? Mark for Review
(1) Points
True (*)
False
5. Every time you shop online, it is likely you will be accessing a database. True or False? Mark for Review
(1) Points
True (*)
False
6. Oracle was one of the first relational database systems available commercially. True or False? Mark for Review
(1) Points
True (*)
False
7. Most of the well known Internet search engines use databases to store data. True or False? Mark for Review
(1) Points
True (*)
False
Any Non-UID attribute must be dependent upon the entire UID. True or False? Mark for Review
(1) Points
True (*)
False
What is the rule of Second Normal Form? Mark for Review
(1) Points
No non-UID attributes can be dependent on any part of the UID.
Some non-UID attributes can be dependent on the entire UID.
All non-UID attributes must be dependent upon the entire UID. (*)
None of the above
Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE
Mark for Review
(1) Points
Do nothing, it is already in 2nd Normal Form.
Delete the attribute STORE ID
Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
To convert an entity with a multi valued attribute to 1st Normal Form, we create an additional entity and relate it to the original entity with a 1:1 relationship. True or False? Mark for Review
(1) Points
True
False (*)
Software cannot operate without Hardware. True or False? Mark for Review
(1) Points
True (*)
False
15. The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. Mark for Review
(1) Points
True
False (*)
Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review
(1) Points
True. Users delay the delivery of a system by changing their minds and adding new requirements.
False. Business requirements can and will change. For instance new legal requirements may arise. (*)
True. The only requirement for creating a perfect system is a perfect programmer.
True. Users never know what they want anyway, so building systems is best left to the professionals.
9. The main subject areas taught by the Oracle Academy are: Mark for Review
(1) Points
Data Modeling, SQL, and PL/SQL (*)
Database performance tuning
Computer Repairs
Systems programming and computer architecture
10. The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False? Mark for Review
(1) Points
True (*)
False
11. Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.
In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.
In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.
Mark for Review
(1) Points
No
Yes (*)
12. In the grid computing model, resources are pooled together for efficiency. True or False? Mark for Review
(1) Points
True (*)
False
13. Which of the following are examples of e-businesses that use database software? Mark for Review
(1) Points
(Choose all correct answers)
Online personal web page
Online clothing store (*)
Online personal shopping service (*)
Online research paper
Online book store (*)
Software cannot operate without Hardware. True or False? Mark for Review
(1) Points
True (*)
False
13. In the grid computing model, resources are pooled together for efficiency. True or False? Mark for Review
(1) Points
True (*)
False
14. Which of the following are examples of e-businesses that use database software? Mark for Review
(1) Points
(Choose all correct answers)
Online personal shopping service (*)
Online personal web page
Online clothing store (*)
Online research paper
Online book store (*)
Any Non-UID attribute must be dependent upon the entire UID. True or False? Mark for Review
(1) Points
True (*)
False
An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False? Mark for Review
(1) Points
True
False (*)
An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review
(1) Points
True
False (*)
Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Social Security Number (*)
Last Name
Employee ID (*)
Address
Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? Mark for Review
(1) Points
True (*)
False
A unique identifier can only be made up of one attribute. True or False? Mark for Review
(1) Points
True
False (*)
There is no limit to how many columns can make up an entity's UID. True or False? Mark for Review
(1) Points
True (*)
False
Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
(1) Points
(Choose all correct answers)
Internet Browser software (*)
Server software
GUI software (*)
Operating System software (*)
1. What is the difference between "information" and "data"? Mark for Review
(1) Points
Information is held and understood only by users.
Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
Data is held and understood only by users.
Information and data have no differences - they are two words for the same thing.
2. How do you turn "data" into "information"? Mark for Review
(1) Points
By testing it
By storing it on a server
By storing it in a database
By querying it or accessing it (*)
3. Which of the following are examples of data becoming information: Mark for Review
(1) Points
A. Student age -> average age of all students in class
B. Bank deposit amount -> total account balance
C. Winning time for a race -> length of race
D. Price of a computer -> total sales of all computers for a company
E. A, B, and D (*)
The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs. Mark for Review
(1) Points
No, it is not possible to have more than one UID for an Entity.
No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
No, each Entity can only have one UID, the secondary one.
Yes, this is the way UID's are named. (*)
If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False? Mark for Review
(1) Points
True (*)
False
A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. Mark for Review
(1) Points
True (*)
False
Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs. Mark for Review
(1) Points
Secondary
Composite
Candidate (*)
Simple
Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
ORDER ID
STREET
ZIP CODE
Mark for Review
(1) Points
1st Normal Form. (*)
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised.
If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False? Mark for Review
(1) Points
True (*)
False
Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
STREET
CITY
ZIP CODE
Mark for Review
(1) Points
1st Normal Form.
2nd Normal Form.
3rd Normal Form.
None of the above, the entity is fully normalised. (*)
No comments:
Post a Comment