Exam : Oracle 1Z0-007 practice questions

Exam : Oracle 1Z0-007
Title : Introduction to Oracle9i: SQL questions and practice sure pass


1. In which three cases would you use the USING clause? (Choose three.)
A.You want to create a nonequijoin.
B.The tables to be joined have multiple NULL columns.
C.The tables to be joined have columns of the same name and different data types.
D.The tables to be joined have columns with the same name and compatible data types.
E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
Answer: CDE

2. What are two reasons to create synonyms? (Choose two.)
A.You have too many tables.
B.Your tables are too long.
C.Your tables have difficult names.
D.You want to work on your own tables.
E.You want to use another schema's tables.
F.You have too many columns in your tables.
Answer: CE

3. The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?
A.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa ASC;
B.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa ASC;
C.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa;
D.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa;
E.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa DESC;
F.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa DESC;
Answer: F

4. The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
CITY_ADDRESS VARCHAR2(50)
STATE_ADDRESS VARCHAR2(50)
PROVINCE_ADDRESS VARCHAR2(50)
COUNTRY_ADDRESS VARCHAR2(50)
POSTAL_CODE VARCHAR2(12)
CUSTOMER_PHONE VARCHAR2(20)
The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?
A.COUNT(UPPER(country_address))
B.COUNT(DIFF(UPPER(country_address)))
C.COUNT(UNIQUE(UPPER(country_address)))
D.COUNT DISTINCT UPPER(country_address)
E.COUNT(DISTINCT (UPPER(country_address)))
Answer: E

5. What does the FORCE option for creating a view do?
A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schema even if you don't have privileges
D.creates a view regardless of whether or not the base tables exist
Answer: D

Oracle 9i introduction

Oracle 9i introduction video

Oracle 9i presentation

Oracle 9i presentation

Query Analysis and Optimizing in Oracle

Query Analysis and Optimizing in Oracle

Introduction to Oracle 9i: SQL

  
Oracle 9i DBA Track-4 Exams
  
OCA
  
Exam #1Z0-007 Introduction to Oracle 9i: SQL
  
Exam #1Z0-031- Oracle 9i Database Fundamentals I
  
OCP
  
Exam #1Z0-032- Oracle 9i Database Fundamentals II
  
Exam #1Z0-033- Oracle 9i Database: Performance Tuning
  
Introduction to Oracle 9i: SQL
  
Writing Basic SQL Select statements
  
                List the capabilities of SQL SELECT statements
  
                Execute a basic SELECT statement
  
                Differentiate between SQL statements and SQL *Plus commands
  
Restricting and sorting Data
  
                Limit the rows retrieved by a query
  
                Sort the rows retrieved by a query
  
Single Row Functions
  
                Describe various types of functions available in SQL
  
                Use character, number and date functions in SELECT statements
  
                Use conversion functions
  
Displaying data from multiple tables
  
                Write SELECT statements to access data from more than one table using equality and non-equality joins
  
                View data that generally does not meet a join condition by using outer joins 
  
                Join a table to it-self using a self-join
  
Aggregating data using group functions 
  
                Identify the available group functions 
  
                Use group functions 
  
                Group data by using the GROUP BY functions
  
                Include or exclude grouped rows by using the HAVING clause
  
Sub queries
  
                Describe the types of problems that sub-queries can solve
  
                Define subqueries
  
                List the types of subqueries
  
                Write single row and multiple rows subquries
  
Producing Readable output with iSQL*Plus
  
                Produce queries that require a substitution variable
  
                Produce more readable output
  
                Create and execute script files
  
Manipulating data
  
                Describe each DML statement
  
                Insert rows into a table
  
                Update rows from a table
  
                Delete rows from a table
  
                Merge rows from a table
  
                Control transactions
  
Creating and managing tables
  
                Describe the main database objects
  
                Create tables
  
                Describe the data types that can be used when specifying column definition
  
                Alter table definitions
  
                Drop, rename ad truncate tables
  
Including constraints
  
                Describe constraints
  
                Create and maintain constraints
  
Creating views
  
                Describe a view
  
                Create, alter the definition and drop a view
  
                Retrieve data through a view
  
                Insert update and delete data through a view
  
                Create and use an inline view
  
                Perform TOP ‘N’ Analysis
  
Creating other database objects
  
                Create, maintain and use sequences
  
                Create and maintain indexes
  
                Create private and public synonyms
  
Controlling user access
  
                Create users
  
                Create roles to ease setup and maintenance of the security model
  
                Use the GRANT and REVOKE statements to grant and revoke object privileges
  
 
  
 
  
                
  

how to communicate any ug general 8 i learn dj workshop how technology co key functions instructor up business and IT pattern security internet and awk mining synthesis joins effects cs3 training module 2 14 hours Build it com project canadian Made sap is if required reports 8 ms windows network hr new no.3 ladder safety design- sumif communication skills the company microsoft NT over 20 release 11 5 cross culture april 6th p2 foundation Pentium payroll and accounts Creative and innovation we complete tips of dreamweaver 40 their take the class datawarehouse the training any other Lean 5s drawing quality a it organization s not 0 system organization s enable it IS STANDARDS keep you from expectations body s 25 years t find open source technologies how to do personal trainer bd software the quality management 3 levels help prepare you job server Imap4 ba analysis Filmmaking form validation ecc programs the design requirement are being focus how georgia management boston 4 week Supervisory Management the needs the delivery of advanced lr life and health CE the processes The Formatting Toolbars arena use of -- manual Phi what are your support training emulator nt tools PLC CCNA Oracle Java QTP excel software testing CPR english quickbooks IATA MCSE networking computer AutoCAD management informatica electrical Tally forklift ABAP hvac safety scada pds piping Finance ITIL project management spoken english acls PHP communication insurance sas pmp embedded siebel ERP peoplesoft pdms soft skills welding telecom marketing animation AS400 train the trainer fico photoshop payroll phlebotomy six sigma Cognos J2EE UNIX asp net chennai sap fico solidworks electronics housekeeping plumbing CCNP free anger management vlsi mortgage matlab personality development gsm bookkeeping banking nursing hardware plastering first aid sharepoint american heart association cpr dot net Ndt embedded systems NLP software ielts Cisco Flash OSHA aix Powerpoint mobile dba Design access business objects Oracle Dba engineering india data warehousing db2

What are the functions of functions key in Computer from F1 to F12?

What are the functions of functions key in Computer? F1 to F12

Answer:

Commonly known as "function keys", F1 through F12 may have a variety of different uses or no use at all. Depending on the installed operating system and the software program currently open will change how each of these keys operate. A program is capable of not only using each of the function keys, but also combining the function keys with the ALT and/or CTRL keys, for example, Microsoft Windows users can press ALT + F4 to close the program currently active.

Below is a short-listing of some of the common functions of the functions keys on computers running Microsoft Windows. As mentioned above not all programs support function keys and/or may perform different tasks then those mentioned below. If you are looking for more specific shortcut keys and function key examples we suggest seeing our shortcut key page.

F1

* Almost always used as the help key, almost every program will open the help screen when this key is pressed.

* Windows Key + F1 would open the Microsoft Windows help and support center.

* Open the Task Pane.

F2

* In Windows commonly used to rename a highlighted icon or file.

* Alt + Ctrl + F2 opens a new document in Microsoft Word.

* Ctrl + F2 displays the print preview window in Microsoft Word.

F3

* Often opens a search feature for many programs including Microsoft Windows.

* Shift + F3 will change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.

F4

* Open find window.

* Repeat the last action performed (Word 2000+)

* Alt + F4 will close the program currently active in Microsoft Windows.

* Ctrl + F4 will close the open window within the current active window in Microsoft Windows.

F5

* In all modern Internet browsers pressing F5 will refresh or reload the page or document window.

* Open the find, replace, and go to window in Microsoft Word.

* Starts a slideshow in PowerPoint.

F6

* Move the cursor to the Address bar in Internet Explorer and Mozilla Firefox.

* Ctrl + Shift + F6 opens to another open Microsoft Word document.

F7

* Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.

* Shift + F7 runs a Thesaurus check on the word highlighted.

* Turns on Caret browsing in Mozilla Firefox.

F8

* Function key used to enter the Windows startup menu, commonly use to get into Windows Safe Mode.

F9

* Opens the Measurements toolbar in Quark 5.0.

F10

* In Microsoft Windows activates the menu bar of an open application.

* Shift + F10 is the same as right-clicking on a highlighted icon, file, or Internet link.

F11

* Full-screen mode in all modern Internet browsers.

F12

* Open the Save as window in Microsoft Word.

* Shift + F12 save the Microsoft Word document.

* Ctrl + Shift + F12 prints a document in Microsoft Word.

What are the functions of functions key in Computer from F1 to F12?

What are the functions of functions key in Computer? F1 to F12

Answer:

Commonly known as "function keys", F1 through F12 may have a variety of different uses or no use at all. Depending on the installed operating system and the software program currently open will change how each of these keys operate. A program is capable of not only using each of the function keys, but also combining the function keys with the ALT and/or CTRL keys, for example, Microsoft Windows users can press ALT + F4 to close the program currently active.

Below is a short-listing of some of the common functions of the functions keys on computers running Microsoft Windows. As mentioned above not all programs support function keys and/or may perform different tasks then those mentioned below. If you are looking for more specific shortcut keys and function key examples we suggest seeing our shortcut key page.

F1

* Almost always used as the help key, almost every program will open the help screen when this key is pressed.

* Windows Key + F1 would open the Microsoft Windows help and support center.

* Open the Task Pane.

F2

* In Windows commonly used to rename a highlighted icon or file.

* Alt + Ctrl + F2 opens a new document in Microsoft Word.

* Ctrl + F2 displays the print preview window in Microsoft Word.

F3

* Often opens a search feature for many programs including Microsoft Windows.

* Shift + F3 will change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.

F4

* Open find window.

* Repeat the last action performed (Word 2000+)

* Alt + F4 will close the program currently active in Microsoft Windows.

* Ctrl + F4 will close the open window within the current active window in Microsoft Windows.

F5

* In all modern Internet browsers pressing F5 will refresh or reload the page or document window.

* Open the find, replace, and go to window in Microsoft Word.

* Starts a slideshow in PowerPoint.

F6

* Move the cursor to the Address bar in Internet Explorer and Mozilla Firefox.

* Ctrl + Shift + F6 opens to another open Microsoft Word document.

F7

* Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.

* Shift + F7 runs a Thesaurus check on the word highlighted.

* Turns on Caret browsing in Mozilla Firefox.

F8

* Function key used to enter the Windows startup menu, commonly use to get into Windows Safe Mode.

F9

* Opens the Measurements toolbar in Quark 5.0.

F10

* In Microsoft Windows activates the menu bar of an open application.

* Shift + F10 is the same as right-clicking on a highlighted icon, file, or Internet link.

F11

* Full-screen mode in all modern Internet browsers.

F12

* Open the Save as window in Microsoft Word.

* Shift + F12 save the Microsoft Word document.

* Ctrl + Shift + F12 prints a document in Microsoft Word.