|
Question |
Rating |
View Answer |
|
What is the use of CASCADE CONSTRAINTS? |
|
View Answer |
|
How can i hide a particular table name of our schema.
|
|
View Answer |
|
TRUNCATE TABLE EMP; DELETE FROM EMP; Will the outputs of the above two commands differ? |
|
View Answer |
|
What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP; |
|
View Answer |
|
What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL; |
|
View Answer |
|
What is the difference between TRUNCATE and DELETE commands? |
|
View Answer |
|
Which command executes the contents of a specified file? |
|
View Answer |
|
What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' ); |
|
View Answer |
|
What are the wildcards used for pattern matching. |
|
View Answer |
|
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? |
|
View Answer |
|
How to delete same id in rows? For example empid=5 repeated for times in rows. How to delete which sql query is used? |
|
View Answer |
|
Why does the following command give a compilation error? DROP TABLE &TABLE_NAME; |
|
View Answer |
|
How we get second highest salary in database. Please show me this coding. |
|
View Answer |
|
What is the use of the DROP option in the ALTER TABLE command? |
|
View Answer |
|
what is the difference between replace and translate functions? |
|
View Answer |
|
What operator tests column for the absence of data? |
|
View Answer |
|
How to find out the 10th highest salary in SQL query?
|
|
View Answer |
|
What is the difference between cross product & Cartesian product? |
|
View Answer |
|
What are the advantages and disadvantages of primary key and foreign key in SQL?
|
|
View Answer |
|
What are the privileges that can be granted on a table by a user to others? |
|
View Answer |