Structured Query Language

Which ANSI/ISO standard introduced the first official SQL specification in 1986?

2 Mark(s)

SQL-86
SQL-89
SQL-92
SQL-99

Backing up your SQL Server database is essential for _______ your data.

2 Mark(s)

replication
protecting
preventing
none of the mentioned

Which of the following SQL Server tools is used to enhance data management and governance?

2 Mark(s)

SSDT
OBEII
SSIT
All of the mentioned

When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.

2 Mark(s)

unlink
import
link
all of the mentioned

Which of the following is used to overcome the Replication in SQL Server?

2 Mark(s)

Availability problems
Maintenance problems
Performance problems
All of the mentioned

Which of the following is the main feature of dotConnect for SQL Server?

2 Mark(s)

Supports the latest versions of SQL Server
Extra data binding capabilities
Ability of monitoring query execution
All of the mentioned

Which is the default field terminator for bulk insert in SQL Server?

2 Mark(s)

Brackets
Parenthesis
Full stop
Comma

Which of the stored procedure is used to test the SQL injection attack?

2 Mark(s)

xp_reg
xp_write
xp_regwrite
all of the mentioned

User defined function in SQL Server can return ____________

2 Mark(s)

Result set
Scalar value
Set of values
All of the mentioned

DML triggers in SQL Server is applicable to _____________

2 Mark(s)

Update
Delete
Insert
All of the mentioned

Which of the following stored procedure is already defined in SQL Server?

2 Mark(s)

System defined Procedure
CLR Stored Procedure
Extended Procedure
User Defined Stored Procedure

Which of the following is the instance of SQL Server that is your production server in log shipping?

2 Mark(s)

secondary server
primary server c) secondary database d) primary database
secondary database
primary database

Which of the following pair of technology is supported in SQL Server?

2 Mark(s)

Which of the following pair of technology is supported in SQL Server?
Mirroring and Log Shipping
Mirroring and Replication
d) All of the mentioned

Who is credited with the creation of SQL?

2 Mark(s)

Alan Turing
Donald D. Chamberlin
Edgar F. Codd
John McCarthy

User defined function in SQL Server can return ____________

2 Mark(s)

Result set
Scalar value
Set of values
All of the mentioned

DML triggers in SQL Server is applicable to _____________

2 Mark(s)

Update
Delete
Insert
All of the mentioned

Which company introduced the first commercial relational database management system (RDBMS) based on SQL?

2 Mark(s)

Oracle Corporation
IBM
Microsoft Corporation
SAP SE

Which of the following stored procedure is already defined in SQL Server?

2 Mark(s)

System defined Procedure
CLR Stored Procedure
Extended Procedure
User Defined Stored Procedure

Which of the following stored procedure is already defined in SQL Server?

2 Mark(s)

System defined Procedure
CLR Stored Procedure
Extended Procedure
User Defined Stored Procedure

What was the initial name of SQL proposed by IBM?

2 Mark(s)

SEQUEL
DATA-QUERY
RELATIONAL
DB-QUERY

Exception handling is possible in SQL Server using _____________

2 Mark(s)

FINAL
FINALLY
THROW
All of the mentioned

In which year was the first paper outlining the relational model published by Edgar F. Codd?

2 Mark(s)

1960
1970
1980
1990

Which of the following language is used for procedural flow in SQL Server?

2 Mark(s)

Control-of-flow language
Flow language
Control language
None of the mentioned

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

Exception handling is possible in SQL Server using _____________

2 Mark(s)

FINAL
FINALLY
THROW
All of the mentioned

Which of the following language is used for procedural flow in SQL Server?

2 Mark(s)

Control-of-flow language
Flow language
Control language
None of the mentioned

Which SQL statement is used to update data in a database?

2 Mark(s)

MODIFY
REVISE
CHANGE
UPDATE

What will the SQL query SELECT * FROM Users WHERE FirstName = ‘John’ AND LastName = ‘Doe’; return?

2 Mark(s)

All users with the first name John.
All users with the last name Doe.
All users with the first name John or the last name Doe.
All users with the first name John and the last name Doe.

Which command is used to remove a table from a database?

2 Mark(s)

REMOVE
ERASE
DROP
DELETE

Which SQL keyword gives a nickname to a table (typically for the purpose of a join)?

2 Mark(s)

NICKNAME
AS
ALIAS
CALL

What SQL clause is used to filter the results of a query?

2 Mark(s)

FILTER BY
SELECT BY
WHERE
LOCATE

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

2 Mark(s)

GET
EXTRACT
FETCH
SELECT

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

2 Mark(s)

Group
Order
Group By
Order By

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

2 Mark(s)

MAKE
CREATE
INSERT
DEVELOP

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 filter NULL values
To delete duplicate records
To sort the result set

What command is used to create a new table in SQL?

2 Mark(s)

CREATE TABLE
BUILD TABLE
GENERATE TABLE
NONE OF THE ABOVE

What does the SQL LIKE operator do?

2 Mark(s)

Compares two values for equality
Finds rows that match a specified pattern
Calculates the sum of values
Sorts result in ascending or descending order

What does SQL stand for?

2 Mark(s)

Structured Question Language
Simple Query Language
Structured Query Language
System Query Language

Which of the following SQL Server tools is used to enhance data management and governance?

2 Mark(s)

SSDT
OBEII
SSIT
All of the mentioned

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 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 version of SQL standardized many features that are still in use today, such as joins and subqueries?

2 Mark(s)

SQL-86
SQL-89
SQL-92
SQL:1999

Which of the following is the main feature of dotConnect for SQL Server?

2 Mark(s)

Supports the latest versions of SQL Server
Extra data binding capabilities
Ability of monitoring query execution
All of the mentioned

Which SQL standard introduced support for object-oriented features, recursive queries, and XML data types?

2 Mark(s)

SQL:1999
SQL:2003
SQL:2006
SQL:2016

Which of the following is used to overcome the Replication in SQL Server?

2 Mark(s)

Availability problems
Maintenance problems
Performance problems
All of the mentioned

Which version of SQL introduced window functions and common table expressions (CTEs)?

2 Mark(s)

SQL:1999
SQL:2003
SQL:2006
SQL:2011

When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.

2 Mark(s)

unlink
import
Clink
all of the mentioned

In SQL, what is the purpose of the WHERE clause in a DELETE statement?

2 Mark(s)

Specifies which database to use
Specifies which table to delete from
Specifies which records to delete
Specifies how to order the records

Structured Query Language : Question 1 of 50

Which SQL statement is used to update data in a database?

Which SQL statement is used to update data in a database?

What will the SQL query SELECT * FROM Users WHERE FirstName = ‘John’ AND LastName = ‘Doe’; return?

What will the SQL query SELECT * FROM Users WHERE FirstName = ‘John’ AND LastName = ‘Doe’; return?

Which command is used to remove a table from a database?

Which command is used to remove a table from a database?

Which SQL keyword gives a nickname to a table (typically for the purpose of a join)?

Which SQL keyword gives a nickname to a table (typically for the purpose of a join)?

What SQL clause is used to filter the results of a query?

What SQL clause is used to filter the results of a query?

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

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

What does the SQL LIKE operator do?

What does the SQL LIKE operator do?

What does SQL stand for?

What does SQL stand for?