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