|
Question |
Rating |
View Answer |
|
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? |
|
View Answer |
|
What operator performs pattern matching? |
|
View Answer |
|
What operator tests column for the absence of data? |
|
View Answer |
|
Which command executes the contents of a specified file? |
|
View Answer |
|
What is the parameter substitution symbol used with INSERT INTO command? |
|
View Answer |
|
Which command displays the SQL command in the SQL buffer, and then executes it? |
|
View Answer |
|
What are the wildcards used for pattern matching. |
|
View Answer |
|
State true or false. EXISTS, SOME, ANY are operators in SQL. |
|
View Answer |
|
State true or false. !=, <>, ^= all denote the same operation. |
|
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 |