IndiaBIX

Online Database Test - Database Test - Random

Instruction:
  • This is a FREE online test. Beware of scammers who ask for money to attend this test.
  • Total number of questions: 20.
  • Time allotted: 30 minutes.
  • Each question carries 1 mark; there are no negative marks.
  • DO NOT refresh the page.
  • All the best!

Marks : 2/20

Total number of questions
20
Number of answered questions
0
Number of unanswered questions
20
Test Review : View answers and explanation for this test.
1.
The DBMS that is most difficult to use is ________ .
Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to Database
2.
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
IDMS
DB2
dBase-II
R:base
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to Database
3.
A database has a built-in capability to create, process and administer itself.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to Database
4.
The condition in a WHERE clause can refer to only one value.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
5.
Relations are categorized into normal forms according to the referential integrity constraints that they have.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Relational Model and Normalization
6.
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Weak entity
Strong entity
ID-dependent entity
ID- independent entity
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Modeling with ER Model
7.
Properties that describe the characteristics of entities are called:
entities.
attributes.
identifiers.
relationships.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Modeling with ER Model
8.
Oracle allows the ORDER BY clause in view definitions.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
9.
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
10.
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : ODBC, OLE DB, ADO, and ASP
11.
The most popular way to materialize XML documents is to use:
DTD.
XSLT.
HTML.
SOAP.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
12.
Stylesheets are used by XSLT to indicate how to transform the elements of the XML document into another format.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
13.
An entity name should be which of the following?
A singular noun
Specific to the organization
Concise
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Modeling Data in the Organization
14.
An enterprise key is a primary key whose value is unique for a given relation.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Logical Database Design
15.
Which of the following are integrity controls that a DBMS may support?
Assume a default value in a field unless a user enters a value for that field.
Limit the set of permissible values that a field may assume.
Limit the use of null values in some fields.
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Physical Database Design
16.
Which of the following statements is true concerning JDBC?
It is language independent.
It is similar in concept to ODBC.
It is useful for all object-oriented languages.
It consists of three main layers.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Client-Server Database
17.
A heterogeneous distributed database is which of the following?
The same DBMS is used at each location and data are not distributed across all nodes.
The same DBMS is used at each location and data are distributed across all nodes.
A different DBMS is used at each location and data are not distributed across all nodes.
A different DBMS is used at each location and data are distributed across all nodes.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
18.
Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
19.
A constructor operation does which of the following?
Creates a new instance of a class
Updates an existing instance of a class
Deletes and existing instance of a class
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Object-Oriented Data Modeling
20.
A derived element is typically shown by placing either a slash (/) or a stereotype of <> before the name of the element.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Object-Oriented Data Modeling
*** END OF THE TEST ***
Time Left: 00:29:56
Post your test result / feedback here:

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers