SQL Basics Questions And Answers

Here you can find SQL Basics Questions and Answers.

Why SQL Basics Questions and Answers Required?

In this SQL Basics Questions and Answers section you can learn and practice SQL Basics Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get SQL Basics Questions and Answers?

AllIndiaExams provides you lots SQL Basics Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download SQL Basics Questions and Answers as PDF files and eBooks.

How to solve these SQL Basics Questions and Answers?

You no need to worry, we have given lots of SQL Basics Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

SQL Basics Questions & Answers

1. Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas

SQL Basics Questions & Answers

2. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?

SQL Basics Questions & Answers

3. Create table employee (name varchar ,id integer) What type of statement is this ?

SQL Basics Questions & Answers

4. Select * from employee What type of statement is this?

SQL Basics Questions & Answers

5. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

SQL Basics Questions & Answers

6. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .

SQL Basics Questions & Answers

7. To remove a relation from an SQL database, we use the ______ command.

SQL Basics Questions & Answers

8. Delete from r; r – relation This command performs which of the following action ?

SQL Basics Questions & Answers

9. Insert into instructor values (10211, ’Smith’, ’Biology’, 66000); What type of statement is this ?

SQL Basics Questions & Answers

10. Updates that violate __________ are disallowed .