OCA Oracle database 11g : SQL fundamentals I : a real world by Steve Ries

By Steve Ries

This e-book is jam-packed with actual observe examples. every one significant certification subject is roofed in a separate bankruptcy, which is helping to make knowing of suggestions more straightforward. on the finish of every bankruptcy, you will discover numerous perform inquiries to enhance and try your studying. you'll get a suppose for the particular SQL basics I examination by means of fixing perform papers modeled on it. This e-book is for somebody who wishes the fundamental abilities to go the Oracle Database SQL basics I examination and use these talents in everyday life as an SQL developer or database administrator.

Show description

Read or Download OCA Oracle database 11g : SQL fundamentals I : a real world certification guide PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time details entry and knowledge sharing throughout your dispensed framework utilizing the professional details during this Oracle Press advisor. Oracle Streams 11g facts Replication explains tips on how to organize and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program convey four Recipes offers an example-based method of studying software show - the ground-breaking, speedy software improvement platform incorporated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes an exceptional instance or to kick begin their considering and get pointed within the correct course.

Additional info for OCA Oracle database 11g : SQL fundamentals I : a real world certification guide

Example text

Entity c. Flat file d. Repeating group 2. What is the name of the process used to transform non-relational data into relational data? Object-oriented [ 34 ] Chapter 1 3. A ___________ uniquely identifies any single row of data. a. Attribute c. Column 4. Which of these is NOT a form of entity relationship? Many-to-many 5. What is the visual representation of a data model called? a. A table b. Normalization d. An entity relationship diagram 6. Which of these is NOT required to make a database connection?

To set up our connection, we need to click on the New Connection button at the top of the left-hand connection frame. This action brings up the New / Select Database Connection window. We fill in the information, as listed in the following screenshot. This example connection assumes that you have set up an Oracle database using the standard installation procedure with common defaults. If you're connecting to an existing database, the information you enter will be different: [ 29 ] SQL and Relational Databases The pieces of information that are relevant to us are as follows: • Connection name: This can be whatever we choose, but it is usually a good idea to make it descriptive of the connection itself.

Whatever your choice of SQL tool, it is very difficult for a database administrator to completely avoid using SQL*Plus. The following is a screenshot of the command-line SQL*Plus tool: [ 20 ] Chapter 1 TOAD The Tool for Oracle Application Developers (TOAD) is a full-featured development and administration tool for Oracle as well as other relational database systems, including Microsoft SQL Server, Sybase, and IBM's DB2. Originally created by Jim McDaniel for his own use, he later released it as freeware for the Oracle community at large.

Download PDF sample

Rated 4.67 of 5 – based on 24 votes