Question is ⇒ Which of the following is valid SQL for an Index?, Options are ⇒ (A) CREATE INDEX ID;, (B) CHANGE INDEX ID;, (C) ADD INDEX ID;, (D) REMOVE INDEX ID;, (E) , Leave your comments or Download question paper.

Question is ⇒ Which of the following is valid SQL for an Index?, Options are ⇒ (A) CREATE INDEX ID;, (B) CHANGE INDEX ID;, (C) ADD INDEX ID;, (D) REMOVE INDEX ID;, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	Which of the following is valid SQL for an Index?
A.	CREATE INDEX ID; [Correct Answer]
B.	CHANGE INDEX ID; [Wrong Answer]
C.	ADD INDEX ID; [Wrong Answer]
D.	REMOVE INDEX ID; [Wrong Answer]
View Answer 1 -1 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 :

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

⇒ 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 statement that queries or reads data from a table is ________ .
SELECT
READ
QUERY
None of the above is correct.

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

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

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

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

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

⇒ 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 following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;

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

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

⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS

⇒ The SQL statement to create a view is:
CREATE VIEW.
MAKE VIEW.
SELECT VIEW.
INSERT VIEW.

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

⇒ What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.

⇒ What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
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

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

⇒ To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
a particular column in a particular underlying table.
a particular column in a particular row.
a particular row in a particular underlying table.
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

⇒ Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.

⇒ 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');

⇒ With which type of SQL Server recovery model are all database changes logged?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ SQL is:
a programming language.
an operating system.
a data sublanguage.
a DBMS.

⇒ Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED

⇒ SQL views can be used to hide:
columns and rows only.
complicated SQL syntax only.
both of the above can be hidden by an SQL view.
None of the above is correct.

⇒ The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...

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

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