Review 1Z0-071 Oracle OCA (1/14)

Dec 25, 2024

Chapter 1: Oracle & SQL

GOALS

– Identify the Connection Between an ERD and a Relational Database
– Explain the Relationship Between a Database and SQL
– Describe the Purpose of DDL
– Describe the Purpose of DML
– Build a SELECT Statement to Retrieve Data from an Oracle Database Table

Identify the Connection Between an ERD and a Relational Database

The ERD is a logical model of an existing business.
The entities in an ERD are the “things” that form the basis of a business information system and that are transformed into tables in a database.
The ERD is a logical representation of a business; the relational database is the physical model in which actual data can be housed and processed in support of the business process.

Explain the Relationship Between a Database and SQL

A database is a persistent store of information that continues—or persists—beyond the execution of a given application.
SQL is the most widely used language for interacting with a database.
SQL statements can be issued by any one or more applications to a single database. Those applications can be written in a variety of languages that support SQL calls, including software written in languages such as Java, PHP, and others.

Describe the Purpose of DDL

DDL statements include CREATE, ALTER, and DROP.
DDL statements are a subset of SQL and are used to create new database objects or alter the structure of existing database objects, including removing them.

＊Definition = Create (Tạo) + Alter (Sửa cấu trúc) + Drop (xoá)

Describe the Purpose of DML

DML statements include SELECT, UPDATE, and INSERT.
DML statements are a subset of SQL and are used to work with existing database objects.
Build a SELECT Statement to Retrieve Data from an Oracle Database Table
The SELECT statement is the most commonly used SQL statement.
SELECT can be used to query data from a single table or join data together in two or more tables to return data that is logically connected.
SELECT can be used with functions and other capabilities to transform data in various ways, which is discussed at length later in this book.

Q&A:

1. Which of the following topics are not included in the SQL

Fundamentals I exam but are addressed on the SQL Associate exam? (Choose all that apply.)

A. MERGE

B. Conversion functions

C. FLASHBACK

D. External tables

Correct answer: A, B, C

2. If you focus on trying to achieve the minimum passing grade requirement for the exam, you can study more efficiently.

A. True

B. False

Correct answer: B

3. The exam is timed.

A. True

B. False

Correct answer: A

4. The 1Z0-071 exam (which is the subject of this book) has been officially validated by Oracle Corporation against which of the following versions of the Oracle database? (Choose all that apply.)

A. Every version

B. 9i

C. 11g

D. 12c

Correct answer: D

5. The best exam guide you could possibly get for preparing to take and pass the 1Z0-071 certification exam, SQL Associate, is which of the following? (Choose all that apply.)

A. This book.

B. The book you are holding right now.

C. This here book.

D. Don’t make me tell you again.

Correct answer: A, B, C

Identify the Connection Between an ERD and a Relational Database

6. When transforming an ERD into a relational database, you often use an entity to build a database’s:

A. Table

B. Column

C. Attribute

D. Relationship

Correct answer: A

7. The unique identifier of a row in a database table is a(n):

A. ID

B. Primary key

C. Primary column

D. Column

Correct answer: B

Explain the Relationship Between a Database and SQL

8. Which of the following is true of SQL?

A. It is the most commonly used language for interacting with a database.

B. It is the only language you can use to create a database.

C. It is the only language you can use to interact with a

database.

D. None of the above

Correct answer: A

9. What can you use to submit SQL statements for execution?

(Choose all that apply.)

A. PHP

B. Java

C. SQL Developer

D. SQL*Plus

Correct answer: A, B, C, D

Describe the Purpose of DDL

10. What is one of the purposes of DDL? (Choose the best answer.)

A. Query data from a given table

B. Issue privileges to users

C. Remove existing data from a database table

D. None of the above

Correct answer: C

11. What can DDL be used for? (Choose three.)

A. Add comments to a database table

B. Add columns to a database table

C. Add data to a database table

D. Add privileges for a user to a database table

Describe the Purpose of DML

Correct answer: A, B, C

12. Which one of the following is a DML statement?

A. ADD

B. ALTER

C. UPDATE

D. MODIFY

Correct answer: C

13. Which of the following can be used to remove data from a table?

(Choose two.)

A. DELETE

B. UPDATE

C. MODIFY

D. ALTER

Correct answer: C

Build a SELECT Statement to Retrieve Data from an Oracle Database Table

14. What can a SELECT statement be used to query? (Choose the best answer.)

A. Only one report

B. Only one table

C. One or more reports

D. One or more tables

Correct answer: D

15. Which of the following is not a capability of the SELECT statement?

A. It can transform queried data and display the results.

B. It can remove data from a table.

C. It can join data from multiple tables.

D. It can aggregate database data.

Correct answer: B

Source：Udemy

You need to login in order to like this post: click here