|
INTERVIEW QUESTIONS
ORACLE
DATABASE ADMINISTRATION
DETAILS
Question: What is DDL, DML?
Answer: Data Definition Language..
-> Create Command, Drop Command, Alter Command and Truncate Command
Data Manipulation Language..
-> Insert Command,Delete Command, Update Command
|
|
|
Category |
Database Administration Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8984 users |
Added on |
7/25/2011 |
Views |
73784 |
Rate it! |
|
|
Question:
What is DDL, DML?
Answer:
Data Definition Language..
-> Create Command, Drop Command, Alter Command and Truncate Command
Data Manipulation Language..
-> Insert Command,Delete Command, Update Command Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How do you sort a table?
|
View Answer
|
|
Different types of table join.
|
View Answer
|
|
What is a cursor? Why do you need them? What are the different kinds of cursor?
|
View Answer
|
|
If you have an open cursor on a table, modify the same tableand commit, what would happen?
|
View Answer
|
|
Name some built-in functions that can be used in SQL queries?
|
View Answer
|
|
Is it advisable to force an index when you want to select mostof the entries in the table?
|
View Answer
|
|
Do you need a commit after DDL statements?
|
View Answer
|
|
How can you find all the tables created by an user?
|
View Answer
|
|
How is locking implemented?
|
View Answer
|
|
Whenever a DBA creates a user in which datafile that will be get created ?
|
View Answer
|
|
What is a lookup table in database? where can we use these type of table?
|
View Answer
|
|
Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i Any attempts would be appreciated
|
View Answer
|
|
Can we decrease the Datafile size?
|
View Answer
|
|
What are the components of physical database structure of Oracle database
|
View Answer
|
|
What are the components of logical database structure of Oracle database
|
View Answer
|
|
What is a tablespace
|
View Answer
|
|
What is SYSTEM tablespace and when is it created
|
View Answer
|
|
Explain the relationship among database, tablespace and data file.What is schema
|
View Answer
|
|
What are Schema Objects
|
View Answer
|
|
Can objects of the same schema reside in different tablespaces
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Database Administration Interview Questions & Answers - Exam Mode /
Learning Mode
|