Structured Query Language

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

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

2 Mark(s)

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

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

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

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

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

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

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

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

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 keyword is used to sort the result-set in SQL?

2 Mark(s)

ORDER
GROUP
SORT
SORT

What is the default sorting order of ORDER BY clause?

2 Mark(s)

Random
Descending
Ascending
Alphabetical

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

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

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)

:
%
-
;

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

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

2 Mark(s)

UPDATE
DELETE
INSERT
SELECT

Structured Query Language : Question 1 of 50

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?

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

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

What is the default sorting order of ORDER BY clause?

What is the default sorting order of ORDER BY clause?

What does the SQL JOIN clause do?

What does the SQL JOIN clause do?

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?