Oracle__1. Oracle 1Z0-051 Exam - General Flashcards by Deleted Deleted

List the 3 main command types.

DDL - Data Definition Language2. DML - Data Manipulation Language3. Transaction Control Commands

How well did you know this?

Not at all

Perfectly

List 3 main DDL commands.

CREATE2. DROP3. ALTER

How well did you know this?

Not at all

Perfectly

List 4 main DML commands.

SELECT2. INSERT3. UPDATE4. DELETE

How well did you know this?

Not at all

Perfectly

What object can be created but not dropped?

Database

How well did you know this?

Not at all

Perfectly

When is a session created?

When a user logs into an oracle database.

How well did you know this?

Not at all

Perfectly

The RENAME command can be performed on what 4 database objects?

Table2. View3. Sequence4. Private Synonym

How well did you know this?

Not at all

Perfectly

What is the syntax of the Rename statement?

RENAME table1 TO table2

How well did you know this?

Not at all

Perfectly

Name 2 main Oracle Tools for using SQL code?

Oracle SQL Developer2. SQL *Plus Environment

How well did you know this?

Not at all

Perfectly

What are the 4 main data types?

NUMBER (p, s)2. VARCHAR2 (s)3. DATE4. CHAR(2)

How well did you know this?

Not at all

Perfectly

What command can you use to validate that a set command worked?

VERIFY ON

How well did you know this?

Not at all

Perfectly

List 5 common objects in an Oracle Database.

TABLE2. VIEW3. SEQUENCE4. INDEX5. SYNONYM

How well did you know this?

Not at all

Perfectly

What command can be used to restore a dropped table from the recycle bin?

FLASHBACK TABLECommand first started with version 11g

How well did you know this?

Not at all

Perfectly

The RENAME statement can be used on what 4 database objects?

TABLE2. VIEW3. SEQUENCE4. PRIVATE SYNONYM

How well did you know this?

Not at all

Perfectly

The RENAME statement cannot be used on what database object?

PUBLIC SYNONYM

How well did you know this?

Not at all

Perfectly

What do the letters AWR mean?

Automatic Workload Repository

How well did you know this?

Not at all

Perfectly

What is an AWR Report?

A report to collect performance statistics of a database.

What does statistics do?

It gathers information on a table to be used by the SQL analyzer

What is CBO?

Cost based Optimizer

What is a data dictionary?

a read-only set of tables that provides information about the database.SYS is the owner of the data dictionary

What is Metadata?

DBMS_METADATA package provides interfaces for extracting complete definition of database objects.

What is the grid control.

Monitor active Oracle processes.

What is Oracle Partitioning?

A process for separating large tables logically so its data can be managed based on different set of keys.

What is Oracle Reports?

a tool for developing reports against data stored in an Oracle database.

What are the 2 parts of Oracle Reports?

Oracle Developer2. Oracle Application Server Reports Server

What format will Oracle Report deliver?

1. HTML2. RTF3. PDF4. XML5. MS EXCEL

What is Database Replay in Oracle 11g?

a new tool that captures SQL statements and let you replay them at will

What is Partitioning in Oracle 11g?

Referential, Internal and Virtual Column partitioning; new sub-partitioning options

What is Edition-based Redefinition in Oracle 11g?

Patch or update application data without interruptions

What is Schema Management in Oracle 11g?

Add columns and default values easily. Invisible tables, virtual columns and read only tables.

What is Data Warehousing and OLAP in Oracle 11g?

Cube Organized MVs, new Analytic Workspace Manager

What is Transaction Management in Oracle 11g?

introduce to Flashback data archive

What is SQL Performance Analyzer and Real-Time SQL Monitoring?

monitor SQL Performance in real time

What is SQL Access Advisor?

gives advice about optimal table design based on actual use of table and not just data.

What is a data pump.

Data Pump is a new feature introduced in Oracle 10g to move data and meta data between databases and to or from operating system files very efficiently. It provides parallel import and export utilities (impdp, expdp) on the command-line as well as the Web-based Oracle Enterprise Manager export/import interface. It is ideally beneficial for large databases and data warehousing environments. Oracle Data Pump facility runs on the server.The following are some functions performed by Oracle Data Pump: It is used to copy data from one schema to another between two databases or within a single database. It can be used to extract a logical copy of the entire database, a list of tablespaces, a list of schemas or a list of tables.

What is RDBMS?

relational database management system

What is the Oracle account that is the dictionary owner?

SYS

What is the Oracle account that is for the DBA?

SYSTEM

Are both these statements true? A table and a synonym can have the same name in the same schema. A table and a view can have the same name in the same schema.

Only a table and a synonym can have the same name in the same schema.Tables and View must have different names in the same schema.