Question is ⇒ A view is which of the following?, Options are ⇒ (A) A virtual table that can be accessed via SQL commands, (B) A virtual table that cannot be accessed via SQL commands, (C) A base table that can be accessed via SQL commands, (D) A base table that cannot be accessed via SQL commands, (E) , Leave your comments or Download question paper.

Question is ⇒ A view is which of the following?, Options are ⇒ (A) A virtual table that can be accessed via SQL commands, (B) A virtual table that cannot be accessed via SQL commands, (C) A base table that can be accessed via SQL commands, (D) A base table that cannot be accessed via SQL commands, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	A view is which of the following?
A.	A virtual table that can be accessed via SQL commands [Correct Answer]
B.	A virtual table that cannot be accessed via SQL commands [Wrong Answer]
C.	A base table that can be accessed via SQL commands [Wrong Answer]
D.	A base table that cannot be accessed via SQL commands [Wrong Answer]
View Answer 1 -2 Explanation:- Answer : A 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 :

⇒ Which one of the following sorts rows in SQL?
SORT BY
ALIGN BY
ORDER BY
GROUP BY

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

⇒ Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

⇒ Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).

⇒ What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic

⇒ Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language(DDL)
Data Manipulation Language(DML)
Both of above
None

⇒ 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.

⇒ With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Nonclustered
Clustered
Primary
Secondary

⇒ How many JDBC driver types does Sun define?
One
Two
Three
Four

⇒ A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

⇒ The SQL ALTER statement can be used to:
change the table structure.
change the table data.
add rows to the table.
delete rows from the table.

⇒ 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.

⇒ 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

⇒ What MySQL property is used to create a surrogate key in MySQL?
UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL.

⇒ With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Nonclustered
Clustered
Primary
Secondary

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

⇒ A ________ is a stored program that is attached to a table or a view.
pseudofile
embedded SELECT statement
trigger
None of the above is correct.

⇒ Where is metadata stored in MySQL?
In the MySQL database
In the MySQL database
In the MySQL database
None of the above is correct.

⇒ SQL can be used to:
create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

⇒ 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.

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

⇒ The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;

⇒ An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
COBOL.
VB.NET.
TRANSACT SQL.
Visual Basic.

⇒ 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.

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

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

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Equi-join
Natural join
Outer join
Cartesian join

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

⇒ SQL Server automatically creates an index on:
primary keys only.
foreign key only.
both primary and foreign keys.
SQL Server never automatically creates an index.