Question is ⇒ For what purposes are views used?, Options are ⇒ (A) To hide columns only, (B) To hide rows only, (C) To hide complicated SQL statements only, (D) All of the above are uses for SQL views., (E) , Leave your comments or Download question paper.

Question is ⇒ For what purposes are views used?, Options are ⇒ (A) To hide columns only, (B) To hide rows only, (C) To hide complicated SQL statements only, (D) All of the above are uses for SQL views., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	For what purposes are views used?
A.	To hide columns only [Wrong Answer]
B.	To hide rows only [Wrong Answer]
C.	To hide complicated SQL statements only [Wrong Answer]
D.	All of the above are uses for SQL views. [Correct Answer]
View Answer 1 -1 Explanation:- Answer : D Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.

⇒ Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.

⇒ Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.

⇒ SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

⇒ What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
VBScript only
Jscript only
Java only
All of the above are supported

⇒ With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
PESSIMISTIC

⇒ Which JDBC driver Type(s) can be used in either applet or servlet code?
Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only

⇒ Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.

⇒ The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.

⇒ The SQL statement that queries or reads data from a table is ________ .
SELECT
READ
QUERY
None of the above is correct.

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ ________ was adopted as a national standard by ANSI in 1992.
Oracle
SQL
Microsoft Access
DBase

⇒ Which of the three possible types of triggers does SQL Server support?
INSTEAD OF only
AFTER only
BEFORE only
INSTEAD OF and AFTER only

⇒ Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
#
%
&
@

⇒ What is bytecode?
Machine-specific code
Java code
Machine-independent code
None of the above is correct.

⇒ How many copies of a JSP page can be in memory at a time?
One
Two
Three
Unlimited

⇒ JDBC stands for:
Java Database Connectivity
Java Database Components
Java Database Control
None of the above is correct.

⇒ What is not true of a Java bean?
There are no public instance variables.
All persistent values are accessed using get and set methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE

⇒ A UNION query is which of the following?
Combines the output from no more than two queries and must include the same number of columns.
Combines the output from no more than two queries and does not include the same number of columns.
Combines the output from multiple queries and must include the same number of columns.
Combines the output from multiple queries and does not include the same number of columns.

⇒ Which of the following is the correct order of keywords for SQL SELECT statements?
SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM,SELECT
SELECT,WHERE,FROM

⇒ What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ How does Tomcat execute a JSP?
As a CGI script
As an independent process
By one of Tomcat's threads
None of the above is correct.

⇒ The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.

⇒ Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE

⇒ When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

⇒ What SQL structure is used to limit column values of a table?
The LIMIT constraint
The CHECK constraint
The VALUE constraint
None of the above is correct.

⇒ To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
UNIQUE
DISTINCT
SINGLE

⇒ ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.