Online knowledge sharing platform
CDAC-CCEE database system Mock test 2 (15 questions, time 15 minutes)
The node where the distributed transaction originates is called the .......
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
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.
Values of one type can be converted to another domain using which of the following ?
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 .......
Which of the following database activities require a specific knowledge of a DBMS?
Logical database design
Conceptual data modeling
Physical database design and definition
Most backup and recovery commands in ........... are executed by server sessions.
Backup and Recovery Manager
In case of any shut down during transaction before commit which of the following statement is done automatically ?
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
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
___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails
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?
........ systems typically allows to replace failed disks without stopping access to the system. A. RAM
Which utilities can we used to export data from sql server to a text file?
DTS export wizard
a and b
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)