Structured Query Language

Which of the following feature of SQL Server was used before XML technology for semi structured data?

2 Mark(s)

In memory database
Stored Procedure
Dynamic management views
None of the mentioned

What is SQL Server?

2 Mark(s)

SQL Server is a relational database management system
SQL Server is a software whose main purpose is to store and retrieve data
SQL Server is a highly secure server and does not allow any database file manipulation during execution
All of the mentioned

What does the LIKE operator do in SQL?

2 Mark(s)

Joins tables
Deletes records
Filters with pattern matching
Adds new columns

What is the purpose of the GROUP BY clause?

2 Mark(s)

Sort data by groups
Summarize data into groups
Filter grouped data
Rearrange column order

Which SQL keyword is used to remove duplicates from a result set?

2 Mark(s)

NO DUPLICATES
REMOVE
DISTINCT
UNIQUE

Which JOIN returns only the matching rows from both tables?

2 Mark(s)

LEFT JOIN
RIGHT JOIN
INNER JOIN
FULL OUTER JOIN

What does the SQL JOIN clause do?

2 Mark(s)

Combines rows from multiple tables
Deletes rows from a table
Finds duplicates
Creates new tables

What is the default sorting order of ORDER BY clause?

2 Mark(s)

Random
Descending
Ascending
Alphabetical

Which keyword is used to sort the result-set in SQL?

2 Mark(s)

ORDER
GROUP
SORT
SORT

Which SQL function is used to count the number of rows?

2 Mark(s)

COUNT()
SUM()
TOTAL()
LENGTH()

What does the WHERE clause do in SQL?

2 Mark(s)

Groups records
Filters records
Sorts records
Deletes records

When was the first version of Microsoft SQL Server released?

2 Mark(s)

1991
1990
1988 d) 1983
1983

Which of the following is a free database software running free SQL Server technology?

2 Mark(s)

SQL Server Web
SQL Server Enterprise s
SQL Server Workgroup
SQL Server Expres

Which of the following companies originally worked together to create and market the first version of SQL Server?

2 Mark(s)

Sybase
Ashton-Tate
Microsoft d
All of the Mentioned

What is the hybrid model in SQL Server?

2 Mark(s)

Using XML with views
Using XML with triggers
Combination of relational and XML data type columns
Combination of relational and non relational data type columns

Which of the reasons will force you to use the XML data model in SQL Server?

2 Mark(s)

Order is inherent in your data
Your data is sparse or you do not know the structure of the data
Your data represents containment hierarchy
All of the Mentioned

Which of the following is not a class of constraint in SQL Server?

2 Mark(s)

UNIQUE
NOT NULL
CHECK
NULL

Which of the following joins are SQL server default?

2 Mark(s)

Inner
Equi
Outer
None of the Mentioned

Which of the following is not a SQL Server INFORMATION_SCHEMA view?

2 Mark(s)

sys.dm_exec_connections
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

SQL Server has mainly how many types of views?

2 Mark(s)

FOUR
THREE
ONE
TWO

Which database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators?

2 Mark(s)

temp
model
msdb
master

Which of the following data type is not present in SQL Server?

2 Mark(s)

geography
hierarchyid
boolean
bit

Which was the first version of SQL Server to introduce in-memory capability?

2 Mark(s)

SQL Server 2005
SQL Server 2008
SQL Server 2012
SQL Server 2014

What is the Codename for SQL Server 2012?

2 Mark(s)

Katmai
Denali
Hekaton
Kilimanjaro

Which SQL statement is used to retrieve data from a database?

2 Mark(s)

GET
SELECT
FETCH
READ

VARCHAR is used only for numeric data?

2 Mark(s)

FLOT
NUMARIC
DECIMAL
CHARACTER

Which of the following can execute a trigger in PL/SQL?

2 Mark(s)

Oracle server
User
Both user and oracle server
Neither user nor oracle server

What is the full form of PL in PL/SQL?

2 Mark(s)

Programming Language
Programming Logic
Procedural Language
Procedural Logic

Which of the following statement is true about views in SQL?

2 Mark(s)

We can delete but not insert rows in a view
We cannot insert and delete rows in a view
We can insert but not delete rows in a view
We can insert and delete rows in a view

Which of the following command is used to create a database in SQL?

2 Mark(s)

MAKE
CREATE
INSERT
DEVELOP

Which of the following is a default join type?

2 Mark(s)

Right join
Left join
Inner join
Outer join

Which statement(s) are mandatory in a simple SQL SELECT statement?

2 Mark(s)

Select, From
Select, OrderBy
Select, Where
Select, GroupBy

Which character is used to separate SQL statements in database systems?

2 Mark(s)

:
%
-
;

Which of the following is basis for SQL?

2 Mark(s)

SQL Server
DBMS
RDBMS
Oracle

Which of the following tasks CANNOT be accomplished using SQL?

2 Mark(s)

Creating and modifying database structures
Writing complex algorithms for data analysis
Retrieving specific data from a database
Adding new data to a database

What is the purpose of the SQL keyword “DISTINCT” in a SELECT statement?

2 Mark(s)

To retrieve unique values from a column
To filter NULL values
To delete duplicate records
To sort the result set

Which of the following SQL statement selects only unique values from ‘section’ column of table ‘school’?

2 Mark(s)

SELECT section FROM school;
SELECT DISTINCT section FROM school;
SELECT * FROM school;
SELECT ALL section FROM school;

Which SQL keyword is used to sort the data returned by a SELECT statement?

2 Mark(s)

Group
Order
Group By
Order By

The SQL LIKE operator is used in which of the following clause?

2 Mark(s)

Having
Select
Where
Group by

In SQL, what is the difference between CHAR and VARCHAR data types?

2 Mark(s)

CHAR is fixed length, VARCHAR is variable length
CHAR is variable length, VARCHAR is fixed length
No difference
VARCHAR is used only for numeric data

Which SQL data type is used to store numerical values with fixed precision and scale?

2 Mark(s)

DECIMAL
INTEGER
DATE
VARCHAR

In SQL, which data type is best suited for storing large texts such as articles or comments?

2 Mark(s)

TEXT
VARCHAR
CHAR
BLOB

Which data type is used in SQL to store true or false values?

2 Mark(s)

INT
BOOLEAN
VARCHAR
FLOAT

Which of the following is not a characteristic of a good database design?

2 Mark(s)

Data integrity
Data redundancy
Scalability
Efficiency

What is the purpose of normalization in a database?

2 Mark(s)

Increase data redundancy
Optimize query speed
Reduce data redundancy
Improve data security

Which SQL statement is used to retrieve data from a database?

2 Mark(s)

UPDATE
DELETE
INSERT
SELECT

In a database, what is a unique identifier for each record in a table called?

2 Mark(s)

Primary key
Secondary Key
Foreign KEY
Index key

What type of database model organizes data in tables with rows and columns?

2 Mark(s)

Hierarchical
Network
Relational
Object-Oriented

Which of the following are some common RDBMS in use?

2 Mark(s)

ORACLE
MYSQL
HEIDISQL
ALL OF THE ABOVE

Which of the following operators is used to compare two values in SQL?

2 Mark(s)

+
=
<>
&

Structured Query Language : Question 1 of 50

What does the LIKE operator do in SQL?

What does the LIKE operator do in SQL?

What is the purpose of the GROUP BY clause?

What is the purpose of the GROUP BY clause?

Which SQL keyword is used to remove duplicates from a result set?

Which SQL keyword is used to remove duplicates from a result set?

Which JOIN returns only the matching rows from both tables?

Which JOIN returns only the matching rows from both tables?

What does the SQL JOIN clause do?

What does the SQL JOIN clause do?

What is the default sorting order of ORDER BY clause?

What is the default sorting order of ORDER BY clause?

Which keyword is used to sort the result-set in SQL?

Which keyword is used to sort the result-set in SQL?

Which SQL function is used to count the number of rows?

Which SQL function is used to count the number of rows?

What does the WHERE clause do in SQL?

What does the WHERE clause do in SQL?

Which SQL statement is used to retrieve data from a database?

Which SQL statement is used to retrieve data from a database?