Answer / kebiraj

# Flashback Enhancements -Flashback Version Query, Flashback
Transaction Query, LOB Handling with Flashback, Setting up
for Flashback, Flashback Table, Flashback Drop Table and
Recycle Bin management.

# Backup and Recovery Enhancements - Flash Recovery Area,
Flashback Database (setup, flashback logs and use), Restore
Points, Simplified Recovery through RESETLOGS, Compressed
Backups, Change Tracking, Incrementally Updated Image
Copies, SWITCH DATABASE, New V$ Views, Encrypted Backups,
DROP DATABASE, CATALOG, Oracle Secure Backup and more.

# Automatic Storage Management - An introduction to Oracle's
new integrated file system and volume manager. Examples
illustrate the basic use of ASM, including creating disk
groups, fail groups, and using ASMCMD.

# Job Scheduler - Use the new DBMS_SCHEDULER package to
schedule jobs, including OS scripts. Examples illustrate
creating and scheduling jobs in both a Linux and a Windows
environment.

# SQL Enhancements - Regular expressions, DML error logging,
case-insensitive sort and search, MERGE enhancements, MODEL
queries, XQUERY and much more.

# PL/SQL Enhancements -The new optimizing compiler, compiler
warning messages, debugging improvements, native compilation
enhancements, UTL_MAIL and more.

# Performance and Tuning Features - Automatic SGA
Management, Automatic Workload Repository (AWR), Advisors
(ADDM, SQL Tuning Advisor, etc), Active Session History
data, new performance statistics (e.g. metrics and database
time), Thresholds and Server-Generated Alerts, CBO
Enhancements and much more.

# Security and Auditing Enhancements - Changes to the
CONNECT Role, FGAC Review, FGAC / VPD Enhancements, FGA
Review, Fine Grained Auditing Enhancements, Encryption
Enhancements, DBMS_CRYPTO Package (R1) and Transparent Data
Encryption (R2).

# Tablespace, Table and Segment Management - SYSAUX
tablespace, BIGFILE and SMALLFILE tablespaces,
database-level default tablespace, database-level default
temp tablespace, temp tablespace groups, multi-platform
transportable tablespace, renaming tablespaces, predicting
object growth, online table redefinition enhancements and
online segment shrink.

# Utilities (Data Pump) - An example-based introduction to
Data Pump, the next generation export / import utility. Also
covered: External Table and Logminer enhancements.

# SQL*Plus Enhancements - New predefined variables, SPOOL
command enhancements, AUTOTRACE enhancements and more.

# Miscellaneous Enhancements - Guaranteed UNDO retention,
ROLLBACK monitoring, Easy Connect (EZCONNECT) connections,
database high watermark recording, database feature usage
tracking and new and deprecated initialization parameters.

How do we use distinct statement? What is its use?

0 Answers  

---

How do I run a pl sql procedure in sql developer?

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

What is count * in sql?

0 Answers  

---

How do you concatenate in sql?

0 Answers  

---

What is a nested table in word?

0 Answers  

---

What is flag in sql?

0 Answers  

---

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

What is percent sign in sql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

Does sql support programming?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---