Oracle Dba Interview Questions and Answers | Oracle DBA Interview Questions | Oracle DBA 10g Interview Questions and Answers | Dba interview questions | Oracle Dba 10g Interview Questions and Answers | Advanced Oracle DBA Interview Questions and Answers | Oracle DBA Faq Interview Questions | Oracle DBA Tutorial for Beginners PDF | Oracle DBA Apps Interview Questions and Answers | Oracle DBA Technical Interview Questions and Answers | Oracle DBA Interview Questions with Answers for Experienced PDF Free Download | Common Oracle DBA Interview Questions and Answers | Oracle DBA Interview Question Answer | Oracle Dba Interview Questions and Answers 10g | Oracle Reports Interview Questions and Answers | Oracle Developer Interview Questions and Answers | Oracle DBA Interview Question Answer for Freshers Pdf | Oracle DBA Interview Questions and Answers PDF | Oracle Dba Ebooks Free Download Pdf | Oracle Dba Interview Questions and Answers for Testers

11.	What is cloning?
	Cloning is the process of creating an identical copy of the Oracle application system.

	Posted by Krishnareddy. (Mar 03, 2014)
	Duplicate copy of the target database.
	Posted by Ibrahim. (Oct 09, 2013)
	Cloning is the copy of oracle database.

12.	What is the difference between like and between operator?
	Like operator is used for pattern matching searches. Between operator is used for checking the range of values.

	Posted by Sibaprasadpatra. (Mar 08, 2014)
	Like operator is used for finding out the data on a specific condition and between operator is used to find out the data with in a specific range.

13.	What is Log files?
	Log files are also referred to as the Redo log files or Online log files. These files contain all the changes made to the data over a period of time. There will be at least two redo log files. These files are used to rebuild the database in case of a crash.

14.	What is the difference between database management system and database application?
	Database Management System is the program that organizes and maintains the information. Database Application is the program that is used to view, retrieve and update information stored in the database.

15.	What is the use of views?
	It can be used to hide sensitive columns. It can be used to hide complex queries involving multiple tables. Views created with a check option, prevents the updating of other rows and columns. Views provide an additional level of table security by restricting to a predetermined set of rows and /or columns of a table. Views simplify commands for the user because they allow them to select information from multiple tables without actually knowing how to perform a join. Views provide data in a different perspective than that of a base table by renaming columns without affecting the base table.

15.

What is the use of views?

It can be used to hide sensitive columns.
It can be used to hide complex queries involving multiple tables.
Views created with a check option, prevents the updating of other rows and columns.
Views provide an additional level of table security by restricting to a predetermined set of rows and /or columns of a table.
Views simplify commands for the user because they allow them to select information from multiple tables without actually knowing how to perform a join.
Views provide data in a different perspective than that of a base table by renaming columns without affecting the base table.

FeedBack Form