IndiaBIX

Online Database Test - Database Test 1

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.
Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.
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.
ORDER BY can be combined with the SELECT statements.
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.
Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Weak entity
Strong entity
ID-dependent entity
ID-independent entity
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Modeling with ER Model
4.
Which of the following situation requires the use of ID-dependent entities?
Association relationships only
Multivalued attributes only
Archetype/instance relationships only
All of the above use ID dependent entities
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.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
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
6.
The ODBC core API consists of which of the following functions?
Commit or rollback transactions only
Connect to data sources with driver-specific information only
Connect to data sources only
Both 1 and 3 above are in the OBDC core API.
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
7.
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
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
8.
What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?
SOAP
SGML
SQL
ADO
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
9.
Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.
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.
A shared database should:
be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
11.
The primary mechanism for providing context for data is metadata.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
12.
Database management systems were first introduced in the 1950s.
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.
The three-schema components include all, but:
internal schema.
conceptual schema.
programming schema.
external schema.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Development Process
14.
When mapping a supertype/subtype relationship which of the following is true?
The supertype primary key is assigned to each subtype.
The subtype primary key is assigned to each supertype.
There is no link between the supertype/subtype entities.
There is no primary key/foreign key relationship between a supertype/subtype.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Logical Database Design
15.
Well-structured relations encourage anomalies of data.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Logical Database Design
16.
Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
Both TCP and IP are needed.
TCP is needed but IP is not needed.
TCP is not needed but IP is needed.
Neither TCP and IP are needed.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
17.
A server-side extension is needed to do what?
Allow a request from a client to access the database.
Allow a request from a client to access a HTML-formatted page.
Allow a request from a client to access Web pages.
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
18.
The problem of concurrency control is more complex in a distributed database.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
19.
An operation that alters the state of an object is known as a constructor operation.
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.
An attribute's value is always literal.
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