PL/SQL :: Basic Concepts

Home > PL/SQL > Basic Concepts > General Questions

1 / 41

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

Answer: Option C

Explanation:

Here is no explanation for this answer

Workspace


Tags:  Virtusa

Answer: Option C

Explanation:

DELETE FROM CUSTOMER WHERE ...

Workspace


Tags:  Virtusa

Answer: Option B

Explanation:

limits the row data are returned.

Workspace


Tags:  Virtusa

Answer: Option B

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:  Virtusa

5 / 41

 ON UPDATE CASCADE ensures which of the following?

Answer: Option B

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:  Virtusa

6 / 41

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

Answer: Option A

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:  Virtusa

7 / 41

 Which of the following is valid SQL for an Index?

Answer: Option A

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:  Virtusa

Answer: Option E

Explanation:

Here is no explanation for this answer

Workspace


Tags:  Virtusa

Answer: Option D

Explanation:

All of the above.

Workspace


Tags:  Virtusa

Answer: Option B

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:  Virtusa