Database Test 2
Time Left: 00:30:00
Online Test > Online Database Test > Database Test 2 (Mock Test)
Loading Test...
Instruction:
Total number of questions : 20 .
Time alloted : 30 minutes.
Each question carry 1 mark, no negative marks.
1.
Applications are programs that interact directly with the database.
2.
Which of the following is the original purpose of SQL?
3.
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
4.
The primary key is selected from the:
5.
If attributes A and B determine attribute C, then it is also true that:
6.
We have normalized a table into BCNF if all candidate keys are determinants.
7.
A ternary relationship is so called because in contains two entities and one association between them.
8.
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
9.
The data model produced from the reverse engineering process is a true logical model.
10.
The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
11.
Sequences guarantee valid surrogate key values.
12.
Which of the three possible types of triggers does SQL Server support?
13.
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
14.
Most operational databases can be used for many BI applications.
15.
A supertype/subtype hierarchy is which of the following?
16.
The entity integrity rule states that:
17.
A null value is assigned when no other value applies.
18.
Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.
19.
A method defines the form or protocol of the operation, but not its implementation.
20.
An aggregation is a stronger form of association relationship and is represented with a solid diamond at the aggregate end.
Submit your test now to view the Results and Statistics with answer explanation.
Note:
Click the 'Submit Test' button given in the bottom of this page to Submit your answers.
Test will be submitted automatically if the time expired.
Don't refresh the page.
Marks : [XX/XX]
Total number of questions
:
[TQ]
Number of answered questions
:
[AQ]
Number of unanswered questions
:
[UQ]
Loading Test...
