Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Which of the following describes a relational database?
1) It provides a relationship between integers
2) It consists of separate tables or related data
3) It retrieves data related to its queries
4) It provides a relationship between floats
by

1 Answer

Answer :

2) It consists of separate tables or related data
by

Related questions

Is it true or false that a relational database typically consists of related two dimensional tables?

Description : Is it true or false that a relational database typically consists of related two dimensional tables?

Last Answer : Need answer

How are relationship between tables expressed in a relational database?

Description : How are relationship between tables expressed in a relational database?

Last Answer : Tables are the basic building blocks of a relationaldatabase.

Which of the following is included in the database collection: a) Schemes, Tables, Queries b) Queries, Report, Views and other Objects c) Both of Above d) None of These

Description : Which of the following is included in the database collection: a) Schemes, Tables, Queries b) Queries, Report, Views and other Objects c) Both of Above d) None of These

Last Answer : c) Both of Above

Database is made up of all the following components except (a) tables (b) queries -Technology

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above

Description : A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above

Last Answer : both (a)and (b)

RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.

Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to represent M, N, R1 and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Description : Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to ... and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Last Answer : Answer: 4

In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Description : In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Last Answer : Answer :4

In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the above

Description : In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the above

Last Answer : B) Domains

Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to the column B in table R. One can determine that: (A) I, III and IV are the same query. (B) II, III and IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Last Answer : (D) I, III and III are the same query.

The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Description : The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Last Answer : C) Relations

A top-to-bottom relationship among the items in a database is established by a A) Hierarchical schema B) Network schema C) Relational Schema D) All of the above

Description : A top-to-bottom relationship among the items in a database is established by a A) Hierarchical schema B) Network schema C) Relational Schema D) All of the above

Last Answer : A) Hierarchical schema

Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Description : Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Last Answer : A) i, ii, and iv only

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

The database in which records are organised in a tree-like structure is (1) Network database (2) Hierarchical database (3) Relational database (4) Object-oriented database

Description : The database in which records are organised in a tree-like structure is (1) Network database (2) Hierarchical database (3) Relational database (4) Object-oriented database

Last Answer : Hierarchical database

Expansion of RDBMS is (1) Repairable Database Management System (2) Relational Database Management System (3) Relational Database Memory System (4) Recurring Database Memory System

Description : Expansion of RDBMS is (1) Repairable Database Management System (2) Relational Database Management System (3) Relational Database Memory System (4) Recurring Database Memory System 

Last Answer : Relational Database Management System

Which of the following is an edge-storage or content-delivery system that caches data in different physical locations? a) Amazon Relational Database Service b) Amazon SimpleDBc) Amazon Cloudfront d) Amazon Associates Web Services

Description : Which of the following is an edge-storage or content-delivery system that caches data in different physical locations? a) Amazon Relational Database Service b) Amazon SimpleDB c) Amazon Cloudfront d) Amazon Associates Web Services

Last Answer : Amazon Cloudfront

n(log n) is referred to A. A measure of the desired maximal complexity of data mining algorithms B. A database containing volatile data used for the daily operation of an organization C. Relational database management system D. None of these

Description : n(log n) is referred to A. A measure of the desired maximal complexity of data mining algorithms B. A database containing volatile data used for the daily operation of an organization C. Relational database management system D. None of these

Last Answer : A. A measure of the desired maximal complexity of data mining algorithms

Which of the following statements concerning Object-Oriented databases is FALSE? (A) Objects in an object-oriented database contain not only data but also methods for processing the data. (B) Object-oriented databases store computational instructions in the same place as the data. (C) Object-oriented databases are more adapt at handling structures (analytical) data than relational databases. (D) Object-oriented databases store more types of data than relational databases and access that data faster.

Description : Which of the following statements concerning Object-Oriented databases is FALSE? (A) Objects in an object-oriented database contain not only data but also methods for processing the data. (B ... Object-oriented databases store more types of data than relational databases and access that data faster.

Last Answer : (C) Object-oriented databases are more adapt at handling structures (analytical) data than relational databases.

In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ‘’ (the empty string) for string columns. (C) To leave columns in a tuple marked as “unknown” when the actual value is unknown. (D) To fill a column in a tuple when that column does not really “exist” for that particular tuple.

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) eliminating number of anomalies that could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.

Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced. 

Last Answer : reducing the number of joins required to satisfy a query.

In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Last Answer : (C) Tables

In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Description : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Last Answer : (A) Number of tuples

Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any attributes of their own. How many minimum number of tables are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Description : Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any ... are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Last Answer : (B) 3 

A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These

Description : A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These

Last Answer : d) Tables

Queries to a database A. are written in English B. can use aggregatefunctions like SUM and COUNT C. both (a)and (b) D. All of theabove E. None of the above

Description : Queries to a database A. are written in English B. can use aggregatefunctions like SUM and COUNT C. both (a)and (b) D. All of theabove E. None of the above

Last Answer : can use aggregatefunctions like SUM and COUNT

What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system performance is gained B. Shorter response time for queries is achieved C. Large sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Description : What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system ... sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Last Answer : A. Higher system performance is gained

Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Last Answer : (B) SELECT A, COUNT(*) FROM R;

What is Relational Database Management System ?

Description : What is Relational Database Management System ?

Last Answer : Database databases are organized in different rows, that is, files are considered only in records, but also in tables with list rows and columns. This type of database is called relational database management system.

Which of the following genres does Hadoop produce? a) Distributed file system b) JAX-RS c) Java Message Service d) Relational Database Management System

Description : Which of the following genres does Hadoop produce? a) Distributed file system b) JAX-RS c) Java Message Service d) Relational Database Management System

Last Answer : Distributed file system

Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Description : Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Last Answer : Amazon Relational Database Service

The Relational Model Database:

Description : The Relational Model Database:

Last Answer : The relational model is the most popular type of database and an extremely powerful tool, not only to store information, but to access it as well. Relational databases are organized as tables. The ... reorganizing the tables. A table can have many records and each record can have many fields.

Which of the following is not a logical database structure? A) Chain B) Network C) Tree D) Relational

Description : Which of the following is not a logical database structure? A) Chain B) Network C) Tree D) Relational

Last Answer : A) Chain

A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.

Description : A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.

Last Answer : C) a tuple

Which of the following is not a type of Database Management System? (A) Hierarchical (B) Network (C) Relational (D) Sequential

Description : Which of the following is not a type of Database Management System? (A) Hierarchical (B) Network (C) Relational (D) Sequential 

Last Answer : (D) Sequential

Distinguish between network database model and relational database model.

Description : Distinguish between network database model and relational database model. 

Last Answer : Network database model Relational database model Relationship between records is expressed in the form of pointers or links Relationship between records is represented by a relation that contains a key for ... logically in the form of rows and columns. Example:  Example: 

Is there a way to have Feedburner only show the most recent blog posts it retrieves from my blog as opposed to all of them?

Description : Is there a way to have Feedburner only show the most recent blog posts it retrieves from my blog as opposed to all of them?

Last Answer : answer:found my answer through the FeedBurner Help Center: http://www.google.com/support/feedburner/bin/answer.py?answer[equal]79626 basically I would take the Code: http://myblogname.blogspot.com ... the following format: Code: http://myblogname.blogspot.com/feeds/posts/default?max-results[equal]3

A combination of equipment and controls which handles, stores and retrieves materials withprecision,accuracy and speed under a defined degree of automation is known as ____ a.Automated storage and retrieval system (AS/RS) b.Flexible manufacturing system c.Automated guided vehicle d.None of the above

Description : A combination of equipment and controls which handles, stores and retrieves materials withprecision,accuracy and speed under a defined degree of automation is known as ____ a.Automated storage and retrieval system (AS/RS) b.Flexible manufacturing system c.Automated guided vehicle d.None of the above

Last Answer : a.Automated storage and retrieval system (AS/RS)

Encryption is required to (i) protect business information from eavesdropping when it is transmitted on internet (ii)efficiently use the bandwidth available in PSTN (iii) to protect information stored in companies’ databases from retrieval (iv) to preserve secrecy of information stored in databases if an unauthorized person retrieves it a. i and ii b. ii and iii c. iii and iv d. i and iv

Description : Encryption is required to (i) protect business information from eavesdropping when it is transmitted on internet (ii)efficiently use the bandwidth available in PSTN (iii) to protect information stored in companies' databases from ... a. i and ii b. ii and iii c. iii and iv d. i and iv

Last Answer : d. i and iv 

A structure brings together a group of A) items of the same data type B) related data items and variables C) integers with user defined names D) floating points with user defined names

Description : A structure brings together a group of A) items of the same data type B) related data items and variables C) integers with user defined names D) floating points with user defined names

Last Answer : B) related data items and variables

A kiosk a) is data organised and presented in a manner that has additional value beyond t he value of the data itself b) combines microscopic electronic components on a single integrated circuit that processes bits according to software instructions c) is a computer station that provides the public with specific and useful information and service d) describes a computer's type, processor, and operating system e) None of these

Description : A kiosk a) is data organised and presented in a manner that has additional value beyond t he value of the data itself b) combines microscopic electronic components on a single integrated circuit that ... and service d) describes a computer's type, processor, and operating system e) None of these

Last Answer : c) is a computer station that provides the public with specific and useful information and service

The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : D : Geomatric Maps

The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : D : Geomatric Maps

The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : D : Geomatric Maps

RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Description : RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Last Answer : a) Relational Data Base Management System

RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Description : RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Last Answer : a) Relational Data Base Management System

Suppose that data is an array of 1000 integers. Write a single function call that will sort the 100 elements data [222] through data [321].

Description : Suppose that data is an array of 1000 integers. Write a single function call that will sort the 100 elements data [222] through data [321].

Last Answer : quicksort ((data + 222), 100)

The main task carried out in the …………… is to remove repeating attributes to separate tables. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Fourth Normal Form

Description : The main task carried out in the …………… is to remove repeating attributes to separate tables. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Fourth Normal Form

Last Answer : D) Fourth Normal Form