Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.

PL/SQL :: Basic Concepts

Home > PL/SQL > Basic Concepts > General Questions

1. You can add a row using SQL in a database with which of the following?

Answer: INSERT

Explanation:

Here is no explanation for this answer

Workspace

Tags:

No Tags on this question yet!

2. The command to remove rows from a table 'CUSTOMER' is:

Answer: DELETE FROM CUSTOMER WHERE ...

Explanation:

DELETE FROM CUSTOMER WHERE ...

Workspace

Tags:

No Tags on this question yet!

3. The SQL WHERE clause:

Answer: limits the row data are returned.

Explanation:

limits the row data are returned.

Workspace

Tags:

No Tags on this question yet!

4. The command to eliminate a table from a database is:

Answer: DROP TABLE CUSTOMER;

Explanation:

If you actually want to remove the table definitions as well as the data, simply drop the tables.
TRUNCATE TABLE empties it, but leaves its structure for future dat Like TRUNCATE TABLE CUSTOMER.
Removes all rows from a table without logging the individual row deletions

Workspace

Tags:

No Tags on this question yet!

5. ON UPDATE CASCADE ensures which of the following?

Answer: Data Integrity

Explanation:

ON UPDATE CASCADE is used for checking data in the table after ALTER operation.
Example: Alter table emp add constraint Unique Key (DID) ON UPDATE CASCADE. This will restrict the update operation if any dublicate values exists.

Workspace

Tags:

No Tags on this question yet!

6. SQL data definition commands make up a(n) ________ .

Answer: DDL

Explanation:

Oracle SQL Do support XML to be inserted into the DB table. The Datatype for XML is XMLType.
We use extract() and existsNode() like functions to access the XML data into DB.

Workspace

Tags:

No Tags on this question yet!

7. Which of the following is valid SQL for an Index?

Answer: CREATE INDEX ID;

Explanation:

Index is created to make the searches (select query) faster. But to use the index we need to write the SQL select statement using the column on which we created the Index.
Example: Create index indx1 on emp (empno). To use the benefits, we have to write select * from emp where empno > 0;

Workspace

Tags:

No Tags on this question yet!

9. Which of the following is the original purpose of SQL?

Answer: All of the above.

Explanation:

All of the above.

Workspace

Tags:

No Tags on this question yet!

10. The wildcard in a WHERE clause is useful when?

Answer: An exact match is not possible in a SELECT statement.

Explanation:

Wildcards are basically for pattern matching.
Select * from emp where ename like = 'A%'; - Lists all emps with starting
Likewise % (For ignoring any number of characters) and _(Only one character).

Workspace

Tags:

No Tags on this question yet!