Question is ⇒ ON UPDATE CASCADE ensures which of the following?, Options are ⇒ (A) Normalization, (B) Data Integrity, (C) Materialized Views, (D) All of the above., (E) , Leave your comments or Download question paper.

Question is ⇒ ON UPDATE CASCADE ensures which of the following?, Options are ⇒ (A) Normalization, (B) Data Integrity, (C) Materialized Views, (D) All of the above., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	ON UPDATE CASCADE ensures which of the following?
A.	Normalization [Wrong Answer]
B.	Data Integrity [Correct Answer]
C.	Materialized Views [Wrong Answer]
D.	All of the above. [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : B 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 SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Complete backup
Transaction Log
Differential backup
None of the above is correct.

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

⇒ To run a compiled Java program, the machine must have what loaded and running?
Java virtual machine
Java compiler
Java bytecode
A Web browser

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints

⇒ Which is NOT one of the most common types of SQL CHECK constraints?
System date
Range checks
Lists of values
Comparing one column value to another within the same table

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.

⇒ The SQL keyword(s) ________ is used with wildcards.
LIKE only
IN only
NOT IN only
IN and NOT IN

⇒ The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.

⇒ The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.

⇒ What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.

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

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

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

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

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

⇒ When using the SQL INSERT statement:
rows can be modified according to criteria only.
rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can either be inserted into a table one at a time or in groups.

⇒ The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.

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

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

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

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

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

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

⇒ Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
Does not start with the word SELECT.
All of the above.

⇒ Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Type 1 only
Type 2 only
Both Type 3 and Type 4
All of Type 1, Type 2, Type 3 and Type 4

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

⇒ Which of the following is a way to create and modify tables using SQL Server?
Write SQL code using either CREATE or ALTER SQL statements only.
Use the graphical facilities of SQL Server Enterprise Manager only.
Both of the two methods above will work.
Neither of the two methods above will work.

⇒ SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML

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