IndiaBIX

Online Database Test - Database Test - Random

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.
To establish a range of values, < and > can be used.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
The different classes of relations created by the technique for preventing modification anomalies are called:
normal forms.
referential integrity constraints.
functional dependencies.
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 : The Relational Model and Normalization
3.
The primary key is selected from the:
composite keys.
determinants.
candidate keys.
foreign keys.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Relational Model and Normalization
4.
One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
5.
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
A domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
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 SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL for Database Construction
7.
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
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
8.
How can you find rows that do not match some specified condition?
EXISTS
Double use of NOT EXISTS
NOT EXISTS
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 : Database Redesign
9.
The data model produced from the reverse engineering process is a true logical model.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
10.
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
11.
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
12.
The default extension for an Oracle SQL*Plus file is:
.txt.
.pls.
.ora.
.sql.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
13.
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
14.
A differential backup makes a copy of the entire database.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
15.
In OLE DB, which of the following represents characteristics of the recordset abstraction?
Properties
Collections
Methods
Abstractions
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
16.
To run a compiled Java program, the machine must have what loaded and running?
Java virtual machine
Java compiler
Java bytecode
A Web browser
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
17.
In unsupervised data mining, explanations are created after patterns are found.
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
18.
Structured data may include which of the following?
Photo image
Video clip
Dates
None 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
19.
Relationships cannot have 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
20.
An atomic literal is which of the following?
Strings
Boolean
Long
All of the above.
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