Which of the following terms does not apply to the CRUD model of persistent storage?
a.
Create
b.
Undo
c.
Destroy
d.
Read
Which of the following is not a DML statement?
a.
INSERT
b.
UPDATE
c.
COMMIT
d.
DELETE
Which of these terms is a DML statement that allows you to add rows to a table?
a.
CREATE
b.
INVOKE
c.
DELETE
d.
INSERT
Given the structure of the branch table shown below, which of these
INSERT
statements uses correct positional notation?BRANCH_ID NUMBER(10) BRANCH_NAME VARCHAR2 DIVISION_ID NUMBER(10)
a.
INSERT
INTO
branch
(branch_name,
division_id,
branch_id)
VALUES
('Executive',
7,
14);
b.
INSERT INTO branch
VALUES
('Executive',
7,
14);
c.
INSERT
INTO
branch
(branch_name,
division_id,
branch_id)
VALUES (14, 'Executive', 7);
d.
INSERT
INTO
branch
VALUES
(14,
'Executive',
7);
Which of these INSERT statements uses correct named column notation?
a.
INSERT
INTO
branch
(branch_name,
division_id,
branch_id
)VALUES
('Executive',
7,
14...
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )
By :
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )
By:
Overview of this book
<p>The Oracle Database 11g: SQL Fundamentals I exam is the first stepping stone in getting the Oracle Certified Associate Certification for Oracle Database 11g. The SQL programming language is used in every major relational database today and understanding the real world application of it is the key to becoming a successful DBA.<br /><br />This book gives you: the essential real world skills to master relational data manipulation with Oracle SQL and prepares you to become an Oracle Certified Associate. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.<br /><br />We begin with the essentials of why databases are important in today's information technology world and how they work.<br /><br />We continue by explaining the concepts of querying and modifying data in Oracle using a range of techniques, including data projection, selection, creation, joins, sub-queries and functions. Finally, we learn to create and manipulate database objects and to use them in the same way as today's expert SQL programmers.<br /><br />This book prepares you to master the fundamentals of the SQL programming language using an example-driven method that is easy to understand<br /><br />This definitive certification guide provides a disciplined approach to be adopted for successfully clearing the 1Z0-051 SQL Fundamentals I exam, which is the first stepping stone towards attaining the OCA on Oracle Database 11g certification.<br /><br />Each chapter contains ample practice questions at the end. A full-blown mock test is included for practice so you can test your knowledge and get a feel for the actual exam.</p>
Table of Contents (20 chapters)
OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
SQL and Relational Databases
SQL SELECT Statements
Using Conditional Statements
Data Manipulation with DML
Combining Data from Multiple Tables
Row Level Data Transformation
Aggregate Data Transformation
Combining Queries
Creating Tables
Creating Other Database Objects
SQL in Application Development
Companylink Table Reference
Getting Started with APEX
Index
Customer Reviews