Structured Query Language

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

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

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

2 Mark(s)

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

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

2 Mark(s)

Brackets
Parenthesis
Full stop
Comma

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

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

2 Mark(s)

replication
protecting
preventing
none 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

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

What does the UPDATE command in SQL do?

2 Mark(s)

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

Correct the syntax error in
"DELETE FROM Employees HAVING Age < 25;"

2 Mark(s)

DELETE keyword
FROM keyword
HAVING keyword
No syntax error

Identify the error in
"UPDATE Employees SET Salary = Salary * 1.05 WHERE;"

2 Mark(s)

UPDATE keyword
SET keyword
WHERE clause
No error

How does a transaction ensure data integrity in SQL?

2 Mark(s)

By locking the database
By allowing multiple users to modify data simultaneously
By ensuring all operations within the transaction are completed before committing
By automatically updating all related tables

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

Which of the following is NOT a category of SQL commands?

2 Mark(s)

Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Connection Language (DCL)
Data Control Language (DCL Da

Which of the following best describes the purpose of SQL?

2 Mark(s)

To design websites
To manage and manipulate databases
To create graphical user interfaces
To develop mobile applications

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

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)

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

2 Mark(s)

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

User defined function in SQL Server can return ____________

2 Mark(s)

Result set
Scalar value
Set of values
All of the mentioned

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

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

2 Mark(s)

Having
Select
Where
Group by

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

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

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

2 Mark(s)

UPDATE
DELETE
INSERT
SELECT

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

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

Who is credited with the creation of SQL?

2 Mark(s)

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

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

2 Mark(s)

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

Structured Query Language : Question 1 of 50