adplus-dvertising
frame-decoration

Question

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

a.

GROUP BY

b.

WHERE

c.

ORDER BY

d.

FROM

Posted under DBMS

Answer: (c).ORDER BY

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Similar Questions

Discover Related MCQs

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

Q. A data manipulation command the combines the records from one or more tables is called

View solution

Q. _________ is a virtual table that draws its data from the result of an SQL SELECT statement.

View solution

Q. A table joined with itself is called

View solution

Q. _________ data type can store unstructured data.

View solution

Q. SQL is a standard language for ________.

View solution

Q. SQL stands for _________.

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!

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...