Go To Top Reset
<<= Back
Next =>>
You Are On Multi Choice Question Bank SET 1201
60051. When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
(A): Data source (B): Driver (C): Driver manager (D): OLE DB
60052. The ODBC Level 1 API contains which of the following functions?
(A): Browse possible connections and data sources only (B): Connect to data sources with driver-specific information only (C): Process a scrollable cursor only (D): Both 1 and 3 above are in the OBDC Level 1 API.
60053. In OLE DB, a service provider:
(A): does not own data only. (B): transforms data through OLE DB interfaces only. (C): is both a consumer and a provider of data only. (D): All of the above are true of an OLE DB service provider.
60054. In OLE DB, a tabular data provider:
(A): does not own data. (B): transforms data through ODE DB interfaces. (C): is both a consumer and a provider of data. (D): exposes data via rowsets.
60055. The ODBC Level 2 API contains which the following functions?
(A): Commit or rollback transactions only (B): Connect to data sources with driver-specific information only (C): Connect to data sources only (D): All of the above are contained in the OBDC Level 2 API
60056. In ODBC, a data source that is local to a single computer is called a:
(A): system data source. (B): file data source. (C): user data source. (D): SQL text file.
60057. ________ is a cover for utilizing OLE DB that is designed for use by almost any language.
(A): ODBC (B): ASP (C): JPCD (D): ADO
60058. A file data source is one that is local to a single computer.
(A): True (B): False
60059. An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
(A): True (B): False
60060. An OLE DB rowset is equivalent to a cursor.
(A): True (B): False
60061. ODBC is a foundation of data access in the specifically Microsoft world.
(A): True (B): False
60062. An abstraction is a generalization of something.
(A): True (B): False
60063. An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
(A): True (B): False
60064. A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
(A): True (B): False
60065. ODBC identifies two types of drivers: single tier and multiple-tier.
(A): True (B): False
60066. A data source is an ODBC data structure that identifies a database and the DBMS that processes it.
(A): True (B): False
60067. Users of OLE DB functionality are referred to as data providers.
(A): True (B): False
60068. A user data source is one that can be shared among database users.
(A): True (B): False
60069. ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
(A): True (B): False
60070. OLE DB tabular data providers present data in the form of rowsets.
(A): True (B): False
60071. The ADO connection object is created after the ADO errors object is created.
(A): True (B): False
60072. The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
(A): True (B): False
60073. ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
(A): True (B): False
60074. A OLE DB collection is an object that contains a group of other objects.
(A): True (B): False
60075. OLE DB has two types of data providers: tabular data providers and service providers.
(A): True (B): False
60076. The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
(A): True (B): False
60077. ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
(A): True (B): False
60078. ODBC minimum SQL grammar contains which of the following?
(A): INSERT, UPDATE, DELETE only (B): Stored Procedures only (C): Literals for date, time and timestamp only (D): CREATE VIEW, DROP VIEW only
60079. When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
(A): Data source (B): Driver (C): Driver manager (D): DBMS
60080. The ODBC core API consists of which of the following functions?
(A): Commit or rollback transactions only (B): Connect to data sources with driver-specific information only (C): Connect to data sources only (D): Both 1 and 3 above are in the OBDC core API.
60081. ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
(A): ASP (B): XML (C): ODBC (D): ADO
60082. ODBC core SQL grammar contains which of the following?:
(A): INSERT, UPDATE, DELETE only (B): Stored procedures only (C): Full SELECT (includes subqueries) only (D): Both 1 and 3 above are contained in the ODBC core SQL.
60083. Who appoints the chairman of UPSC?
(A): The Prime Minister of India (B): The President of India (C): The Chief Justice of India (D): The Speaker of Lok Sabha
60084. Who was the first recipient of Ezhutachan Puraskaram?
(A): Takazhi Sivasankara Pillai (B): O.N.V.Kurup (C): M.T.Vasudevan Nair (D): Sooranad Kunjan Pillai
60085. The last Asian games was held in:
(A): South Korea (B): China (C): North Korea (D): Japan
60086. Name the organization founded by Pandit Karuppan:
(A): Hindu Dharma Paripalana Sabha (B): Kalyana Dayani Sabha (C): Yogakshema Sabha (D): Dharma Paripalana Sabha
60087. The first woman President of Indian National Congress:
(A): Sarojini Naidu (B): Annie Besant (C): Vijayalakshmi Pandit (D): Kasturba Gandhi
60088. The blocking factor is:
(A): a group of fields stored in adjacent memory. (B): the number of physical records per page. (C): attributes grouped together by the same primary key. (D): attributes grouped together by the same secondary key.
60089. Which of the following improves a query's processing time?
(A): Write complex queries. (B): Combine a table with itself. (C): Query one query within another. (D): Use compatible data types.
60090. Which of the following are integrity controls that a DBMS may support?
(A): Assume a default value in a field unless a user enters a value for that field. (B): Limit the set of permissible values that a field may assume. (C): Limit the use of null values in some fields. (D): All of the above.
60091. Which of the following is not a factor to consider when switching from small to large block size?
(A): The length of all of the fields in a table row. (B): The number of columns (C): Block contention (D): Random row access speed
60092. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
(A): VARCHAR2 (B): CHAR (C): LONG (D): NUMBER
60093. A secondary key is which of the following?
(A): Nonunique key (B): Primary key (C): Useful for denormalization decisions (D): Determines the tablespace required
60094. The fastest read/write time and most efficient data storage of any disk array type is:
(A): RAID-0. (B): RAID-1. (C): RAID-2. (D): RAID-3.
60095. A rule of thumb for choosing indexes for a relational database includes which of the following?
(A): Indexes are more useful on smaller tables. (B): Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries. (C): Do not specify a unique index for the primary key of each table. (D): Be careful indexing attributes that have null values.
60096. Sequential retrieval on a primary key for sequential file storage has which of the following features?
(A): Very fast (B): Moderately fast (C): Slow (D): Impractical
60097. A multidimensional database model is used most often in which of the following models?
(A): Data warehouse (B): Relational (C): Hierarchical (D): Network
60098. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
(A): True (B): False
60099. Denormalization and clustering can work well to minimize data access time for small records.
(A): True (B): False
60100. Hashing algorithm converts a primary key value into a record address.
(A): True (B): False
<<= Back
Next =>>
Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use
Powered By:Omega Web Solutions © 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions