Oracle__1. Oracle 1Z0-051 Exam - General Flashcards

1
Q

List the 3 main command types.

A
  1. DDL - Data Definition Language2. DML - Data Manipulation Language3. Transaction Control Commands
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

List 3 main DDL commands.

A
  1. CREATE2. DROP3. ALTER
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

List 4 main DML commands.

A
  1. SELECT2. INSERT3. UPDATE4. DELETE
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What object can be created but not dropped?

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When is a session created?

A

When a user logs into an oracle database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A
  1. Table2. View3. Sequence4. Private Synonym
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the syntax of the Rename statement?

A

RENAME table1 TO table2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Name 2 main Oracle Tools for using SQL code?

A
  1. Oracle SQL Developer2. SQL *Plus Environment
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the 4 main data types?

A
  1. NUMBER (p, s)2. VARCHAR2 (s)3. DATE4. CHAR(2)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

VERIFY ON

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

List 5 common objects in an Oracle Database.

A
  1. TABLE2. VIEW3. SEQUENCE4. INDEX5. SYNONYM
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

FLASHBACK TABLECommand first started with version 11g

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A
  1. TABLE2. VIEW3. SEQUENCE4. PRIVATE SYNONYM
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

The RENAME statement cannot be used on what database object?

A

PUBLIC SYNONYM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What do the letters AWR mean?

A

Automatic Workload Repository

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is an AWR Report?

A

A report to collect performance statistics of a database.

17
Q

What does statistics do?

A

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

18
Q

What is CBO?

A

Cost based Optimizer

19
Q

What is a data dictionary?

A

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

20
Q

What is Metadata?

A

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

21
Q

What is the grid control.

A

Monitor active Oracle processes.

22
Q

What is Oracle Partitioning?

A

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

23
Q

What is Oracle Reports?

A

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

24
Q

What are the 2 parts of Oracle Reports?

A
  1. Oracle Developer2. Oracle Application Server Reports Server
25
Q

What format will Oracle Report deliver?

A
  1. HTML2. RTF3. PDF4. XML5. MS EXCEL
26
Q

What is Database Replay in Oracle 11g?

A

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

27
Q

What is Partitioning in Oracle 11g?

A

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

28
Q

What is Edition-based Redefinition in Oracle 11g?

A

Patch or update application data without interruptions

29
Q

What is Schema Management in Oracle 11g?

A

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

30
Q

What is Data Warehousing and OLAP in Oracle 11g?

A

Cube Organized MVs, new Analytic Workspace Manager

31
Q

What is Transaction Management in Oracle 11g?

A

introduce to Flashback data archive

32
Q

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

A

monitor SQL Performance in real time

33
Q

What is SQL Access Advisor?

A

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

34
Q

What is a data pump.

A

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.

35
Q

What is RDBMS?

A

relational database management system

36
Q

What is the Oracle account that is the dictionary owner?

A

SYS

37
Q

What is the Oracle account that is for the DBA?

A

SYSTEM

38
Q

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.

A

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.