huiop.blogg.se

Oracle Integrity Constraints (PRIMARY KEY, NOT NULL, CHECK, FOREIGN KEY, UNIQUE)

Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT)

Oracle Data Definition Language (CREATE, ALTER, DROP, TRUNCATE, RENAME) Oracle Data Manipulation Language (INSERT, UPDATE, DELETE, INSERT ALL, MERGE) Oracle Join Queries, (Inner Join, Outer Join, Self Join)ĬUBE, ROLLUP Functions, WITH, CASE Operators UNION, INTERSECT, MINUS Operators and Sorting Query Result Integrity Constraints (PRIMARY KEY, NOT NULL.) DEFAULT Values Dropping Constraints Disabling and Enabling Differing Constraints Check View Info about Constraints Working with Dates Oracle Views Oracle Sequences Oracle Synonyms Indexes and Clusters Table Partitioning Altering Partition Tables Dropping Partitions Merging Partitions Splitting Partitions Coalescing Partitions Oracle Objects and Object Types Oracle TO_TIMESTAMP Number Functions (Math Functions) Character Functions Miscellaneous Functions Aggregate Functions Date and Time Functions Oracle Join Queries GROUP BY Queries, SUB Queries CUBE, ROLLUP Functions Oracle DML (INSERT, UPDATE, DELETE.) Oracle DDL (CREATE, ALTER, DROP.) COMMIT, ROLLBACK,SAVEPOINT Data Control Language (GRANT, REVOKE) Oracle SQL Tutorial Contents Introduction to Databases CODD'S Rules Datatypes and Create Table Oracle SELECT Statement Formatting in SQL*Plus UNION, INTERSECT, MINUS Operators and Sorting Query Result 60 Technical Questions 42 Backup & Recovery Questions Unix For Oracle DBA 20 Questions Oracle DBA Interview Questions Most asked Oracle DBA Interview Questions.