Other
Oracle Final Exam Semester 1 sql
- Course
- Institution
Oracle Database Final Exam Semester 1 This is a very tough test. these answers make sure that you have at least a sufficient up
[Show more]
Seller
Follow
gunzo
Reviews received
Content preview
Oracle Final Exam Semester 1The text below is an example of what constraint type:
The value in the manager_id column of the EMPLOYEES table must match a value in the
employee_id column in the EMPLOYEES table.
(4) Referential integrity
A table must have at least one candidate key, as well as its primary key. True or False?
(2) False
A table must have a primary key. True or False?
(2) False
If a primary key is a set of columns then one column must be null. True or False?
(2) False
Attributes become tables in a database. True or False?
(2) False
In a physical data model, an attribute becomes a _____________.
(4) Column
The transformation from an ER diagram to a physical design involves changing terminology.
Primary Unique Identifiers in the ER diagram become __________ and relationships become
____________.
(2) Primary keys, Foreign keys
The Oracle Database can implement a many to many relationship. You simply create two
foreign keys between the two tables. True or False?
(2) False
Many to many relationships are implemented via a structure called a: ________________
(2) Intersection Table
An "Arc Implementation" can be done just like any other Relationship - you simply add the
required Foreign Keys. True or False?
(2) False
What command will return data from the database to you?
(3) SELECT
The DESCRIBE command returns all rows from a table. True or False?
(2) False
What command can be used to create a new row in a table in the database?
(4) INSERT
The f_customers table contains the following data:
ID Name Address City State Zip
1 Cole Bee 123 Main Street Orlando FL 32838
, 2 Zoe Twee 1009 Oliver Avenue Boston MA 02116
3 Sandra Lee 22 Main Street Tampa FL 32444
If you run the following statement:
DELETE FROM F_CUSTOMERS WHERE ID <= 2;
How many rows will be left in the table?
(3) 1
The SQL statement ALTER TABLE EMPLOYEES DELETE COLUMN SALARY is a valid
statement. True or False?
(2) False
Systems are always just rolled out as soon as the programming phase is finished. No further
work is required once the development is finished. True or False?
(2) False
System Documentation is developed right at the end once the system has gone live and users
have been using it for a little while. You are more likely to get it correct that way. True or
False?
(2) False
Which SQL statement will return an error?
(1) SEL * FR sky;
When you use the SELECT clause to list one or two columns only from a table and no
WHERE clause, which SQL capability is used?
(3) Projection only
Which statement best describes how arithmetic expressions are handled?
(4) Division and multiplication operations are handled before subtraction and addition
operations.
In a SELECT clause, what is the result of 2 + 3 * 2?
(2) 8
Evaluate this SELECT statement:
SELECT (salary * raise_percent) raise
FROM employees;
If the RAISE_PERCENT column only contains null values, what will the statement
return?
(2) Only null values
Which SQL keyword specifies that an alias will be substituted for a column name in the
output of a SQL query?
(1) AS
You need to display employees with salaries that are at least 30000 or higher. Which
comparison operator should you use?
(3) >=
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 gunzo. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $4.28. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53068 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now