freetests4u.com

Online knowledge sharing platform


Warning: Missing argument 5 for Test::__construct(), called in /var/www/html/cdac-ccee-db-test-2.php on line 24 and defined in /var/www/html/test.php on line 10
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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Cast
Drop type
Convert
Alter type

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Recovery Manager
Backup Manager
Database Manager
Backup and Recovery Manager

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

View
Commit
Rollback
Flashback

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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)

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

RAD
RMAN
RAM
RAID

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

DTS export wizard
BCP
ISQL
a and b

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

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

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174

Notice: Undefined index: opt5 in /var/www/html/test.php on line 174



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)