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.
To sort the results of a query use:
SORT BY.
GROUP BY.
ORDER BY.
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 SQL
2.
Indexes can usually be created for both primary and secondary keys.
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.
In a relation, the rows are sometimes called "records."
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
4.
Read-only databases are ________ updated.
always
commonly
seldom
never
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
5.
We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
6.
The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
7.
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
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
8.
An intersection table is required to represent M:N relationships.
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
9.
Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL for Database Construction
10.
The overall responsibility of the DBA is to facilitate the development and use of the database.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
11.
A user data source is one that can be shared among database users.
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.
To eliminate definition duplication, XML Schemas define:
an intersection table.
global elements.
a normalized definition table.
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
13.
The expression FOR XML RAW tells SQL Server to:
place the values of the columns as attributes in the resulting XML document.
place the values of the columns into elements rather than attributes.
place some columns into elements and others into attributes.
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
14.
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
15.
A data warehouse is a database system that is optimized for operational transaction processing.
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
16.
When mapping a binary many-to-many relationship into a relation which of the following is true?
One relation is created.
Two relations are created.
Three relations are created.
Four relations are created.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Logical Database Design
17.
XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.
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
18.
A data warehouse is which of the following?
Can be updated by end users.
Contains numerous naming conventions and formats.
Organized around important subject areas.
Contains only current data.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Warehousing
19.
A homogenous 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
20.
The fact that the same operation may apply to two or more classes is called what?
Inheritance
Polymorphism
Encapsulation
Multiple classification
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