IndiaBIX

Online Database Test - Database Test 9

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.
SQL query and modification commands make up a(n) ________ .
DDL
DML
HTML
XML
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
UNIQUE
DISTINCT
SINGLE
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
3.
The SQL keyword(s) ________ is used with wildcards.
LIKE only
IN only
NOT IN only
IN and NOT IN
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
4.
A subquery in an SQL SELECT statement is enclosed in:
braces -- {...}.
CAPITAL LETTERS.
parenthesis -- (...) .
brackets -- [...].
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
5.
Multivalued dependencies should ________ be eliminated.
always
commonly
seldom
never
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Design Using Normalization
6.
Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
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
7.
Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Supertype entity
Subtype entity
Archetype entity
Instance 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
8.
Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL for Database Construction
9.
The SQL statement used to create a view is CREATE VIEW.
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
10.
A tool that can help designers understand the dependencies of database structures is a:
dependency graph.
data model.
graphical display.
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
11.
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
12.
Money is defined in Oracle with the Currency data type.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
13.
Legacy data is which of the following?
Data contained in a newly-installed system
Data rejected during the installation of a new system
Data contained in a file system
Data contained by a system used prior to the installation of a new system
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
14.
Which of the following is true for a relational database?
Data is represented by tables.
It is difficult to access data.
Complex programs have to be written for simple queries.
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
15.
If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
True
False
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.
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
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.
Hashing algorithm converts a primary key value into a record address.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Physical Database Design
18.
ROLLBACK WORK asks SQL to empty the log file.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Advanced SQL
19.
Activities of a DBMS occur in the processing component logic.
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
20.
The extract process is which of the following?
Capturing all of the data contained in various operational systems
Capturing a subset of the data contained in various operational systems
Capturing all of the data contained in various decision support systems
Capturing a subset of the data contained in various decision support systems
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Warehousing
*** 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