IndiaBIX

Online Database Test - Database Test 5

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.
Which of the following projects illustrates a database being designed from existing data?
A database using the Production Department's spreadsheets
A database designed to produce production reports for a new Production Department manufacturing process
A database that will combine two databases currently used by the Production Department
None of the above is correct.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to Database
2.
A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
3.
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
4.
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
first step.
second step.
third step.
fourth step.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
5.
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Two
Three
Four
Six
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Models into Database Designs
6.
A foreign key is used to implement relationships between tables.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Models into Database Designs
7.
The data model produced from the reverse engineering process does not include intersection table data.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
8.
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Nonrepeatable read
Phantom read
Dirty read
Consistent read
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
9.
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
10.
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
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.
HTML is an application of a more robust document markup language called:
XHTML.
XML.
SGML.
None of the above is correct.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
12.
OLAP uses measures, dimensions and associations.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Processing for BIS
13.
Which of the following types of databases are the most common?
Personal
Workgroup
Department
Enterprise
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
14.
A binary relationship is a relationship between two or more entities.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Explanation:

Binary relationship is the relationship between two entities. Not more than two.

Discuss about this problem : Discuss in Forum
Learn more problems on : Modeling Data in the Organization
15.
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Logical Database Design
16.
Both ASP and ColdFusion allow for the coding of custom tags within an HTML document.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
17.
Every key used to join the fact table with a dimensional table should be a surrogate key.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Warehousing
18.
The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Overlapping rule
Disjoint rule
Total specialization rule
Partial specialization rule
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Object-Oriented Data Modeling
19.
Composition does not allow an object to be part of more than one aggregate object.
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
20.
An atomic literal is which of the following?
Strings
Boolean
Long
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