Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
DML Statements - Oracle Replication
Home
>>
Category
>>
Oracle (MCQ) questions and answers
>>
Oracle Replication
Q. Which of the following is / are DML Statements?
- Published on 13 Aug 15
a.
Insert
b.
Update
c.
Create
d.
Both A and B
ANSWER: Both A and B
Related Content
Oracle DBA (
67
)
Oracle Replication (
19
)
Oracle Architecture (
20
)
Oracle Transaction (
40
)
Administering and Managing an Oracle Database (
25
)
Managing Oracle Database Processes (
8
)
Oracle Control Files (
27
)
Oracle Redo Log (
23
)
Oracle Tablespaces (
24
)
Oracle Datafiles and Tempfiles (
13
)
Oracle Managed Files (
11
)
Oracle Schema (
26
)
Oracle Tables (
13
)
Oracle Indexes and Partitioned Tables (
24
)
Oracle Clusters (
24
)
Oracle Views, Sequences, and Synonyms (
15
)
Oracle Distributed Database concepts (
28
)
Discussion
Nirja Shah
-Posted on 18 Sep 15
- Data Manipulation Language (DML) statements are used for managing data within schema objects.
- Some examples:
1. SELECT - Retrieve data from the database
2. INSERT - Insert data into a table
3. UPDATE - Updates existing data within a table
4. DELETE - Deletes all records from a table, the space for the records remain
5. MERGE - UPSERT operation (insert or update)
6. CALL - Call a PL/SQL or Java subprogram
7. EXPLAIN PLAN - Explain access path to data
8. LOCK TABLE - Control concurrency
➨
Post your comment / Share knowledge
Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
MCQs
English
Tutorials
Download
▲