DATABASE MANAGEMENT SYSTEM USING ORACLE
Select a topic below to start mastering through hand-on practice problems.
DATA DEFINATION LANGUAGE (DDL) COMMANDS
50 practice problems
Not started
DATA MANIPULATION LANGUAGE (DML) COMMANDS
30 practice problems
Not started
INTERVIEW QUESTIONS: DATA MANIPULATION LANGUAGE (DML) COMMANDS
20 practice problems
Not started
DATA QUERY LANGUAGE (DQL): SELECT
10 practice problems
Not started
WHERE CLAUSE, ORDER BY CLAUSE AND ALIAS
54 practice problems
Not started
PATTERN MATCHING OPERATOR (LIKE)
60 practice problems
Not started
GROUP FUNCTIONS, GROUP BY CLAUSE, HAVING CLAUSE
69 practice problems
Not started
SUBQUERIES: SINGLE ROW, MULTIPLE ROW, CORELATED SUBQUERY
69 practice problems
Not started
INTERVIEW QUESTIONS: SUBQUERIES
24 practice problems
Not started
SCALAR FUNCTION: DATE, NUMERIC, STRING, CONVERSION, GENERAL & NULL
60 practice problems
Not started
JOINS: INNER, CARTESIAN OR CROSS, LEFT OUTER, RIGHT OUTER, FULL OUTER
40 practice problems
Not started
INTERVIEW QUESTIONS: JOINS
24 practice problems
Not started
SET OPERATORS: UNION, UNION ALL, INTERSECT, MINUS
25 practice problems
Not started
VIEWS: CREATE, DROP, MATERLIZED
35 practice problems
Not started
TRANSACTION CONTROL LANGUAGE (TCL) and DATA CONTROL LANGUAGE (DCL)
35 practice problems
Not started
PLSQL: OUTPUT STATEMENT, DATATYPES, VARIABLES, CONSTANTS
22 practice problems
Not started
PLSQL: DECISION CONTROL STATEMENT: IF, IF-ELSE, IF-ELSIF-ELSE, CASE
31 practice problems
Not started
PLSQL: ITERATIVE CONTROL STATEMENT: SIMPLE LOOP, WHILE LOOP, FOR LOOP
32 practice problems
Not started
PLSQL: SELECT, %TYPE AND %ROWTYPE
28 practice problems
Not started
PLSQL: CURSORS, WITH FOR LOOP, PARAMETERISED CURSORS, UPDATABLE CURSORS
30 practice problems
Not started
PLSQL: STORED PROCEDURES, STORED FUNCTIONS
33 practice problems
Not started
PLSQL: PACKAGES
32 practice problems
Not started
PLSQL: EXCEPTION HANDLING: BASICS, EXCEPTION VARIABLES, RAISE_APPLICATION_ERROR, USER DEFINED EXCEPTION, RE-RAISE EXCEPTION
27 practice problems
Not started
PLSQL: TRIGGERES - BEFORE, AFTER, ROW LEVEL, STATEMENT LEVEL, CONDITIONAL TRIGGERS
30 practice problems
Not started