freetests4u.com

Online knowledge sharing platform

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

1.
A Database Management System (DBMS) is

Collection of interrelated data
Collection of programs to access data
Collection of data describing one particular enterprise
All of the above
All of the above
2.
A Relation is

Subset of Cartesian product of a list of attributes
Subset of Cartesian product of a list of domains
Subset of Cartesian product of a list of tuples
Subset of Cartesian product of a list of relation
Subset of Cartesian product of a list of tuples
3.
To remove a relation from an SQL database, we use the ______ command.

Delete
Purge
Remove
Drop table
Drop table
4.
SQL views can be used to hide:

columns and rows only.
complicated SQL syntax only.
both of the above can be hidden by an SQL view.
None of these.
both of the above can be hidden by an SQL view.
5.
Which two files are used during operation of the DBMS?

DML and query language
Data dictionary and transaction log
Query languages and utilities
Data dictionary and query language
Data dictionary and transaction log
6.
The user defined data type can be created using

Create data
Create datatype
Create type
Create definetype
Create type
7.
Which database level is closest to the users?

Internal
External
Physical
Conceptual
External
8.
Delete from r; r – relation
This command performs which of the following action ?

Clear relation entries
Remove relation
Delete fields
Delete rows
Clear relation entries
9.
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

From, select
Select, from
Where, from
From, where
Where, from
10.
The SQL statement to create a view is:

MAKE VIEW.
CREATE VIEW.
SELECT VIEW.
INSERT VIEW.
CREATE VIEW.
11.
The intersection operator is used to get the _____ tuples.

All
Common
Different
Repeating
Common
12.
A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

Empty tuple
New value
Null value
Old value
Null value
13.
In the ............, one transaction inserts a row in the table while the other transaction is half way through its browsing of table.

transaction read problem
one way read problem
phantom read problem
serial read problem
phantom read problem
14.
The predicate in a where clause can involve Boolean operations such as and.The result of true and unknown is_______, false and unknown is _____, while unknown and unknown is _____.

Unknown, unknown, false
True, false, unknown
True, unknown, unknown
Unknown, false, unknown
Unknown, false, unknown
15.
The first step in database development is which of the following?

Logical database design
Enterprise data modeling
Database Implementation
Physical database design and definition
Enterprise data modeling


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)