Latest SQL Interview Questions - RDBMS Interview Questions
Which date function is used to find the difference between two dates?
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
What is the use of DESC in SQL?
What is the use of CASCADE CONSTRAINTS?
Which function is used to find the largest integer less than or equal to a specific value?
What is the output of the following query?
What operator tests column for the absence of data?
Which command executes the contents of a specified file?
What is the parameter substitution symbol used with INSERT INTO command?
Which command displays the SQL command in the SQL buffer, and then executes it?
What are the wildcards used for pattern matching?
State true or false. EXISTS, SOME, ANY are operators in SQL.
State true or false. !=, <>, ^= all denote the same operation.
What are the privileges that can be granted on a table by a user to others?
What command is used to get back the privileges offered by the GRANT command?
Which system tables contain information on privileges granted and privileges obtained?
Which system table contains information on constraints on all the tables created?
What is the difference between TRUNCATE and DELETE commands?
What command is used to create a table by copying the structure of another table?
Why does the following command give a compilation error?
What is the use of the DROP option in the ALTER TABLE command?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables
What operator performs pattern matching?
What is the difference between Single row sub-Query and Scalar sub-Query?
How do I write a cron which will run a SQL query and mail the results to a group? Subscribe
I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated?
How to copy SQL table?
Difference between Store Procedure and Trigger?
Difference between Store Procedure and Trigger?
Cursor Syntax brief history?
Explain normalization with examples?
How to find out the database name from SQL*PLUS command prompt?
How can we backup the sql files & what is SAP?
Whats the back end processes when we type "Select * from Table"?
What is the difference between SQL and SQL Server?
What is table space?
What is difference between Co-related sub query and nested sub query?
When we give SELECT * FROM EMP; How does oracle respond?
What is reference cursor?
What operator performs pattern matching?
What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features&advantages in Oracle and MS Access?
Can we call user defined packages in SQL statements?
What is normalazation,types with examples. with queries of all types?
Difference between a equijoin and a union?
What is database?
How to store directory structure in a database?
Difference between VARCHAR and VARCHAR2?
Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute
How to write a sql statement to find the first occurrence of a non zero value?
Given an unnormalized table with columns:Name,Phone number,Address You notice that some records in Name column are duplicate. Write a T-SQL statement to delete all duplicate record under Name column.
How write a SQL statement to query the result set and display row as columns and columns as row?
What is cluster.cluster index and non cluster index?
If Delete Any Table In Back-End Then. What Are The Triggers will Fire Automatically(Those Triggers
How can i hide a particular table name of our schema.
What is the main difference between the IN and EXISTS clause in subqueries??
In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?
What is difference between DBMS and RDBMS?
How to test the complex view using manually testing?
When using a count(distinct) is it better to use a self-join or temp table to find redundant data,
What is the advantage to use trigger in your PL?
What is materialized View?
What the difference between UNION and UNIONALL?
How to find out the 10th highest salary in SQL query?
0 comments:
Post a Comment