IndiaBIX

Online Database Test - Database Test 7

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 HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Introduction to SQL
2.
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
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.
In the relational model, relationships between relations or tables are created by using:
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.
When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.
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 is not true about surrogate keys?
They are short.
They are fixed.
They have meaning to the user.
They are numeric.
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.
For every relationship, how many possible sets of minimum cardinalities are there?
Two
Three
Four
Six
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Data Models into Database Designs
7.
All primary keys are required.
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
8.
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
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
9.
Information systems and organizations do not just influence each other; they create each other.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Redesign
10.
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
11.
SQL*Plus is a text editor.
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.
SQL Server automatically creates an index on:
primary keys only.
foreign key only.
both primary and foreign keys.
SQL Server never automatically creates an index.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : SQL Server 2000
13.
In OLE DB, actions that an object can perform are called:
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
14.
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
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
15.
Business Intelligence (BI) reporting analyses can be performed using ________ .
standard SQL only
extensions to SQL only
OLAP only
both standard SQL and extensions to SQL
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Database Processing for BIS
16.
Another name for multimedia data is unstructured data.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Database Environment
17.
A function returns one value and has only output parameters.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Advanced SQL
18.
Which of the following statements is true concerning JDBC?
It is language independent.
It is similar in concept to ODBC.
It is useful for all object-oriented languages.
It consists of three main layers.
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : The Client-Server Database
19.
Data replication is favored where most process requests are read-only and where the data are relatively static.
True
False
Your Answer: Option
(Not Answered)
Correct Answer: Option
Discuss about this problem : Discuss in Forum
Learn more problems on : Distributed Databases
20.
Which of the following is true concerning the following statement: class Manager extends Employee
Manager is a concrete class and a superclass.
Manager is a concrete class and a subclass.
Manager is an abstract class and a superclass.
Manager is an abstract class and a subclass.
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