All India Exams
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

Views DBMS Questions And Answers

Here you can find Views DBMS Questions and Answers.

Why Views DBMS Questions and Answers Required?

In this Views DBMS Questions and Answers section you can learn and practice Views DBMS Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get Views DBMS Questions and Answers?

AllIndiaExams provides you lots Views DBMS Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Views DBMS Questions and Answers as PDF files and eBooks.

How to solve these Views DBMS Questions and Answers?

You no need to worry, we have given lots of Views DBMS Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

Views DBMS Questions & Answers

1. Which of the following creates a virtual relation for storing the query ?

Views DBMS Questions & Answers

2. Which of the following is the syntax for Views DBMS where v is view name ?

Views DBMS Questions & Answers

3. Materialised Views DBMS make sure that

Views DBMS Questions & Answers

4. Updating the value of the view

Views DBMS Questions & Answers

5. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

Views DBMS Questions & Answers

6. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?

Home EngineeringComputer Science & EngineeringDBMS Questions and AnswersViews

Views - DBMS Questions and Answers

This is the DBMS questions and answers section on "Views" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

Views DBMS Questions

Online Test Name Views
Exam Type Multiple Choice Questions
Category Computer Science Engineering Quiz
Number of Questions 06
1. Which of the following creates a virtual relation for storing the query ?
  • A. Function
  • B. View
  • C. Procedure
  • D. None of the mentioned
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option B

Explanation:

View

Any such relation that is not part of the logical model, but is made visible to a user as a virtual relation, is called a view.

Workspace

Report Error


2. Which of the following is the syntax for views where v is view name ?
  • A. Create view v as query name";
  • B. Create query expression" as view;
  • C. Create view v as query expression";
  • D. Create view query expression";
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option B

Explanation:

Create view v as "query expression;

is any legal query expression. The view name is represented by v

Workspace

Report Error


3. Materialised views make sure that
  • A. View definition is kept stable
  • B. View definition is kept up-to-date
  • C. View definition is verified for error
  • D. View is deleted after specified time
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option B

Explanation:

View definition is kept up-to-date

Workspace

Report Error


4. Updating the value of the view
  • A. Will affect the relation from which it is defined
  • B. Will not change the view definition
  • C. Will not affect the relation from which it is defined
  • D. Cannot determine
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

Will affect the relation from which it is defined

Workspace

Report Error


5. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?
  • A. The from clause has only one database relation.
  • B. The query does not have a group by or having clause.
  • C. The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.
  • D. All of the mentioned
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option D

Explanation:

All of the mentioned

All of the conditions must be satisfied to update the view in sql.

Workspace

Report Error


  • «
  • 1
  • 2
  • »

Related Topics:

  • RDBMS
  • OLAP
  • Physical Storage Media
  • Transactions
  • Data Types
  • Storage Structure
  • Triggers
  • Aggregate Functions
  • SQL Basics
  • Deadlocks

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • IT Courses Quiz

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions

Programming Quiz

  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • Python Programming
  • DataScience MCQ
  • Hadoop MCQ
  • Mongo DB MCQ
  • MySQL MCQ

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics

Our Sites

AView.in

© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy