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.
The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
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.
Any table that meets the definition of a relation is said to be in first normal form.
True
False
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.
In a relation, the columns are sometimes called "attributes."
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Relational Model and Normalization
5.
A regular subquery can be processed:
from the top down.
from the bottom up.
by nesting.
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
6.
The size of a lock is referred to as lock sizing.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Multiuser Databases
7.
To see the contents of the SQL*Plus buffer, type:
CONTENTS.
BUFFER.
CURRENT.
LIST.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
8.
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
are case insensitive.
are case sensitive.
must always be in lower case.
must always be in upper case.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
9.
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
10.
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
Open [FileName]
Show [FileName]
Alter [FileName]
Edit [FileName]
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Managing Databases with Oracle
11.
The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
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.
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
13.
With XML, document structure, content and format are all defined within one document.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
14.
Web page display is the most important application of XML.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : XML and ADO.NET
15.
JDBC Type 1 drivers are JDBC-ODBC bridge drivers.
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
16.
A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.
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
17.
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
18.
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
First normal form
Second normal form
Third normal form
Fourth normal form
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Logical Database Design
19.
XML is which of the following?
A scripting language that states the rules for tagging elements.
A programming language that states the rules for tagging elements.
A programming language that allows the creation of customized tags.
A scripting language that allows the creation of customized tags.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Internet Database Environment
20.
Multiplicity is the same as what concept for an ERD?
Relationship
Attribute
Entity
Cardinality
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