SQL Basic Questions and Answers

This section focuses on the "Basics" of the SQL. These Multiple Choice Questions (mcq) should be practiced to improve the SQL skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exam and other competitive examinations.

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

A. DML(Data Manipulation Langauge)
B. DDL(Data Definition Langauge)
C. Query
D. Relational Schema

View Answer


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

A. Fixed, equal
B. Fixed, variable
C. Equal, variable
D. Variable, equal

View Answer


3. Insert into Business values (10211, "Jhon", "Chemist", 66000); What type of statement is this ?

A. Query
B. DML
C. Relational
D. DDL

View Answer


4. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

A. Having, where
B. Group by, having
C. Group by, where
D. Where, having

View Answer


5. Subqueries cannot:

A. Appear in select, update, delete, insert statements.
B. Retrieve data from a table different from the one in the outer query
C. Join tables
D. Use group by or group functions

View Answer


6. How can you find rows that do not match some specified condition?

A. EXISTS
B. Double use of NOT EXISTS
C. NOT EXISTS
D. None of the mentioned is correct.

View Answer


7. DBMS is an interface between

A. Database and User
B. Database application and database
C. Database and SQL
D. Data and Database

View Answer


8. Which of the following is an advantage of database management approach?

A. Data is dependent on programs
B. Data redundancy increases
C. Data can be accessed by multiple programs
D. Multiple users cannot access data concurrently

View Answer


9. The attribute value that is currently unknown is

A. 0
B. -1
C. NULL
D. "

View Answer


10. A relationship among a set of values in a table is represented by a

A. Relation
B. Column
C. Row
D. Attributes

View Answer






Also check :


Discussion


* You must be logged in to add comment.