Oracle__1. Oracle 1Z0-051 Exam - General Flashcards
List the 3 main command types.
- DDL - Data Definition Language2. DML - Data Manipulation Language3. Transaction Control Commands
List 3 main DDL commands.
- CREATE2. DROP3. ALTER
List 4 main DML commands.
- SELECT2. INSERT3. UPDATE4. DELETE
What object can be created but not dropped?
Database
When is a session created?
When a user logs into an oracle database.
The RENAME command can be performed on what 4 database objects?
- Table2. View3. Sequence4. Private Synonym
What is the syntax of the Rename statement?
RENAME table1 TO table2
Name 2 main Oracle Tools for using SQL code?
- Oracle SQL Developer2. SQL *Plus Environment
What are the 4 main data types?
- NUMBER (p, s)2. VARCHAR2 (s)3. DATE4. CHAR(2)
What command can you use to validate that a set command worked?
VERIFY ON
List 5 common objects in an Oracle Database.
- TABLE2. VIEW3. SEQUENCE4. INDEX5. SYNONYM
What command can be used to restore a dropped table from the recycle bin?
FLASHBACK TABLECommand first started with version 11g
The RENAME statement can be used on what 4 database objects?
- TABLE2. VIEW3. SEQUENCE4. PRIVATE SYNONYM
The RENAME statement cannot be used on what database object?
PUBLIC SYNONYM
What do the letters AWR mean?
Automatic Workload Repository