freetests4u.com

Online knowledge sharing platform

CDAC-CCEE database system Mock test 2 (15 questions, time 15 minutes)

1.
The node where the distributed transaction originates is called the .......

starting coordinator
originating node
local coordinator
global coordinator

2.
If a database server is referenced in a distributed transaction, the value of its commit point strength determines which role it plays in the .........

two phase commit
two phase locking
transaction locking
checkpoints

3.
Select count (____ ID)
from teaches< where semester = ’Spring’ and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

Avg
Count
Distinct
Primary key

4.
Values of one type can be converted to another domain using which of the following ?

Cast
Drop type
Convert
Alter type

5.
The situation in which a transaction holds a data item and waits for the release of data item held by some other transaction, which in turn waits for another transaction, is called .......

process waiting
serialiable schedule
deadlock
concurrency

6.
Which of the following database activities require a specific knowledge of a DBMS?

Enterprise modeling
Logical database design
Conceptual data modeling
Physical database design and definition

7.
Most backup and recovery commands in ........... are executed by server sessions.

Recovery Manager
Backup Manager
Database Manager
Backup and Recovery Manager

8.
In case of any shut down during transaction before commit which of the following statement is done automatically ?

View
Commit
Rollback
Flashback

9.
Transaction processing is associated with everything below except

Maintaining a data
Recording a business activity
Producing detail summary or exception report
Conforming a action or triggering a response

10.
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

The missing values problem
The multivalue, multicolumn problem
The inconsistent values problem
The general-purpose remarks column problem

11.
___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails

Isolation
Atomicity
Durability
Consistency

12.
You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?

TINYINT
INT
SMALLINT
DECIMAL(1)

13.
........ systems typically allows to replace failed disks without stopping access to the system. A. RAM

RAD
RMAN
RAM
RAID

14.
Which utilities can we used to export data from sql server to a text file?

DTS export wizard
BCP
ISQL
a and b

15.
Which of the following is/are the Database server functions?
i) Data management
ii) Transaction management
iii) Compile queries
iv) Query optimization

i, ii, and iv only
i, ii and iii only
ii, iii and iv only
All i, ii, iii, and iv



CDAC CCEE Mock Tests

CDAC CCEE java mock test 1 (15 questions, 15 minutes)

CDAC CCEE java mock test 2 (15 questions, 15 minutes)

CDAC CCEE java mock test 3 (15 questions, 15 minutes)

CDAC CCEE java mock test 4 (15 questions, 15 minutes)

CDAC CCEE java mock test 5 (15 questions, 15 minutes)

CDAC CCEE c++ mock test 1 (15 questions, 15 minutes)

CDAC CCEE c++ mock test 2 (15 questions, 15 minutes)

CDAC CCEE c++ mock test 3 (15 questions, 15 minutes)

CDAC CCEE OS mock test 1 (15 questions, 15 minutes)

CDAC CCEE OS mock test 2 (15 questions, 15 minutes)

CDAC CCEE OS mock test 3 (15 questions, 15 minutes)

CDAC CCEE database systems mock test 1 (15 questions, 15 minutes)

CDAC CCEE database systems mock test 2 (15 questions, 15 minutes)