Database administrator (DBA)
Database independence
ANSI method
approaches
concurrent request
deadlock
entity relation diagram (ERD)
features/functions
IDENTITY attribute
initial features
inline views
layered programming
nonblocking
NULL comparisons
openness
outcomes
scalar subqueries
sequence generation
serializable transaction
session’s transaction
solving problems
SQL99 standards
SQL queries
stored procedures
theoretical advantage
UPDATE/SELECT queries
Windows/UNIX/Linux
Database Resident Connection Pooling (DRCP)
benefits
server process pooling
Database Resource Manager Process (DBRM)
Database tables
blockchain tables
blockchain technology
clustered index
cluster objects
definition
external tables
general information
hash clustered tables
hash clusters
heap-organized table
index-organized tables
nested tables
object tables
object type
sorted hash clustered tables
sorted hash clusters
temporary tables
terminology
types
Data definition language (DDL)
atomicity
extent trimming
allocation depiction
UNIFORM vs. AUTOALLOCATEs extents
AUTOALLOCATE_TEST tablespace
big_table.log file
CREATE TABLE AS SELECT
external table definition
locally managed tablespace (LMT)
tablespaces
UNIFORM_TEST
USER_SEGMENTS
locking
ALTER TABLE T
CREATE/ALTER
CREATE VIEW command
DBA_DDL_LOCKS view
direct load (DL) locks
ONLINE keyword
operation
store procedure
types
parallelization
commands
CREATE TABLE AS SELECT statement
direct path
extent trimming
USER_INFO table
Datafiles
file system mechanisms
ASM design
blocks
clustered file system
extents
OS file system
segments
storage hierarchy
tablespace
OMF naming convention
pluggable databases
single instance container database
SYSTEM datafiles
Data loading/unloading
bulk data loading tools
data pump format
external tables
approaches
DEFAULT DIRECTORY clause
demo1.bad file
demo1.log file
error message
EXTERNAL_TABLE parameter
features
INSERT statement
load different files
modification
multiuser issue
parallel processing
PREPROCESSOR clause
project referenced column
SQLLDR control files
SQL*Plus
tasks
tmp directory
flat file
AUTHID CURRENT_USER
control file
CONTROL_FILES parameter
raw data (.dat) file
datafile
DESCRIBE table
NLS_DATE_FORMAT
PL/SQL utility
SQL*Plus command line
UTL_FILE
SQLLDR
SeeSQLLDR
techniques
Data manipulation language (DML)
classes
TM locks
transaction (TX) locks
stored procedure
TRACE file
Datatypes
BFILE
binary data
binary data (RAW types)
BINARY_FLOAT/BINARY_DOUBLE
BLOB
CHAR
character/binary string types
character sets
NLS controls
CHAR/VARCHAR2/NVARCHAR2
character string
bytes/character
CHAR/NCHAR types
CHAR, VARCHAR2, NCHAR, and NVARCHAR2
CHAR type
CHAR_COLUMN
Hello World
“N” Variant
string types
variable-length strings
CLOB
DATE
DATE, TIMESTAMP, and INTERVAL
adding/subtracting time
ADD_MONTHS function
DATE type
definition
differences
formats
INTERVAL type
MONTHS_BETWEEN function
TIMESTAMP
extended types
container database
LOB segment details
MAX_STRING_SIZE
nonextended column
single instance database
USER_LOBS
USER_OBJECTS
HEXTORAW function
INTERVAL DAY TO SECOND/YEAR TO MONTH
JSON
JSON format
LONG types
ALL_VIEWS dictionary view
AUTHID CURRENT_USER
coping types
DBMS_SQL.COLUMN_VALUE_LONG
key points
restriction (LONG RAW types)
manual states
SUBSTR_OF
WHERE clause operations
LONG RAW
NCHAR type
NCLOB
number types
approximate numbers
BINARY_FLOAT/BINARY_DOUBLE types
floating-point number
non-native types
NUMBER type
performance implications
storing numbers
VSIZE function
overview
RAW/NUMBER
RAWTOHEX function
ROWID
ROWID/UROWID types
TIMESTAMP
TIME ZONE
UROWID
VARCHAR2
Data warehouse/decision support system
Data warehousing technique
Database block writer (DBWn)
Dedicated server connections
architecture
features
one-to-one mapping
Deferrable constraints
CASCADE UPDATE
CHILD
COMMIT statement
IMMEDIATE mode
NOT NULL
NULLs
optimizer index
source code
UNIQUE/PRIMARY KEY constraint
UPDATE command
Diagnosability Process (DIAG)
Do-It-Yourself (DIY) parallelism
DBA_PARALLEL_EXECUTE_CHUNKS
DBMS_JOB
DBMS_PARALLEL_EXECUTE
JOB_QUEUE_PROCESSES
NTILE built-in analytic function
PL/SQL block
PROCESS BIG TABLE
ROWID ranges
SERIAL procedure
task removing