Classic Jhumka Earrings Silver INR 113.00 Free Shipping Buy Now

Black Jhumka Earrings & Studs INR 94.00 Free Shipping Buy Now

Classic Jhumka Earrings Silver INR 207.00 Free Shipping Buy Now

Beautiful stud earing INR 93.00 Free Shipping Buy Now

Different Size Hoop and Stud Earrings Set INR 243.00 Free Shipping Buy Now

Golden Hoop Earing INR 70.00 Free Shipping Buy Now

Home Questions & Answer Technology Questions & Answers Data Base Questions & Answers

Data Base Questions & Answers (Compiled from UPSC, SSC ,PSC ,IBPS previous question papers)

A ROLLBACK command in a transaction…………..
Aundoes the effects of the last UPDATE command
Brestores the content of the database to its state at the end of the previous day
Cdoes nothing
Dmakes sure that all changes to the database are in effect
Eundoes all changes to the database resulting from the execution of the transaction

When you visit certain Websites spyware may be automatically downloaded. This is called a………….
Adrive-by download

An internet diary of grouping of ongoing commentaries is known as a(n) ………
Ablog

Directions (next five questions) : Each question below has two blanks. Each blank indicating that something has been omitted. Choose the set of words for each blank that best fits the meaning of the sentence as a whole.

Metadata does not enable database designers users to :
AUnderstand what the data mean
Bknow what the fine distinctions are between similar data items
Cunderstand what data exist
Dsample data

Eknow more about the data

A table in a relational database terminology is synonymous with :
Aa value
Ba row
Can attribute
Da column
Ea relation

What markup language includes all of the features of HTML and programming extensions ?
AApplets
BHTTP
CSML
DXML

EFTP

A…………store(s) data in two-dimensional tables.
AHierarchical Database
BTable Database
CRelational Database

DNetwork and Hierarchical
ENetwork Database

A…………is a computer connected to two networks.
Abridgeway
Bserver
Clink
Dgateway

Emodem

Downloadable software extensions that add new features to a browser are known as :
Aplug-in

Web servers should be configured so that :
Aunauthorized access is always possible
Bunauthorized access is restricted

Cany form of access is impossible
Dunauthorized access is sometimes possible
Eunauthorized access is unrestricted

The hierarchical database organizes data in a(n) :
Aflat file
Btuple
COODBMS
Drelation ile
Etreelike structure

Which of the following is a small program embedded within a GIF image ?
AWeb bug

BCookie
CWeb deceiver
DSpam
ESpyware application

A(n)…….accesses the database and data dictionary in a DBMS as they exist on a storage device.
Aapplication generation sub-system
BDBMS engine

CData engine
Ddata administration system
Edata definition subsystem

A text or an image which, when clicked, takes the user to another Website/page………….
AA Wiki
BA hyperlink

CThe top-level domain
DAn e-mail
EA blog

The……….key in a relational database links one table to another.
Asecondary
Brelational
Coperational
Dlinker
Eforeign

Which one of the following control steps is usually not performed in data warehousing applications
AMonitor summary tables for regular use

BCleaning meta data from being used interactively.
CControl meta data from being used interactively.
DReconcile data moved between the operations environment and data warehouse
EMonitor the data purging plan

Map entities, attributes and relations in Oracle is represented by ………….
ASpecial Schema
BConceptual and Physical Schema

CLogical Schema
DPhysical Schema
EConceptual Schema

The oracle environment of database is called as ……..
AData type
BData structure
CDatabase instances
DDatabase schema

EData values

The oracle environment of database is called as ……..
AData type
BData structure
CDatabase instances
DDatabase schema

EData values

Which of the following codes must be granted to an Oracle 9x to perform a full database import
ACONNECT
BRESOURCE
CFULL_REPORT_PREVS
DFULL_REPORT_PRINS
EIMP_FULL_DATABASE

SQL commands do not include which of the following
ADelete, Insert
BSelect, Updata
CSelect, Revoke
DGrant, Revoke

ESelect, Revoke

Which of the following is best characterized by unauthorized modification of data before or during systems data entry
AData modeling
BSalami attack
CData corruption
DData diddling

ESkimming

Who is more concerned about the conceptual level at DBMS
AThe system programmer
BDatabase viewer
CThe end user
DClient
EDBA

Online banking transactions are being posted to the database when processing suddenly comes to a hat. The integrity of the transaction processing is best ensured by ………
Aaccuracy checks
Bdatabase integrity checks
Cinput controls
DValidation checks
EDatabase commits and rollbacks

Which of the following accesses the database and data dictionary in a database as they exist on a storage device
ADBMS engine

BData administration system
CApplication generation subsystem
DData definition subsystem
EData manipulation subsystem

Which script you must query in Oracle to display the code associated with RMAN stored scripts

A. RC_STORED_SCRIPT_LINE

B. RC_STORED_SCRIPT

C. RC_STORED_LINE_SCRIPT

D. RC_SCRIPTS

E. RC_SCRIPTS in RC_STORED_SCRIPT
ABoth A and C
BBoth A and B

Which of the following is a CASE SQL statement
AA way to establish a data definition in SQL.
BA way to establish an IF-THEN-ELSE in SQL.
CEstablish a loop in SQL or establish an IF-THEN-ELSE in SQL.

DA way to establish a loop in SQL.
EA way to establish a data definition in SQL or establish a loop in SQL.

Which method of database recovery involves frequent simultaneous copying of the database to maintain two or more to complete copies of the database
ARollback

To define what columns should be displayed in an SQL, SELECT statement ………..
Ause USING to name the source table(s)
Buse SELECT to name the source table(s) and list the columns to be shown after USING.
Cuse USING to name the source table(s) and list the columns to be shown after SELECT.
Duse FROM to name the source table(s) and list the columns to be shown after SELECT.

Euse USING to name the source table(s) and list the columns to be shown after WHERE.

SQL security issues include which of the following
AThe complexity of key structures
BThe number of records
CThe size of databases
DThe number of candidate key elements
EGranularity of administration

Categories

Android C programming C++ programming Cloud Computing Computer Computer System Architecure Data Base Data Structure Internet & Social Media Java programming Manual Testing MS Office MySQL Networking Operating System PHP Programming Software Engineering Software Testing