|
Question
|
Option1
|
Option2
|
Option3
|
Option4
|
Option5
|
Answer
|
|
|
The full form of DDL is
|
Dynamic Data Language
|
Detailed Data Language
|
Data Definition Language
|
Data Derivation Language
|
|
C
|
Edit |
Details |
Delete
|
|
he method of access which uses key transformation is known as
|
direct.
|
hash.
|
random
|
sequential.
|
|
B
|
Edit |
Details |
Delete
|
|
A report generator is used to
|
update files.
|
print files on paper.
|
delete files.
|
data entry.
|
|
B
|
Edit |
Details |
Delete
|
|
Relational calculus is a
|
Procedural language.
|
Non- Procedural language.
|
Data definition language.
|
High level language
|
|
B
|
Edit |
Details |
Delete
|
|
In the relational modes, cardinality is termed as:
|
Number of tuples
|
Number of attributes.
|
Number of tables.
|
Number of constraints.
|
|
A
|
Edit |
Details |
Delete
|
|
Can this query be executed and is it useful (according to the table and column definitions)?
SELECT CTITLE, CID
FROM COURSES
WHERE CID = '7820'
|
Query cannot be executed (gives a syntax error).
|
Query can be executed and makes sense (according to the table and column definitions).
|
Query can be executed but returns nonsense.
|
|
|
B
|
Edit |
Details |
Delete
|
|
What does SQL stand for?
|
Structured Query Language
|
Strong Question Language
|
Structured Question Language
|
Simple Query Language
|
|
A
|
Edit |
Details |
Delete
|
|
What does the abbreviation DBMS stand for?
|
Digital Base Mapping System
|
Database Manipulation Software
|
Database Management System.
|
Data Borrowing and Movement Software.
|
None of above
|
C
|
Edit |
Details |
Delete
|
|
ndexed views work best when the underlying data is infrequently updated.
|
False
|
True
|
|
|
|
B
|
Edit |
Details |
Delete
|
|
What is the default "SORT" order for a SQL?
|
Ascending
|
Descending
|
|
|
|
A
|
Edit |
Details |
Delete
|
|
Which feature converts row data to column for better analytical view?
|
Pivot
|
Random
|
Both
|
|
|
A
|
Edit |
Details |
Delete
|
|
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
|
Lock level
|
Transaction isolation level
|
Cursor concurrency setting
|
Locking hints
|
|
A
|
Edit |
Details |
Delete
|
|
The strictest transaction isolation level provided by SQL Server is called:
|
REPEATABLE READ.
|
SERIALIZABLE.
|
READ COMMITTED.
|
READ UNCOMMITTED
|
|
B
|
Edit |
Details |
Delete
|
|
How many tables may be included with a join?
|
One
|
Two
|
Three
|
All of the above.
|
|
D
|
Edit |
Details |
Delete
|
|
A CASE SQL statement is which of the following?
|
A way to establish an IF-THEN-ELSE in SQL.
|
A way to establish a loop in SQL.
|
A way to establish a data definition in SQL.
|
All of the above.
|
|
A
|
Edit |
Details |
Delete
|
|
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
|
ONLY
|
UNIQUE
|
DISTINCT
|
SINGLE
|
|
C
|
Edit |
Details |
Delete
|
|
Which one of the following sorts rows in SQL?
|
SORT BY
|
ALIGN BY
|
ORDER BY
|
GROUP BY
|
|
C
|
Edit |
Details |
Delete
|
|
ON UPDATE CASCADE ensures which of the following?
|
Normalization
|
Data Integrity
|
Materialized Views
|
All of the above.
|
|
B
|
Edit |
Details |
Delete
|
|
The wildcard in a WHERE clause is useful when?
|
An exact match is necessary in a SELECT statement.
|
An exact match is not possible in a SELECT statement.
|
An exact match is necessary in a CREATE statement.
|
An exact match is not possible in a CREATE statement.
|
|
B
|
Edit |
Details |
Delete
|