Exam Tiger
APTITUDE TESTS - MENTAL ABILITY - SOLVED OBJECTIVE MCQ SETS - QUESTION ANSWER - PDF STUDY MATERIALS - SHORTCUT TIPS

Sql Query Language

SQL Question Answer: SQL is the short form of Structured Query Language. SQL (pronounced as 'es-q-el') is a standard computer language that is used to communicate with a database for querying, inserting, updating and modifying data stored in RDBMS. SQL was initially developed at IBM in the early 1970s. SQL is a standard query language that is used as a base to manipulate data from different databases like Microsoft Access, Sql Server, MySql, Oracle and many other relational databases. SQL has been enhanced in different database system. For example PL/SQL (Procedural Language/Structured Query Language) is used by Oracle, whereas T-SQL (Transact-SQL) is an extended version of Structured Query Language (SQL) that works on Microsoft SQL Server and Sybase SQL server.

Like other programming languages, SQL also follows a predefined set of rules and guidelines called Syntax. For example, all the SQL statements start with some keywords and end with a semicolon (;) Some of the most important SQL commands are CREATE, SELECT, INSERT, UPDATE, DELETE, USE. However, SQL may not be categorized as a full-fledged functional language like C, C++ or Java. SQL is a fourth generation language (4GL) which is close to human language. That's why it is easy to learn SQL.


Sql Query Language Multiple Choice (MCQ) objective question with answer keys

Here you will find a list of common important questions on sql query language in multiple choice question (MCQ) style with answer. These frequently asked sample questions are given with correct choice of answer that you can check instantly. Presently we have added total 4 sets of questions on sql query language for you to practice. We will keep adding more questions and provide this question bank in PDF format, so that you can download them instantly in E-book style.

The following section consists of objective multiple choice questions (mcq) on sql query language with answers.


INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO SELECT IT AS YOUR ANSWER.


Q. Which data manipulation command is used to combines the records from one or more tables?
A.
SELECT
B.
PROJECT

C.
JOIN
D.
PRODUCT


Show Answer
Q. Which of the following is not a valid SQL type?
A.
DECIMAL
B.
NUMERIC

C.
FLOAT
D.
CHARACTER


Show Answer
Q. SQL permits attribute names to be repeated in the same relation. (True or False)
A.
FALSE
B.
TRUE


Show Answer
Q. Which operator is used to compare a value to a specified list of values?
A.
BETWEEN
B.
ANY

C.
IN
D.
ALL


Show Answer
Q. A SQL query automatically eliminates duplicates (True / False) ?
A.
TRUE
B.
FALSE


Show Answer



Advertisement


eXTReMe Tracker