Online Database Test - Database Test 3



Loading...  Loading Test...

Instruction:

  • This is a FREE online test. DO NOT pay money to anyone to attend this test.
  • Total number of questions : 20.
  • Time alloted : 30 minutes.
  • Each question carry 1 mark, no negative marks.
  • DO NOT refresh the page.
  • All the best :-).


1.

In a database, data is stored in spreadsheets which have rows and columns.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Introduction to Database

Discuss about this problem : Discuss in Forum


2.

A benefit of using a stored procedure is that it can be distributed to client computers.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : SQL for Database Construction

Discuss about this problem : Discuss in Forum


3.

SQL Server indexes are special data structures used to improve performance.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


4.

SERIALIZABLE is the strictest isolation level.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


5.

FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : XML and ADO.NET

Discuss about this problem : Discuss in Forum


6.

JDBC stands for:

A.
Java Database Connectivity
B.
Java Database Components
C.
Java Database Control
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : JDBC, Java Server Pages, and MySQL

Discuss about this problem : Discuss in Forum


7.

With JSP, the coding is done in Java and only in Java.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : JDBC, Java Server Pages, and MySQL

Discuss about this problem : Discuss in Forum


8.

Business Intelligence (BI) systems do not obtain their data by which of the following means?

A.
Read and process data from an operational database
B.
Process transactions
C.
Process extracts from operational databases
D.
Process data purchased from data vendors

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Database Processing for BIS

Discuss about this problem : Discuss in Forum


9.

All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


10.

A relationship is an association representing the interaction between attributes.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Modeling Data in the Organization

Discuss about this problem : Discuss in Forum


11.

Weak entities do not get mapped into a relation.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Logical Database Design

Discuss about this problem : Discuss in Forum


12.

Denormalization and clustering can work well to minimize data access time for small records.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Physical Database Design

Discuss about this problem : Discuss in Forum


13.

How many tables may be included with a join?

A.
One
B.
Two
C.
Three
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


14.

The code to create triggers and routines is stored in only one location and is administered centrally.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


15.

Which of the following is true about ColdFusion Markup Language (CFML)?

A.
It is stored in .asp files.
B.
It is executed on the client.
C.
It does not use tags.
D.
It allows for coding of custom tags in an HTML file.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : The Internet Database Environment

Discuss about this problem : Discuss in Forum


16.

Client-side extensions:

A.
add functionality to the server.
B.
add functionality to the browser.
C.
add functionality to the firewall.
D.
add functionality to the network.

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Internet Database Environment

Discuss about this problem : Discuss in Forum


17.

Reconciled data is which of the following?

A.
Data stored in the various operational systems throughout the organization.
B.
Current data intended to be the single source for all decision support systems.
C.
Data stored in one operational system in the organization.
D.
Data that has been selected and formatted for end-user support applications.

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Warehousing

Discuss about this problem : Discuss in Forum


18.

Concurrency control is important for which of the following reasons?

A.
To ensure data integrity when updates occur to the database in a multiuser environment
B.
To ensure data integrity when updates occur to the database in a single-user environment
C.
To ensure data integrity while reading data occurs to the database in a multiuser environment
D.
To ensure data integrity while reading data occurs to the database in a single-user environment

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data and Database Administration

Discuss about this problem : Discuss in Forum


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.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Distributed Databases

Discuss about this problem : Discuss in Forum


20.

The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Object-Oriented Database

Discuss about this problem : Discuss in Forum


Submit your test now to view the Results and Statistics with answer explanation.