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 Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
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
3.
An attribute that names or identifies entity instances is a(n):
entity.
attribute.
identifier.
relationship.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Modeling with ER Model
4.
Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
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
5.
The data model produced from the reverse engineering process is a true logical model.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
6.
An ACID transaction is one that is atomic, consistent isolated, and durable.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
7.
An Oracle System Change Number (SCN):
is a value that is incremented whenever a dirty read occurs.
is incremented whenever a deadlock occurs.
is a value that keeps track of explicit locks.
is a value that is incremented whenever database changes are made.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
8.
You can use the DROP statement to remove structures from the database.
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.
SQL Server supports two kinds of indexes: clustered and nonclustered.
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.
In OLE DB, actions that an object can perform are called:
properties.
collections.
methods.
abstractions.
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.
ODBC is a foundation of data access in the specifically Microsoft world.
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
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.
XML uses the same terms with the same meanings as terms in the database world.
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
14.
JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : JDBC, Java Server Pages, and MySQL
15.
Structured data may include which of the following?
Photo image
Video clip
Dates
None of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
16.
A supertype can only have only one subtype.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : ER Model and Business Rules
17.
ODBC requires the specific driver.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Client-Server Database
18.
Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data and Database Administration
19.
Some of the columns of a relation are at different sites is which of the following?
Data Replication
Horizontal Partitioning
Vertical Partitioning
Horizontal and Vertical Partitioning
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
20.
Which of the following is true concerning an ODBMS?
They have the ability to store complex data types on the Web.
They are overtaking RDBMS for all applications.
They are most useful for traditional, two-dimensional database table applications.
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 Database
*** 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