DBMS Questions and Answers updated daily – Computer Knowledge



163 DBMS Questions and answers section with explanation for various online exam preparation, various interviews, Computer Knowledge DBMS online test. DBMS Questions with detailed description, explanation will help you to master the topic.

DBMS Questions

1. Intersection operator is used to obtain the ___________ tuples.



SHOW ANSWER
Correct Ans:Common
Explanation:


2. In E-R Diagram, the total participation by entities is represented as



SHOW ANSWER
Correct Ans:Double line
Explanation:


3. Which of the following data type holds a string with maximum length of 255 characters?



SHOW ANSWER
Correct Ans:Tiny Text
Explanation:


4. Long datatype allows whole numbers between ____________



SHOW ANSWER
Correct Ans:-2,147,483,648 to 2,147,483,647
Explanation:


5. Which of the following operator combines two or more SELECT statements?



SHOW ANSWER
Correct Ans:Union
Explanation:


6. Which datatype is used to store up to 65,536 characters?



SHOW ANSWER
Correct Ans:Memo
Explanation:


7. Which of the following is used to generate a square root of a number?



SHOW ANSWER
Correct Ans:MySQL SQRT Function
Explanation:


8. Which Normal Form(NF) is considered adequate for normal relational database design?



SHOW ANSWER
Correct Ans:3NF
Explanation:


9. Which database level is the closest level to the users?



SHOW ANSWER
Correct Ans:External
Explanation:


10. The most open source DBMS is _______________



SHOW ANSWER
Correct Ans:MySQL
Explanation:


11. Which privilege is required to create a database?



SHOW ANSWER
Correct Ans:SYSDBA
Explanation:


12. Which type of file is a part of the Oracle database?



SHOW ANSWER
Correct Ans:Control file
Explanation:


13. What is the type of Oracle backup in which all uncommitted changes have been removed from the data files?



SHOW ANSWER
Correct Ans:Consistent backup
Explanation:


14. When is the System Global Area (SGA) created in an Oracle database environment?



SHOW ANSWER
Correct Ans:When the instance is started
Explanation:


15. Which Oracle backup and recovery file contains user and system data?



SHOW ANSWER
Correct Ans:Data file
Explanation:


16. The _______ performs process recovery when a user process fails.



SHOW ANSWER
Correct Ans:Process Monitor (PMON)
Explanation:


17. The ____________ performs recovery when a failed instance starts up again.



SHOW ANSWER
Correct Ans:System Monitor (SMON)
Explanation:


18. The __________ process is used for inter-instance locking in Real Application Clusters.



SHOW ANSWER
Correct Ans:Lock Manager Server
Explanation:


19. Oracle 9i Reports is the solution of _______



SHOW ANSWER
Correct Ans:Both (A) and (B)
Explanation:


20. Oracle 9i Reports gives us ____________ options for building a Web report.



SHOW ANSWER
Correct Ans:two
Explanation:



1...1...89


Are you seeking for good platform for practicing DBMS questions in online. This is the right place. The time you spent in Fresherslive will be the most beneficial one for you.

Online Test on DBMS @ Fresherslive

This page provides important questions on DBMS along with correct answers and clear explanation, which will be very useful for various Interviews, Competitive examinations and Entrance tests. Here, Most of the DBMS questions are framed with Latest concepts, so that you may get updated through these DBMS Online tests. DBMS Online Test questions are granted from basic level to complex level.

Why To Practice DBMS Test questions Online @ Fresherslive?

DBMS questions are delivered with accurate answer. For solving each and every question, very lucid explanations are provided with diagrams wherever necessary.

Practice in advance of similar questions on DBMS may improve your performance in the real Exams and Interview.

Time Management for answering the DBMS questions quickly is foremost important for success in Competitive Exams and Placement Interviews.

Through Fresherslive DBMS questions and answers, you can acquire all the essential idea to solve any difficult questions on DBMS in short time and also in short cut method.

Winners are those who can use the simplest method for solving a question. So that they have enough time for solving all the questions in examination, correctly without any tense. Fresherslive provides most simplest methods to answer any tough questions. Practise through Fresherslive test series to ensure success in all competitive exams, entrance exams and placement tests.

Why Fresherslive For DBMS Online Test Preparation?

Most of the job seekers finding it hard to clear DBMS test or get stuck on any particular question, our DBMS test sections will help you to success in Exams as well as Interviews. To acquire clear understanding of DBMS, exercise these advanced DBMS questions with answers.

You're Welcome to use the Fresherslive Online Test at any time you want. Start your beginning, of anything you want by using our sample DBMS Online Test and create yourself a successful one. Fresherslive provides you a new opportunity to improve yourself. Take it and make use of it to the fullest. GOODLUCK for Your Bright Future.


FreshersLive - No.1 Job site in India. Here you can find latest 2017 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.