QUESTIONS INTERVIEW.IN

Sign Up | Sign In

Post a Question

Asked Questions

Interview Questions

- Computer Language

- Computer Database

- Data Structure

- Certifications

- Cost Accounting

- Common Interview Questions

Home >> Computer Database >> sql

Question

View Answer

=> What is SQLLoader?

=> lets i have a table "bapi" having 6 field like this f1 f2 f3 f4 f5 f6 ... ... .. ... ... ... p r o m o d i want to retrive all the data by using select statement and my output will be look like this: xyz ... p r o m o d

=> How write a SQL statement to query the result set and display row as columns and columns as row?

=> What is the main difference between the IN and EXISTS clause in subqueries??

=> What is DML,DDL?

=> There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with M and M with F?

=> What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

=> Explain about predicates and statements?

=> on index why u need indexing ? where that is stroed and what u mean by schema object? for what purpose we are using view

=> what is the difference between oracle,sql and sql server

=> What is the difference between where condition and having condition?

=> Whats the back end processes when we type "Select * from Table"?

=> Difference between a equijoin and a union

=> Is there any query which is used to find the case sensitivity in each records in database through visual basic?

=> How to store directory structure in a database?

=> In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?????

=> Which system table contains information on constraints on all the tables created?

=> There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assign

=> What the difference between UNION and UNIONALL?

=> Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Page: 1 2 3 4 5 6 7 8

Last

Latest sql Interview video

Latest Topic

How to Import sqlserver data to mysql?

Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given

Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array

HTTPS is invalid and might prevent it from being indexed

Deprecated: Required parameter $sql follows optional parameter $name in

Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null

Your account isn’t eligible for the Google Workspace Individual plan