IndiaBIX

Online Database Test - Database Test 8

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 is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
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
3.
Each entity is represented as a(n):
tuple.
table.
attribute.
file.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Models into Database Designs
4.
In a 1:1 relationship, the primary key placement is arbitrary.
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
5.
Before any changes to database structure are attempted one should first:
clearly understand the current structure and contents of the database only.
test any changes on a test database only.
create a complete backup of the operational database only.
All of the above should be done.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
6.
Changing cardinalities in a database is:
a common database design task.
a rare database design task, but does occur.
a database design task that never occurs.
is impossible to do, so a new database must be constructed and the data moved into it.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
7.
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
8.
A cursor type in which the application can only move forward through the recordset is called:
forward only.
static.
keyset.
dynamic.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
9.
In ODBC, a data source that is local to a single computer is called a:
system data source.
file data source.
user data source.
SQL text file.
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
10.
How does Tomcat execute a JSP?
As a CGI script
As an independent process
By one of Tomcat's threads
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
11.
The data warehouse DBMS needs to be the same DBMS used for the operational database.
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
12.
The systems development life cycle cannot be used with database implementation.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Development Process
13.
Which of the following conditions should exist if you want to convert a relationship to an associative entity?
Some of the relationships for the participating entities are "many".
The resulting associative entity has an independent meaning.
The resulting associative entity has no attributes.
All of the above
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Modeling Data in the Organization
14.
A rectangle represents which of the following in an EER?
Attribute
Entity
Optional One
Relationship
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : ER Model and Business Rules
15.
A subtype discriminator is which of the following?
An attribute of the supertype whose values determine the subtype
An attribute of the subtype whose values determine the supertype
An attribute of the supertype whose values determine the supertype
An attribute of the subtype whose values determine the subtype
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : ER Model and Business Rules
16.
The primary goal of physical database design is data processing efficiency.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Physical Database Design
17.
Hypertext Transfer Protocol (HTTP) is secure.
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.
Performance analysis and tuning is which of the following?
Undertaken one time at the time of a DBMS installation
Undertaken one time at the time of the implementation of a new application
Undertaken as an ongoing part of the backup of a database
Undertaken as an ongoing part of managing a database
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data and Database Administration
19.
Queries that do full table scans should be avoided.
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
20.
In an object diagram, an object is represented as a rectangle with two compartments.
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
*** 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