|
Question |
Rating |
View Answer |
|
What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL; |
|
View Answer |
|
Which function is used to find the largest integer less than or equal to a specific value? |
|
View Answer |
|
What is the use of CASCADE CONSTRAINTS? |
|
View Answer |
|
What is the use of DESC in SQL? |
|
View Answer |
|
What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1; |
|
View Answer |
|
What is the use of the DROP option in the ALTER TABLE command? |
|
View Answer |
|
What is the advantage of specifying WITH GRANT OPTION in the GRANT command? |
|
View Answer |
|
Why does the following command give a compilation error? DROP TABLE &TABLE_NAME; |
|
View Answer |
|
Which date function is used to find the difference between two dates? |
|
View Answer |
|
What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP; |
|
View Answer |
|
What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' ); |
|
View Answer |
|
What will be the output of the following query? SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL; |
|
View Answer |
|
What command is used to create a table by copying the structure of another table? |
|
View Answer |
|
What is the difference between TRUNCATE and DELETE commands? |
|
View Answer |
|
TRUNCATE TABLE EMP; DELETE FROM EMP; Will the outputs of the above two commands differ? |
|
View Answer |
|
Which system table contains information on constraints on all the tables created? |
|
View Answer |
|
Which system tables contain information on privileges granted and privileges obtained? |
|
View Answer |
|
What command is used to get back the privileges offered by the GRANT command? |
|
View Answer |
|
What are the privileges that can be granted on a table by a user to others? |
|
View Answer |
|
State true or false. !=, <>, ^= all denote the same operation. |
|
View Answer |