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

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 is the default field terminator for bulk insert in SQL Server?

2 Mark(s)

Brackets
Parenthesis
Full stop
Comma

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

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 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 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

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

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

2 Mark(s)

GET
EXTRACT
FETCH
SELECT

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

2 Mark(s)

FILTER BY
SELECT BY
WHERE
LOCATE

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.

2 Mark(s)

unlink
import
Clink
all of the mentioned

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 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 SQL standard introduced JSON data types and support for temporal data?

2 Mark(s)

SQL:2011
SQL:2013
SQL:2016
SQL:2016

Backing up your SQL Server database is essential for _______ your dat

2 Mark(s)

replication
protecting
preventing
none of the mentioned

Which organization is responsible for maintaining the SQL standard?

2 Mark(s)

American National Standards Institute (ANSI)
International Organization for Standardization (ISO)
Institute of Electrical and Electronics Engineers (IEEE)
World Wide Web Consortium (W3C)

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

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

Identify the error in
"ALTER TABLE Students DROP COLUMN DateOfBirth date;"

2 Mark(s)

ALTER
DROP COLUMN
DateOfBirth
date

Correct the syntax error in
"CREATE TABLE Students (ID int PRIMARY, Name varchar(50));"

2 Mark(s)

PRIMARY
ID int
Name varchar(50)
CREATE TABLE Hide

What does the UPDATE command in SQL do?

2 Mark(s)

Deletes a record
Modifies an existing record
Adds a new record
Retrieves data

What does SQL stand for?

2 Mark(s)

Structured Query Language
Sequential Query Language
Structured Question Language
Server Query Language

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
secondary database
primary 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

Structured Query Language : Question 1 of 50

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

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

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

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

What does the SQL LIKE operator do?

What does the SQL LIKE operator do?

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)?