Database Test 6
Time Left: 00:30:00
Online Test > Online Database Test > Database Test 6 (Mock Test)
Loading Test...
Instruction:
Total number of questions : 20 .
Time alloted : 30 minutes.
Each question carry 1 mark, no negative marks.
1.
A database design may be based on existing data.
2.
The result of a SQL SELECT statement is a(n) ________ .
3.
To sort the results of a query use:
5.
A relation in this form is free of all modification anomalies.
6.
In a relation, the columns are sometimes called "attributes."
7.
Proper normalization eliminates duplicated data.
8.
One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
9.
An identifier typically uses more than one attribute.
10.
The default extension for an Oracle SQL*Plus file is:
11.
An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
12.
READ COMMITTED is the default isolation level.
13.
OLE DB tabular data providers present data in the form of rowsets.
14.
How many JDBC driver types does Sun define?
15.
The "F" in RFM analysis stands for ________ .
16.
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
17.
A benefit of the three-tier architecture is which of the following?
18.
Which of the following is part of an administrative policy to secure a database?
19.
A semijoin is which of the following?
20.
A collection of literals or object types is called a bag.
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...
