adplus-dvertising
frame-decoration

Question

A reason for using an SQL view to hide columns is:

a.

to simplify a result only.

b.

to prevent the display of sensitive data only.

c.

to accomplish both of the above.

d.

None of the above are reasons for using an SQL view.

Posted under DBMS

Answer: (c).to accomplish both of the above.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. A reason for using an SQL view to hide columns is:
Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following is an SQL trigger supported by Oracle?

View solution

Q. The SQL ALTER statement can be used to:

View solution

Q. What SQL structure is used to limit column values of a table?

View solution

Q. Which is NOT one of the most common types of SQL CHECK constraints?

View solution

Q. What is an advantage of placing computations in SQL views?

View solution

Q. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

View solution

Q. ‘AS’ clause is used in SQL for

View solution

Q. The language which has recently become the defacto standard for interfacing application programs with relational database system is

View solution

Q. A report generator is used to

View solution

Q. Count function in SQL returns the number of

View solution

Q. The statement in SQL which allows to change the definition of a table is

View solution

Q. Which of the following is correct:

View solution

Q. Which of the following is a valid SQL type?

View solution

Q. Which of the following is an advantage of view?

View solution

Q. Which of the following is a legal expression in SQL?

View solution

Q. Which of the following is a comparison operator in SQL?

View solution

Q. Which one of the following is not true for a view:

View solution

Q. To delete a particular column in a relation the command used is:

View solution

Q. The ______ operator is used to compare a value to a list of literals values that have been specified.

View solution

Q. _____________ function divides one numeric expression by another and returns the remainder.

View solution
View All MCQs on DBMS

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...