IndiaBIX

Online Database Test - Database Test 3

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.
In a database, data is stored in spreadsheets which have rows and columns.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to Database
2.
A benefit of using a stored procedure is that it can be distributed to client computers.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL for Database Construction
3.
SERIALIZABLE is the strictest isolation level.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
4.
SQL Server indexes are special data structures used to improve performance.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
5.
FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document.
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
6.
JDBC stands for:
Java Database Connectivity
Java Database Components
Java Database Control
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 : JDBC, Java Server Pages, and MySQL
7.
With JSP, the coding is done in Java and only in Java.
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
8.
Business Intelligence (BI) systems do not obtain their data by which of the following means?
Read and process data from an operational database
Process transactions
Process extracts from operational databases
Process data purchased from data vendors
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Processing for BIS
9.
All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
10.
A relationship is an association representing the interaction between attributes.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Modeling Data in the Organization
11.
Weak entities do not get mapped into a 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
12.
Denormalization and clustering can work well to minimize data access time for small records.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Physical Database Design
13.
How many tables may be included with a join?
One
Two
Three
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Advanced SQL
14.
The code to create triggers and routines is stored in only one location and is administered centrally.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Advanced SQL
15.
Client-side extensions:
add functionality to the server.
add functionality to the browser.
add functionality to the firewall.
add functionality to the network.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
16.
Which of the following is true about ColdFusion Markup Language (CFML)?
It is stored in .asp files.
It is executed on the client.
It does not use tags.
It allows for coding of custom tags in an HTML file.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
17.
Reconciled data is which of the following?
Data stored in the various operational systems throughout the organization.
Current data intended to be the single source for all decision support systems.
Data stored in one operational system in the organization.
Data that has been selected and formatted for end-user support applications.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Warehousing
18.
Concurrency control is important for which of the following reasons?
To ensure data integrity when updates occur to the database in a multiuser environment
To ensure data integrity when updates occur to the database in a single-user environment
To ensure data integrity while reading data occurs to the database in a multiuser environment
To ensure data integrity while reading data occurs to the database in a single-user environment
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data and Database Administration
19.
With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
20.
The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.
True
False
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