IndiaBIX

Online Database Test - Database Test 4

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.
Because it contains a description of its own structure, a database is considered to be ________ .
described
metadata compatible
self-describing
an application program
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to Database
2.
The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
3.
When the parent entity is required, a new child row can always be inserted.
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
4.
What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL for Database Construction
5.
Which prefixes are available to Oracle triggers?
:new only
:old only
Both :new and :old
Neither :new nor :old
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
6.
Which JDBC driver Types are for use over communications networks?
Type 3 only
Type 4 only
Both Type 3 and Type 4
Neither Type 3 nor Type 4
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.
What is bytecode?
Machine-specific code
Java code
Machine-independent code
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
8.
What servlet processor was developed by Apache Foundation and Sun?
Apache Tomcat
Apache Web server
Sun servlet processor
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
9.
Java bytecode is machine-specific code.
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
10.
Even though Java is machine-independent, JSPs are not.
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
11.
In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.
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 database approach requires additional costs and risks.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
13.
A time stamp is a time value that is associated with a data value.
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
14.
Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Advanced SQL
15.
A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Client-Server Database
16.
Information repositories are replacing data dictionaries in many organizations.
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
17.
A distributed database is which of the following?
A single logical database that is spread to multiple locations and is interconnected by a network
A loose collection of file that is spread to multiple locations and is interconnected by a network
A single logical database that is limited to one location.
A loose collection of file that is limited to one location.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
18.
Which of the following statement is true concerning objects and/or classes?
An object is an instance of a class.
A class is an instance of an object.
An object includes encapsulates only data.
A class includes encapsulates only data.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Object-Oriented Data Modeling
19.
The UML notation is useful for graphically depicting an object-oriented analysis or design model.
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.
The ODMG Object Model requires that a relationship be specified in both directions.
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