<Q>Which of the below options is NOT a property of data in a Data Warehouse
<C>Subject-Oriented
<C>Integrated
<C>Time-Variant
<C+>Volatile
<Q>Data Warehouses are mined using various algorithms to discover interesting patters and generate reports that enable the top management of a company to take strategic decisions.
<C+>True
<C>False
<Q>Which of the data warehouse implementation approaches suggests that an Enterprise Data Warehouse be built first followed by smaller data marts that concentrate on a certain area
<C>Bottom-Up Approach
<C+>Top-Down Approach
<Q>Transactions arising out of day-to-day operations of a company are stored directly into a data warehouse
<C>True
<C+>False
<Q>Which of the following is FALSE with respect to On-Line Transaction Processing (OLTP) Systems
<C>OLTP Systems are used by operational staff for day-to-day operations
<C+>Data is never deleted from OLTP Systems
<C>Old data is archived and purged from the system
<C>Data is stored at the atomic level (which means complete details are stored and data is not summarized)
<Q>On-Line Analytical Processing (OLAP) Systems can have higher response times compared to On-Line Transaction Processing (OLTP) Systems because they are used primarily for generating reports that are used to take strategic decisions that do not directly impact day-to-day operations of the company.
<C+>True
<C>False
<Q>In which of the stages of ETL is data cleaned to eliminate duplicate records and then converted into a standardized format which the Data Warehouse will store?
<C>Extraction
<C+>Transformation
<C>Loading
<Q>Which Data Warehouse schema consists of a single Fact Table and multiple Dimension Tables?
<C>Snowflake Schema
<C+>Star Schema
<C>Fact Constellation Schema
<Q>A hierarchy can be created on
<C>Facts
<C+>Dimensions
<Q>Which of the following statements is true about granularity of data?
<C>The lesser the granularity, lesser is the detail captured leading to a decrease in the size of the data warehouse
<C+>The more the granularity, greater is the detail captured leading to an increase in the size of the data warehouse
<C>Granularity does not affect the size of the data warehouse
<Q> SOA is __________________ style
<C+>architectural
<C>development
<C>pattern
<C>implementation
<Q> The major roles in SOA are _________,______________, and _________________
<C>Publish,Find,Bind&Invoke
<C+>Service Consumer,Service provider and Service Registry
<C>Service Provider,Broker and Service Consumer
<C>Publish,Find and register
<Q> Service is an _________ of certain functions, made available for use through a published interface that allows it to be invoked by the service consumer
<C>Inheritance
<C+>Encapsulation
<C>group
<C>descripttion
<Q> Web Services provides
<C> a non-distributed computing approach for integrating extremely heterogeneous applications over the Internet
<C> a heterogeneous computing approach for integrating extremely homogeneous applications over the Internet
<C+>a distributed computing approach for integrating extremely heterogeneous applications over the Internet
<C>a grid computing approach for integrating extremely heterogeneous applications over the Internet
<Q>The Web service specifications are completely independent of programming language, operating system, and hardware to promote loose coupling between the service consumer and provider
<C+>True
<C>False
<C>NA
<Q> The major operations in SOA are
<C>Publish
<C>Find
<C>Bind&Invoke
<C+>All of the above
<Q> Web Services provide ____________ between Service provider and Service Consumer
<C>Tight Coupling
<C>De-Coupling
<C+>Loose Coupling
<C>relationship
<Q>_____________ specifies the way a service consumer will interact with the service provider
<C+>Service descripttion
<C>Service registry
<C>Web services
<C>Compliance
<Q>Which of the following statements represent the overlap between SOA and WebServices
<C>SOA is the concept, web services represent the implementation
<C>Not every web service is based on SOA principles
<C>None of the above
<C+>All of the above
<Q> The architectural stack of SOA is composed of :
<C>Functional aspects and Technical aspects
<C+>Functional aspects and Quality-of-Service(QoS) aspects
<C> Technical Aspects and Quality-Of-Service(QoS) aspects
<C>None of the above
<Q>Service implementation is dependent of platform, language and location
<C>True
<C+>False
<C>NA
<Q>The following are the principles of SOA
<C>Modularity
<C>Reusability
<C>Composability
<C+>All of the above
<Q> Transport,Service registry and Service descripttion belong to the QUality of Service(QoS) aspects of SOA
<C>True
<C+>False
<Q> The Functional Aspects of SOA consists of
<C>Business Process
<C>Service
<C>Service Communication protocol
<C+>All of the above
<Q>__________,_______________ ,________________ and Management are the QoS aspects of SOA
<C>Transport,Service registry,Service descripttion
<C>Service,Business Process,Service Commmunication protocol
<C+>policy,security,Transaction
<C>None of the above
<Q>WSDL, UDDI, and SOAP are the fundamental pieces of Web Services infrastructure
<C+>True
<C>False
<Q>WSDL stands for
<C>Web Service Descripttion Language
<C>Web Services Defination Language
<C+>Web Services Descripttion Language
<C>None of the above
<Q>______________ acts as a shared messaging layer for connecting applications and other services throughout an enterprise computing infrastructure
<C>SOA
<C>Web Services
<C+>Enterprise Service Bus(ES<C>
<C>None Of the above
<Q> All of the statements are correct expect one about the role of Enterprise Service Bus in SOA
<C>ESB simplifies service deployment and management and promotes service reuse in a heterogeneous environment
<C>ESB is a standards-based communication layer in a service-oriented architecture (SO<C> that enables services to be used across multiple communication protocols
<C+>ESB doesnot support both open standards and proprietary technologies
<C>ESB supports queuing, holding messages if applications are temporarily unavailable
<Q>_____________ is the standard used for service registry.
<C+>Universal Descripttion, Definition, and Integration(UDDI)
<C>SOAP
<C>WSDL
<C>None of the above
<Q>___________ is used as the message protocol for expressing requests and responses from a Web Service
<C>WSDL
<C>UDDI
<C+>SOAP
<C>None of the above
<Q> The following describe the aspects of a Service Life Cycle
<C>Service Consumer,Service provider,ESB and Service Registry
<C+>Descripttion,Implementation,Publishing,Discovery,Binding,Invocation and Execution
<C>All of the above
<C>None of the above
<Q>The states available in a State Transition Diagram of a Service Life Cycle are
<C> ON and OFF
<C>Active and Passive
<C+>UP and DOWN
<C>None of the above
<Q> Start-of-Life and End-of-Life are ___________ in a State transition Diagram
<C>States
<C+>Transitions
<C>Action
<C>None of the above
<Q>The advantages of implementing an SOA using web services are
<C+>Simple, Pervasive and Platform-neutral
<C>Complex,Pervasive and Platform-neutral
<C>Simple,Pervasive and Platform dependant
<C>None of the above
<Q>The technologies that we consider while pursuing bottom-up style, in relation to the Web Service Architecture, are
<C>HTML,SOAP,WSDL
<C>UDDI,SOAP,WSDL
<C+>XML, SOAP, WSDL
<C>None of the above
<Q>Web Services may be a poor fit for Long running and/or complex transactions and for handling large size of data
<C+>True
<C>False
<Q>Web service management is a set of management capabilities that enable ______________,____________,and ___________ of, service qualities and service usage
<C>managing,securing and reporting
<C+>monitoring,controlling and reporting
<C>transacting,controlling and monitoring
<C>none of the above
<Q> Which one of the following is not a core property of SOA
<C>Business Agility
<C>Loosely Coupled
<C>Architectural Style
<C+>None of the above
<Q> Which one of the following is not a benefit of using SOA
<C>Reduce cost and increase reuse
<C+>Less responsive and slower time-to-market
<C>Easier to integrate and manage complexity
<C>None of the above
<Q> When making an online booking, if you are looking for air-tickets and you are also prompted for hotel reservations, it is using Web Services. State true or false
<C>False
<C+>True
<Q> The application, software module, or another service that requires a service is called:
<C>Service Customer
<C+>Service Consumer
<C>Service Provider
<Q> Which of the following is not a role played by an SOA entity
<C> Service Provider
<C> Service Registry
<C+>Service Developer
<Q> An example of online payment processing service is
<C+> Paypal
<C> Amazon
<C> Ebay
<Q> Which of the following is not a benefit of SOA
<C> Cost Cutting
<C> Reduction of problems from interoperability
<C> Increase Reusability of applications
<C+> Minimize use of existing technology
<Q> In evolution of system architecture, we moved from Distributed Objects to _____________ .
<C> Services
<C> N-tier
<C+> Components
<C> Independent
<Q> Service Interactions take place via _______________________
<C+> Messaging Exchange
<C> data transfer
<C> all of the above
<C> none of the above
<Q> Which of the following is not a SOA principle
<C> Reusability
<C> Modularity
<C+>Loosely Coupled
<C> Complaince to standards
<Q> Publish and Discovery are associated with ________________
<C> Web Services
<C> SOA
<C+> both
<C> none
<Q> We should use Web services for long running and complex transactions. True or False
<C> True
<C+>False
<Q> ____________ is used to move request from Service Providers to Service Consumers
<C> Service Registry
<C+> Transport
<C> Policy
<Q> Policy has aspects related to both QoS and Functional. Hence it has an overlap in the SOA Architecture
<C+>True
<C> False
<Q> Which of the following are the base technologies for Web Services:
<C>XML
<C>DTD
<C>Schema
<C+>All of the above
<Q> __________ provides a standard, extensible, composable framework for packaging and exchanging XML messages.
<C> SOA
<C+>SOAP
<C>WSDL
<Q> Web service definitions can be mapped to any implementation language, platform, object model, or messaging system
<C+> True
<C> False
<Q> Policies can be broken down into:
<C> Permission Policies
<C> Obligatory Policies
<C+>both A and B
<C>None of the above
<Q> ESB supports
<C> UDDI, JMS
<C> XML
<C+> both A and B
<C> None of the above
<Q> To access a service, in a Service Life Cycle Process, a client has to __________
<C>Bind to the service
<C> Lookup the service
<C+> Both a and b
<Q> The information about how to connect and interact with a service is considered as___________
<C>Service Information
<C+> Binding Information
<C> Service Binding
<Q> In Service Life Cycle "STOPPED" is a
<C> From State
<C> To State
<C+> End State
<Q> Recovery Action takes a service from Crashed state to __________ state
<C> Stopped
<C+>Idle
<C> UP
<Q> SOA is ___________ and Web Services is ________________
<C>concept, service
<C>framework, concept
<C+>concept, implementation
<C>implementation, concept
<Q> ESB often uses ______ and _______ for data transformation services.
<C> XSLT, XSD
<C>XML, XSLT
<C>XML, XSD
<C+>XSLT,Xquery
<Q>________ is an example of SOA implemented without Web Services
<C>Amazon.com
<C+>CORBA
<C>EBAY
<Q> The three fundamental concepts related to security in the Web Services Architecture stack are:
<C>Resource, Policies, Roles
<C> Resource, Policy Guards, Roles
<C+> Resource, Policies, Policy Guards
<Q> When applications need tight-coupling, Web Services is a very good option.
<C> True
<C+> False
<Q> XML stands for ___________________
<C>eXtensible Modeling Language
<C>Xtensive MarkUp Language
<C+>eXtensible Markup Language
<Q> ESB supports holding of messages if applications are temporarily unavailable. This is called
<C>Message Holding
<C>Message Handling
<C+>Queueing
<C>ESD doesnt support holding of messages.
<Q> WSDL uses ______ Grammar for describing web services.
<C> XSD
<C> English
<C+> XML
<Q> If the service is no longer accepting requests because of administrative action, then what is the state transition?
<C> UP -> IDLE -> STOPPED
<C> UP -> CRASHED -> IDLE
<C+> UP -> CRAHSED/SATURATED -> STOPPED
<Q> What is a DataWarehouse?
<C> a product
<C+> a solution
<C> both product and solution
<C> none of the above
<Q> What is not true about Datawarehouse?
<C> Stores historical data of business transactions
<C> Collection of non-volatile data
<C> Stored data is cleaned and standardized
<C+> Typically much smaller in size as compared to transactional system databases of the business
<Q> Select the appropriate answer which is true about Transactional database.
<C+> Stores transaction data that is current or very recent
<C> Typically Denormalized
<C> Little or no change in existing data
<C> All of the above
<Q> Which is not the example of OLTP?
<C> Legacy System
<C+> Data Warehouse
<C> ERP
<C> None of the above.
<Q> What is true about the Grain?
<C+> the lower the grain, the higher the size of warehouse.
<C> the higher the grain, the smaller the size of warehouse.
<C> grain has no impact on size of warehouse.
<C> the smaller the size of warehouse, the lower a grain.
<Q> which of the follwoing is not an example OLAP product?
<C> Cognos
<C> Oracle Express
<C+> Netezza
<C> Microsoft Analytical Services
<Q> Which of the following is false?
<C> Data in OLTP is static.
<C> In OLTP, data is aggregated and stored at higher level.
<C> OLTP is updated at fixed intervals of time.
<C+> All of the above
<Q> Which of the following is not true about OLAP?
<C> Its business users are senior management or executives to make decisions
<C> Database is denormalized
<C> It can insert, update and delete data
<C+> All of the above.
<Q> Which of the follwoing is not a type of multi - dimensional model?
<C> ROLAP
<C+> GOLAP
<C> MOLAP
<C> HOLAP
<Q> IBM datastage is a type of
<C> OLAP Products
<C> Packaged Products
<C> Databases
<C+> ETL Products
<Q> Slice & Dice of data is possible in
<C+> OLAP systems
<C> OLTP Systems
<C> Both OLAP & OLTP
<C> None of the above
<Q> What are some of common database schemas in datawarehouse?
<C+> Star Schema and Snowflake schema
<C> Star Schema and Mega Star Schema
<C> Start schema, Push Schema
<C> Push Schema, Pull Schema
<Q> Which of the following schema is slightly more normalized?
<C> Star Schema
<C> Push Schema
<C> Pull Schema
<C+> Snowflake Schema
<Q> In Datawarehousing Schema, if One Dimension table is joined with another dimension table then that schema usually is called
<C> Star Schema
<C> Push Schema
<C> Pull Schema
<C+> Snowflake Schema
<Q> The lower the grain
<C> The smaller the size of the datawarehouse database
<C+> The larger the size of the datawarehouse database
<C> Not related to size of datawarehouse
<C> Can't say
<Q> What are the key terms in defining a datawarehouse?
<C+> Subject Oriented,integrated,non volatile, time variant
<C> Subject Oriented,integrated,non volatile, non time variant
<C> Subject Oriented,non integrated,non volatile, non time variant
<C> Subject Oriented,integrated,volatile, time variant
<Q> what is etl?
<C+> Extraction, Transformation and Loading
<C> Extraction, Traction and Loading
<C> Extraction, Transformation and Leading
<C> Endurance Test of Loading
<Q>what does the acronym olap Stand for?
<C> Online Associated Processing
<C> Online Loading and Analytical Processing
<C+> Online Analytical Processing
<C> Object Linkage and Analytics processing
<Q>what does the acronym oltp Stand for?
<C+> Online Transaction Processing
<C> Online and Time Lenient Processing
<C> Object Linkage and Non Time based Processing
<C> Object linkage and Time based Processing
<Q>Which System will help us do a trend analysis, for example bookings in a railway route during dewali season as compared to bookings during Dusserha
<C> Online Transaction Processing System
<C+> Datawarehouse
<C> ETL
<C> Dimension
<Q>Which of the below is more normalized than rest.
<C> Second Normal Form Database
<C+> Third Normal form Database
<C> First Normal Form Database
<C> Snowflake Schema
<Q> How Frequently is an OLAP System typically Updated
<C> Continuously updated
<C> Not Continously updated but continuosly deleted
<C+> Updated at a fixed interval of time
<C> Updated on an Adhoc basis
<Q>Which System is more designed for Senior Management and executives
<C> Online Transaction Processing System
<C+> Datawarehouse
<C> ETL
<C> Dimension
<Q>Old data is typically Purged in which system
<C+> Online Transaction Processing System
<C> Datawarehouse
<C> Online Analyticak Processing System
<C> Dimension
<Q> ETL jobs typically move data from
<C+>different source systems to warehouse at a predefined interval.
<C>Warehouse to different source systems at a predefined interval.
<C>different source systems to Loading places at a predefined interval.
<C>Warehouse to internet and external applications at a predefined interval.
<Q> Which of the following is not a typical activity during ETL
<C>Data aggregation
<C>Data Quality Checks
<C>Business Rules Validation
<C+>Data visualization
<Q> Which of the following is not used for Multi dimensional analysis
<C>ROLAP
<C>MOLAP
<C>HOLAP
<C+>AOLAP
<Q> The Acronym ROLAP stands for
<C+>Relational Online Analytical Processing
<C>Rational Online Analytical Processing
<C>Rose Analytical Processing
<C>Ranking Analytical Processing
<Q> The Acronym HOLAP stands for
<C+>Hybrid Online Analytical Processing
<C>Hearing Online Analytical Processing
<C> Homogenous data Online Analytical Processing
<C>Heterogenous online Analytical Processing
<Q> The Acronym MOLAP stands for
<C>Minute Online Analytical Processing
<C+>Multidimensional Online Analytical Processing
<C> Master data Online Analytical Processing
<C>Metro online Analytical Processing
<Q> A Fact is like a
<C+>A set of measurements made in the marketplace. These measurements are usually numeric
<C>Dimension with no keys
<C> Dimension Withkeys
<C> Table that is in Second normal form
<Q> Which of the following is not a commonly found dimension
<C>Geography
<C>Product
<C> Time
<C+>Sales
<Q> Which of the following is an example of fact table
<C>Geography
<C>Product
<C> Time
<C+>Sales
<Q> Which of the following is an example of Dimension table
<C+>Geography
<C> Bookings
<C> Student attendance
<C>Sales
<Q> Which of the following products is not a packaged BI product
<C>SAP BW
<C+> SAP R3
<C> Peoplesoft EPM
<C>Siebel Analytics
<Q> Data Warehouse is
<C> Subject Oriented and Integrated
<C> Time Variant and non volatile
<C+> Both of the above
<C> None of the above
<Q> Difference between OLAP and OLTP lies in
<C+> Data in OLTP is dynamic while that in OLAP is static
<C> OLTP is de-normalized database while OLAP is normalized database
<C> both a and b are true
<C> Both a and b are false
<Q> which one is a future trend for DW?
<C+>Taking data quality seriously
<C>Managing data efficiently
<C>Storing Data properly.
<C>Transaction processing efficiently.
<Q>Determine true or false.Aligning Datawarehouse to SOA Architecture is a future trend for DW.
<C+>True
<C>False
<Q> More and complex joins as the tables are normalized. As Atomicity is more, the emphasis is on efficiently storing a lot of data. This a property of:
<C>OLAP
<C>ROLAP
<C>HOLAP
<C+>OLTP
<Q>Data is aggregated or summarized and stored at the higher level.This is a property of:
<C+>OLAP
<C>ROLAP
<C>HOLAP
<C>OLTP
<Q>DSS stands for:
<C>Data Supply System
<C>Data Support System
<C>Domian Support System
<C+>Decision Support Syst
<Q>Which one is odd one out related to DW:
<C>Subject-Oriented
<C>Integrated
<C>Time-Variant
<C+>Volatile
<Q>What is the given property of DW known as:Data is stable in a data warehouse. More data is added but data is never removed. This enables management
to gain a consistent picture of the business.
<C>Subject-Oriented
<C>Integrated
<C>Time-Variant
<C+>Non-Volatile
<Q>Which one is a read-write property of DW:
<C>Data can be inserted.
<C>Data can be updated.
<C+>Read Only data.
<C>Data can be deleted
<Q>Which is true for Star Schema?
<C>Consisting of a single "fact table" with a compound primary key.
<C>One segment for each "dimension" and with additional columns of additive.
<C>Numeric facts (like dollar amounts).
<C+>All of the above.
<Q>What is true about OLTP?
<C>Old data is purged or archived.
<C>Dynamic.
<C>Normalized databases.
<C+>All of the above.
<Q>In Indian railways, a system that will help you make a reservation for a berth is
<C+> An example of OLTP system
<C> An example of OLAP system
<C> An example of OLSP System
<C> An example of OATP System
<Q>In Indian railways, a system that will help you see which routes are more profitable or more crowded is
<C> An example of OLTP system
<C+> An example of OLAP system
<C> An example of OLSP System
<C> An example of OATP System
<Q>An ERP System is
<C+> An example of OLTP system
<C> An example of OLAP system
<C> An example of OLSP System
<C> An example of OATP System
<Q>Dataquality is very important in a
<C+> Decision Support Initiative
<C> ERP implementation
<C> Internet application development
<C> SOA architecture
<Q>Which of the following is an example of proliferation of data sources
<C+> Click Stream data being integrated with mainstream data
<C> Master data being created
<C> ERP implementation
<C> SOA
<Q>Data integration is typically done during
<C> Master Data management
<C+> ETL
<C> SOA related development
<C> None of the above
<Q> The amount of time a user can wait after firing a query is typically more in
<C+> A datawarehouse
<C> A OLTP system
<C> A Internet system
<C> None of the above
<Q> As a customer of an organization like Indian railways, you will most likely interface with which of the following systems of that organization
<C+> OLTP system
<C> OLAP system
<C> Both systems
<C> None of the above
<Q> During cricket commentary, the bargraphs and piecharts of batsman's runs scored could be an example of
<C> OLTP system
<C+> OLAP system
<C> Both systems
<C> None of the above
<Q> During cricket each ball is logged in the log book, the log book could be looked as
<C+> OLTP system
<C> OLAP system
<C> Both systems
<C> None of the above
<Q> As a customer/consumer of a news channel showing cricket commentary, you will most most likely interface with an
<C> Realtime OLTP system
<C+> Realtime OLAP system
<C> Both systems
<C> None of the above
<Q> Which of the following are not real trends in datawarehousing
<C+> lightweight laptops so that business users can carry them everywhere
<C> thin client architectures so that business users can log in from anywhere
<C> Both a & b
<C> None of the above
<Q> Which of the following are not real trends in datawarehousing
<C+> Corporate email is more accesible from anywhere
<C> Using Datawarehouse as a service
<C> Both a&b
<C> None of the above
<Q> Which of the following cursor attribute returns a numeric value?
<C> %isopen
<C+>%rowcount
<C> %notfound
<C> %found
<Q> When is the select statement of a cursor executed
<C> When the cursor is declared
<C+>When the open cursor statement is encounter
<C> When record is fetched from the cursor
<C> All
<Q> You are processing an update statement. At what point in SQL statement processing is the data change actually made to block buffers?
<C> When the cursor is opened
<C> When the statement is parsed
<C> When data is fetched from the cursor
<C+>When the statement is executed
<Q> Analyze the PL/SQL code given below, and determine the output.
declare
a number:=10;
begin
declare
a number :=100;
begin
dbms_output.put_line('Inner block :'|| a);
end;
dbms_output.put_line('Outer block :'|| a);
end;
<C+>Inner block :100
Outer block :10
<C> Inner block :10
Outer block :10
<C> Inner block :Null
Outer block :10
<C> Error would be displayed.
<Q> What is the output of PL/SQL block given below
If employee number 2002 does not exist in the
emp_info table
DECLARE
V_RESULT NUMBER;
BEGIN
UPDATE EMP_INFO
SET SAL = SAL + 100
WHERE EMPNO = 2002;
V_RESULT := SQL%ROWCOUNT;
DBMS_OUTPUT.PUT_LINE(V_RESULT);
END;
<C+>0
<C> 1
<C> 3
<C> 4
<Q> In PL/SQL the table based records are defined using
<C> %TYPE
<C+>%ROWTYPE
<C> %RECORDTYPE
<C> %ROW
<Q> Which procedure can be used to create a customized error message?
<C> RAISE_ERROR
<C> SQLERRM
<C+>RAISE_APPLICATION_ERROR
<C> RAISE_SERVER_ERROR
<Q> In the PL/SQL block given below, how many times will the loop be executed ?
BEGIN
FOR i in 1..50
LOOP
i:=i+1;
DBMS_OUTPUT.PUT_LINE(' Value of i is ' || i);
END LOOP;
END;
<C> Once
<C> 10
<C> 25
<C+> Gives an error because (i) loop counter is used as an assignment target
<Q> While creating a stored procedure named EMP_PROC(p1,p2), what should be the mode of the parameters if the procedure is made to return values to the called environment?
<C+>Both IN OUT and OUT can be used
<C> You cannot pass values to the called enviro
<C> IN OUT
<C> OUT
<Q> Given the procedure tester as given below
create or replace procedure tester(a number DEFAULT 10 ,b number DEFAULT 20)
is
begin
dbms_output.put_line('the values of a and b i have got in procedure is');
dbms_output.put_line(to_char(a) ||' '||to_char(b));
end;
what values will be printed as the result of the call
tester(500);
<C> 10 20
<C+>500 20
<C> 500 10
<C> this code produces compilation error
<Q>Which of the following is not a step for data processing?
<C>Data Collection
<C>Sorting
<C>Retrieving
<C>Communicating
<C+>None of the above
<Q>In which type of data processing modes, transactions are processed as and when they appear?
<C>Batch Processing
<C+>Online Processing
<C>Real-Time Processing
<Q>In which type of data processing modes, transactions are collected in a group & processed together?
<C+>Batch Processing
<C>Online Processing
<C>Real-Time Processing
<Q>Which of the following data processing modes is useful in controlling the current / dynamic activity?
<C>Batch Processing
<C>Online Processing
<C+>Real-Time Processing
<Q>Which of the following statements is false regarding traditional method of data storage?
<C>Information is stored in flat files
<C>Application programs go through the file system to access the flat files.
<C>Less security
<C+>Less Redundancy
<Q>Which of the follwoing is not a disadvantage of the traditional method of data storage?
<C>Writing new application programs to retrieve the appropriate data is difficult.
<C>No centralized execution of data management functions.
<C+>Able to retrieve information for all requests for data.
<C>Interaction of concurrent updates may result in inconsistent data.
<Q>Which of the following is not a DataBase?
<C>Sysbase
<C>Informix
<C>MySQL
<C>DB2
<C+>None of the above.
<Q>Which of the following is true regarding Database Management System?
<C>It is a collection of interrelated files and set of programs which allows users to access and modify files.
<C>Primary Goal is to provide a convenient and efficient way to store, retrieve and modify information.
<C>Acts as a layer of abstraction between the application programs and the file system.
<C+>All the above.
<Q>In which type of databases, databases are seperately administered?
<C>Centralized
<C+>Distributed
<C>Both
<C>None
<Q>In which level of DBMS architecture, the end user’s interaction with the Database system is simplified?
<C+>External View/Level
<C>Conceptual View/Level
<C>Internal/Physical View/Level
<C>All the above
<Q>In which level of DBMS architecture, relationships among data is described?
<C>External View/Level
<C+>Conceptual View/Level
<C>Internal/Physical View/Level
<C>All the above.
<Q>In which level of DBMS architecture, the Data storage and Access methods of the DBMS system is described?
<C>External View/Level
<C>Conceptual View/Level
<C+>Internal/Physical View/Level
<C>All the above.
<Q>Data model is a conceptual tool used to describe:
<C>Data
<C>Data relationships
<C>Data semantics
<C>Consistency constraints
<C+>All the above.
<Q>Which of the datamodel does not come under record based logical model?
<C+>Entity relationship model
<C>Hierarchical data model
<C>Network data model
<C>Relational data model
<Q>Which of the following data model is object based logical model?
<C+>Entity relationship model
<C>Hierarchical data model
<C>Network data model
<C>Relational data model
<Q>IMS is an example of which data model?
<C>Entity relationship model
<C+>Hierarchical data model
<C>Network data model
<C>Relational data model
<Q>IDMS is an example of which data model?
<C>Entity relationship model
<C>Hierarchical data model
<C+>Network data model
<C>Relational data model
<Q>DB2 is an example of which data model?
<C>Entity relationship model
<C>Hierarchical data model
<C>Network data model
<C+>Relational data model
<Q>Which of the following is not a subset of ER Modelling?
<C>Entity Instance
<C>Attributes
<C>Relationship
<C+>Partnership
<Q> which of the following is an example of Key Attributes?
<C>Account number of an account.
<C>Employee id of an employee.
<C+>Both
<C>None
<Q>Which of the following statements are true regarding Attributes?
1. Simple attribute can be divided into simpler components.
2. Single valued can take on only a single value for each entity instance.
3. Stored Attribute need to be stored permanently.
4.Date of opening the Account of the Customer is an example of Composite Attribute.
<C>1,2,3
<C+>2,3,4
<C>1,3,4
<C>1,2,4
<Q>Which of the following statements are true regarding Keys?
1. A Candidate key is a set of one or more attributes that can uniquely identify a row in a given table.
2. Any superset of a candidate Key is a super key.
3. the Database Designer chooses one of the Candidate Key from amongst the several available, to uniquely identify row in the given table, known as Primary Key.
4. A primary key which is a combination of more than one attribute is called a composite primary key.
<C>1,2,3
<C>2,3,4
<C>1,3,4
<C+>1,2,3,4
<Q>Which of the follwing statements are true regarding Foreign Keys?
1. A foreign key is a “copy” of a primary key that has been exported from one relation into another to represent the existence of a relationship between them.
2. Foreign key values must be unique.
3. Foreign keys can be null.
4. A composite foreign key cannot have some attribute (s) null and others non-null.
<C>1,2,3
<C+>1,3,4
<C>2,3,4
<C>1,2,4
<Q>Order of steps in which ER modelling is generally followed?
1. Find relationships
2. Identify the key attributes for every Entity and other relevant attributes.
3. Identify the Entities.
4. Draw complete E-R diagram with all attributes including Primary Key.
<C>1,2,3,4
<C+>3,1,2,4
<C>2,3,1,4
<C>3,2,4,1
<Q>Find the false statement regarding ER modelling?
<C>ER Modelling can be generalized and specialized based on needs.
<C+>Physical design derived from E-R Model do not have any sort of ambiguities or inconsistency.
<C>Sometimes ERmodelling diagrams lead to misinterpretations.
<C>ER modelling gives a higher level descripttion of the system.
<Q>Which of the following is not a limitation of Normalization?
<C>Full normalization may not be always desirable.
<C>We have to use commonsense.
<C>Adverse effect in retrieval.
<C+>None of the above.
<Q>Which is wrong regarding SQL?
<C>SQL is used to make a request to retrieve data from a Database.
<C>The DBMS processes the SQL request, retrieves the requested data from the Database, and returns it.
<C>SQL is a language that all commercial RDBMS implementations understand.
<C+>SQL is a procedural language.
<Q>Which is not a basic datatype?
<C+>int
<C>Varchar2
<C>Long
<C>Date
<C>None of the above.
<Q>Which of the following is not a DML statement?
<C>Insert
<C+>Commit
<C>Update
<C>Delete
<Q>Which of the following is not a DCL statement?
<C+>Select
<C>Grant
<C>Revoke
<C>Rollback
<Q>"Truncate" is a __________ statement?
<C+>Data Definition Language
<C>Data Manipulation Language
<C>Data Control Language
<C>None of the above.
<Q>Identify the false statement regarding joins?
<C>Inner Joins combine records from two tables with matching values.
<C>Outer Joins retrieve all rows that match the WHERE clause and those that have a NULL.
<C>Left outer joins include all records from the first (left) of two tables.
<C>Right outer joins include all records from the second (right) of two tables.
<C+>None of the above.
<Q>A view is no longer needed. Which SQL statement should be used to remove the TRANS_HIST_V view?
<C>Drop trans_hist_v;
<C>Delete trans_hist_v;
<C+>Drop view trans_hist_v;
<C>Truncate view trans_hist_v;
<Q>How many Rows would a two-table join produce without a condition in the WHERE clause if one table has 50 Rows and the other has 10 Rows?
<C>5000
<C+>500
<C>100
<C>None of the choices
<Q>A NULL value is
<C+>Missing or unknown value.
<C> Is similar to zero
<C> is similar to blank space
<Q>Which clause is always given the last precedence while executing a SQL query.
<C>WHERE
<C+>ORDER BY
<C>HAVING
<C>No such Rule exists
<Q>Security of OLTP is enforced using
<C>Views only
<C>Access priviledges only
<C+>Views and Access priviledges
<C>Neither views nor Access priviledges
<Q>After the transaction is completed, the updated results are available on a permanent basis. This property is known as
<C>Consistency
<C>Integrity
<C>Isolation
<C+>Durability
<Q>In situations where we want to get matching as well as non-matching records for the two joining tables, the best option is to use
<C>Inner Join
<C+>Outer Join
<C>Self Join
<C>None of the choices are correct
<Q>Domain integrity in RDBMS can be achieved through
<C>Primary key concept
<C>Foreign key concept
<C>Both primary key and foreign key concept
<C+>Using check constraint
<Q>A transaction Ta with a time stamp of ta issues a write operation for the data item X. The request succeeds if
<C+>ta> =Wx and ta>=Rx
<C>ta< =Wx and ta< =Rx
<C>ta = Wx and ta =Rx
<Q>Transaction Log files cannot be used for recovery of data from :
<C+>Hard Disk Crash
<C>Application Error
<C>Operating System Failure
<C>Transaction Failure
<Q>The following are clauses of the SELECT statement:
1 - WHERE
2 - FROM
3 - ORDER BY
In which order should they appear in a query?
<C>1 3 2
<C+>2 1 3
<C>2 3 1
<C>The order of these clauses does not matter.
<Q>If the relation R (A, B, C), in which the primary key is the combination of A and B and is NOT in 2NF, then which of the following is true?
<C>B - C
<C>A - C
<C>A - B
<C+>Either B - C or A - C
<Q>An application has a VB based Graphical User Interface as the front end and RDBMS to store the data at the back end. While working, the following error message "Duplicate record - Record already exists" is encountered. This is due to
<C+>entity integrity
<C>referential integrity
<C>domain integrity
<C>relationship integrity
<Q>Given the relation Employee:
E# Ename D# Mgr_E#
101 Smith 1 103
102 Brown 1 103
103 Clark 1 103
104 Black 2 105
105 Green 2 105
What will be returned by the SQL query:
Select Distinct E2.Ename
From Employee E1, Employee E2
where E1.D# = 2
AND
E1.Mgr_E# = E2.E#;
<C>Clark
<C+>Green
<C>Clark and Green
<C>None of the above.
<Q>A view can enforce the condition with which it has been created during insert,update operations using
<C>ON DELETE CASCADE option
<C+>CHECK OPTION
<C>ON UPDATE RESTRICT
<C>Depends on database.
<Q>Which of the following is NOT a CONSTRAINT.
<C>Primary key
<C>Check
<C>NOT NULL
<C+>None of the options.
<Q>Which of the following is NOT a group function ?
<C>avg()
<C+>sqrt()
<C>max()
<C>min()
<Q>Foreign key whose values are required to match the values of a candidate key in the same table is called
<C+>Self-referencing key
<C>Primay Key
<C>Super Key
<C>None Of The Above
<Q>Duplicating (ie.making a copy) of the log file is done to recover from
<C>Application failure
<C>Power failure
<C>Operating Systems failure
<C+>Media failure
<Q>When a checkpoint is taken
<C>The updates of only the committed transactions are written to the database.
<C>The updates of only the uncommitted transactions are written to the database.
<C+>The entire data base buffer is flushed to the database.
<C>All uncommitted transactions are rolled back.
<Q>Any relation which is in 3NF is also in BCNF .
<C>True
<C+>False
<Q>The level of concurrency is highest with
<C>table level locking
<C+>record level locking
<C>database level locking
<C>tablespace level locking
<Q>Log buffer should be flushed to the log file before changes are made to the database
<C+>True
<C>False
<Q>Consider a relation having three attributes Student, Subject, Teacher.
The functional dependencies for this relation are
(Student,Subject)--> Teacher and
(Teacher)-->Subject.
Which normal form is this relation in?
<C>1 NF
<C>2 NF
<C+>3 NF
<C>Cannot determine
<Q>The property Atomicity of a transaction means:
<C>In database perspective every SQL in the transaction execution is indivisible
<C+>In user's perspective every transaction is indivisible
<C>In user's perspective every data value returned is indivisible
<C>In user's perspective every transcation should be as small as an atom.
<Q>. The good design is the first requirement of any web application. Which of the following could be the criteria for a good design for a web application?
<C>Easy to navigate
<C>Should Load Quickly
<C>Should be fast
<C+>All of the above.
<Q>When each row of a table is joined with each row of the other table, it is called
<C>inner join
<C+>Cartesian join
<C>self join
<C>none of the above
CAclubindia
