|
Related Questions |
View Answer |
|
What the difference between UNION and UNIONALL?
|
View Answer
|
|
How to find out the 10th highest salary in SQL query?
|
View Answer
|
|
How to find second maximum value from a table?
|
View Answer
|
|
What are the advantages and disadvantages of primary key and foreign key in SQL?
|
View Answer
|
|
What is the wildcard character in SQL?
|
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
|