Font size
Worksheetsukk oracle database foundation
Total questions: 20
Worksheet time: 40mins
What is the name used for a database object such as a table or index that has its own space allocated in a tablespace in an Oracle database?
a data file
a segment
an extent
an Oracle database block
an OS data block
At the United Nations (UN), an Entity Relationship Diagram (ERD) was constructed and the MEMBERS and LANGUAGES entities were included.
It was determined that the relationship between these two entities was an M:M relationship because each member in the UN spoke one or more languages, and for each language, there would be one or more members capable of speaking that language. Resolving that M:M relationship involves breaking it down into separate 1:M relationships.
What object can you create to resolve this M:M relationship?
intersection entity
hierarchical entity
union relationship
arc relationship
Examine the structure of the MEMBERS table:
Name
MEMBER ID FIRST NAME LAST_NAME ADDRESS
Null? Type
NOT NULL VARCHAR2(6)
VARCHAR2(50) NOT NULL VARCHAR2(50)
VARCHAR2(50)
12
You execute the SQL statement:
SQL> SELECT member id, ' ', first name, ' ’, last name "ID FIRSTNAME LASTNAME " FROM members;
What is the outcome?
It fails because the space specified in single quotation marks after the first two column names is invalid
It execute successfully and displays the column details in three separate columns and
replaces only the last column heading with the alias.
It fails because the alias name specified after the column names is invalid.
It executes successfully and displays the column details in a single column with only alias column heading.
Two database architectures share the same rules in regard to the relationship between parent and child nodes. Each parent node can have one or more children and each child node must have exactly one parent.
Which are two database architectures?[choose two]
flat file
hierarchical
network
relational
object-oriented
A marketing company wants to do a skill assessment of its employees.
You create a table called EMPLOYEES, which contains all fifteen employees in the marketing company, and another called SKILLS, which contains the twelve most important skills for those employees.
What relationship would be most likely between these two tables?
one-to-one
one-to-many (with the EMPLOYEES table on the many side)
many-to-many
one-to-many (with the SKILLS table on the many side)
In your database, the EMPLOYEE table has a unique EMPLOYEE ID column, which is assigned by the system and generated sequentially.
What do you call this type of unique identifier?
barred primary key
a natural identifier
candidate unique identifier
foreign key identifier
artificial identifier
Which additional criterion must be satisfied to put a table in second normal form to third
normal form?
Each column in every row can contain only a single value or no value at all.
Non-key attributes do not determine the value on any prime attribute
Each row in the table has a unique identifier.
Each non-key attribute depends only on the prime attributes of that table.
Each non-key attribute depends separately on all the attributes that make up the prime attributes.
Which two statements are true about an instance of an entities and their attributes?[choose two]
The relationship between entities is transformed into a primary-key column.
An instance is a single occurrence of an entity.
An attribute is transformed into a column of a table.
A relational database schema cannot be modified.
A relational database can contain only single instance of any entity.
Which term relates to a row in a relational database table?
an attribute
a relationship
an instance
an entity
In an inventory application, the PART NUMBER column is the primary key for the PARTS table.
What two constraints are placed on the PART NUMBER column for any rows inserted into or updated in the PARTS table?choose two]
UNIQUE CONSTRAINT
CHECK CONSTRAINT
COMPOSITE PRIMARY KEY CONSTRAINT
NOT NULL CONSTRAINT
FOREIGN KEY CONSTRAINT
Which two goals are associated with Entity Relationship diagramming?[choose two]
Identify NOT NULL columns.
Identify unique columns
Eliminate redundancy
Identify a primary key.
Locate data in a logical place.
Which three statements are true about relational database?[choose three]
All database information is stored in one table.
They provide multi-user accessi ty.
Columns of different data type cannot be compared in a SQL statement.
They provide the possi ty of defining primary keys to unique identify rows.
Indexes may be created for quicker data retrieval
Which statement is true regarding data modelling?
The entities and their attributes from the logical model are converted into columns and
rows in the physical model.
The entities and their attributes from the logical model are converted into tables and columns in the physical model.
The entities and their tables from the logical model are converted into tables and columns in the physical model.
The entities and their columns from the physical model are converted into tables and
attributes in the logical model.
John is a customer of Glenridge Bank whose last name is easy to misspell.
His last name is spelled differently on statements for two different accounts and in another way on promotional mall.
What is the likely cause of the different spellings of John's last name?
The lack of a primary key constraint on the accounts table is causing this.
The spellings of other customer's names are similar to that of John's name.
There is no referential integrity defined for the database.
John's last name is stored separately for different accounts and different banking
applications.
For which two requirements should you use a physical data model?[choose two]
to create relationship between existing entities including the cardinality.
to convert a logical data model into an Entity Relationship Diagram.
to convert a relational data model into a logical data model.
to describe the implementation of entities, relationships, and other required objects in a specific RDBMS product
to convert existing entities, attributes, and relationships into tables, columns, and constraints, respectively
The enforcement of which business rule requires coding in a relational database?
The quantity ordered must be a whole number.
The quantity ordered must be a positive number
The quantity ordered cannot exceed the quantity in stock.
The quantity ordered cannot be greater than 99.
In an Entity Relationship Diagram (ERD), an entity will become a and an attribute will become a
relationship, column
table, column
column, table
table, relationship
The BOOKS TRANSACTIONS table exists in your database.
Examine the SQL statement:
SQL> SELECT * FROM books transactions ORDER BY 3;
What is the outcome on execution?
Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.
Rows are displayed in the order that they are stored in the table only for the first three rows.
The execution fails unless the numerical 3 in the ORDER BY clause is replaced by a
column name.
Rows are displayed sorted in ascending order of the values in the third column in the table.
Which symbol will appear in front of the names of mandatory attributes in an Entity Relationship Diagram (ERD)?
#
-
0
*
The CUSTOMERS entity uses an arbitrarily assigned number for the account number for a new customer.
How would this account number be described?
a candidate unique identifier
a composite unique identifier
a business rule unique identifier
an artificial unique identifier
