FAQs

Oracle Basic Concepts

This is a collection of 22 FAQs for Oracle DBA on fundamental concepts. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

◉ Oracle Tutorials - Oracle Basic Concepts

Introduction to Oracle Database 10g Express Edition

This is a collection of 21 FAQs for Oracle DBA on Oracle 10g Express Edition with installation and basic introduction. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

◉ Introduction to Oracle Database 10g Express Edition

 Introduction to Command-Line SQL*Plus Client Tool

A collection of 25 FAQs on Oracle command-line SQL*Plus client tool. Clear answers are provided with tutorial exercises on creating tnsnames.ora and connecting to Oracle servers; SQL*Plus settings and environment variables; saving query output to files; getting query performance reports.

◉ Introduction to Command-Line SQL*Plus Client Tool

Understanding SQL Basics

A collection of 28 FAQs on Oracle SQL language basics. Clear answers are provided with tutorial exercises on data types, data literals, date and time values, data and time intervals, converting to dates and times, NULL values, pattern matches.

◉ Understanding SQL Basics

Understanding SQL DDL Statements

A collection of 11 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views.

◉ Understanding SQL DDL Statements

Understanding SQL DML Statements

A collection of 15 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting, updating and deleting rows from database tables.

◉ Understanding SQL DML Statements

Understanding SQL SELECT Query Statements

A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries.

◉ Understanding SQL SELECT Query Statements

Understanding SQL Transaction Management

A collection of 22 FAQs on Oracle SQL transaction management. Clear answers are provided with tutorial exercises on starting and ending transactions, committing and rolling back transactions, transaction/statement-level read consistency, read committed isolation level, locks and dead locks.

◉ Understanding SQL Transaction Management

Managing Oracle User Accounts, Schema and Privileges

A collection of 23 FAQs on Oracle user account, schema and privileges. Clear answers are provided with tutorial exercises on creating user accounts, granting privileges for session connections, granting privileges for creating tables and inserting rows.

◉ Managing Oracle User Accounts, Schema and Privileges

Managing Oracle Database Tables

A collection of 18 FAQs on database tables for DBA and developers. Clear answers are provided together with tutorial exercises to help beginners on creating, altering and removing tables, adding, altering and removing columns, and working with recycle bin.

◉ Managing Oracle Database Table

Managing Oracle Table Indexes

This is a collection of 14 FAQs for Oracle DBA on creating, dropping, rebuilding and managing indexes. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

◉ Managing Oracle Table Indexes