Hello Guest !
Login
Home
Job Seeker's Login
Employer's Zone
Placement Paper
Online Test
Resume writing
Online Tutorial
Groups
Jobseeker Login
Search Jobs
My Saved Jobs
Test Menu
Quizzes Home Page
Test Category
Aptitude Test
Asp.Net
Brain-Quiz
C - Language
C++
Computer Science
Electrical Engineering
English grammar
General Knowledge
HR Policy
HTML
IQ Test
Java
MS Office
Networking Basics
PHP
RDBMS Test
Search Engine Optimization
Software Testing
VB.NET
Web Design
RDBMS Test Questions
You got
To finish
1.
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
2.
What statement do you use to remove a schema and ensure that the removal takes place only if the schema is empty?
DROP SCHEMA RESTRICT
DROP SCHEMA OPTS
DROP SCHEMA CASCADE
DROP SCHEMA CLEAR
3.
In your program you want to use the JDBC-ODBC Bridge driver. What code do you use?
Class.callName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.callfunc("JdbcOdbcDriver");
Class.Name.init("sun.jdbc.odbc.JdbcOdbcDriver");
4.
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.
5.
Reconciled data is which of the following?
Data stored in the various operational systems throughout the organization.
Current data intended to be the single source for all decision support systems.
Data stored in one operational system in the organization.
Data that has been selected and formatted for end-user support applications.
6.
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.
7.
Which of the following are valid rowset classes that you can use in your Java application ?
A CachedRowSet class
A JavaSource class
A WebRowSet class
Either AC&D
8.
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
9.
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
10.
JDBC stands for:
Java Database Connectivity
Java Database Components
Java Database Control
None of the above is correct.
11.
Concurrency control is important for which of the following reasons?
To ensure data integrity when updates occur to the database in a multiuser environment
To ensure data integrity when updates occur to the database in a single-user environment
To ensure data integrity while reading data occurs to the database in a multiuser environment
To ensure data integrity while reading data occurs to the database in a single-user environment
12.
A shared database should:
be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
13.
Business Intelligence (BI) systems do not obtain their data by which of the following means?
Read and process data from an operational database
Process transactions
Process extracts from operational databases
Process data purchased from data vendors
14.
Which of the following are valid CREATE statements in the world of DDL?
CREATE SCHEMA
CREATE TABLE
CREATE DOMAIN
All of the above
15.
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
16.
The three-schema components include all, but:
internal schema.
conceptual schema.
programming schema.
external schema.
17.
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.
18.
Client-side extensions:
add functionality to the server.
add functionality to the browser.
add functionality to the firewall.
add functionality to the network.
19.
What is used by a properly designed DBMS to enable databases to be returned to the pre-transaction state should errors occur?
two phase commit
prefetch transaction
one phase commit
All of the above
20.
Which of the following is true about ColdFusion Markup Language (CFML)?
It is stored in .asp files.
It is executed on the client.
It does not use tags.
It allows for coding of custom tags in an HTML file.
There are 20 questions.
Top Rankers
Ravi shankar tripathi
80%
RDBMS Test
Ravi shankar tripathi
80%
RDBMS Test
Sharad k pawar
70%
RDBMS Test
Dharmendra pandey
65%
RDBMS Test
Bajeerao Baburao Ghevade
65%
RDBMS Test
About Us
|
Tell to Friend
|
Terms of Use
|
Contact Us
|
Privacy Policy
|
RSS
Copyright © 2013
InetFresherJobs
. All Rights Reserved.
