a relational table must not contain a(n) ____. -General Knowledge

a relational table must not contain a(n) ____. -General Knowledge
by

1 Answer

Answer :

Relational table must not contain repeating groups.
by

Related questions

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 relational table two row are identical is true or false?

Description : In relational table two row are identical is true or false?

Last Answer : False.

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

The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Description : The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Last Answer : (C) Same number of rows as the original table

If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn

Description : If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn

Last Answer : (B) D1x D2x… xDn

Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are equivalent. (A) I and II are correct. (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Description : Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are ... (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Last Answer : (D) Only I is correct.

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.

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.

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

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

Which method can’t be used for expressing relational knowledge? a) Literal system b) Variable-based system c) Attribute-based system d) None of the mentioned

Description : Which method can’t be used for expressing relational knowledge? a) Literal system b) Variable-based system c) Attribute-based system d) None of the mentioned

Last Answer : c) Attribute-based system

Lead Storage batteries commonly contain ____. A. Copper B. Lead C. Iron D. Mercury

Description : Lead Storage batteries commonly contain ____. A. Copper B. Lead C. Iron D. Mercury

Last Answer : ANSWER: B

Storage batteries commonly contain ____. A. Copper B. Lead C. Iron D. Mercury

Description : Storage batteries commonly contain ____. A. Copper B. Lead C. Iron D. Mercury

Last Answer : ANSWER: B

Fats and oils contain ____ times more energy than proteins and carbohydrates. a. 2.25 c. 1.5 b. 2 d. 3

Description : Fats and oils contain ____ times more energy than proteins and carbohydrates. a. 2.25 c. 1.5 b. 2 d. 3

Last Answer : a. 2.25

Newer plastic materials for packaging contain cornstarch, which makes them more ____. a. sanitary c. expensive b. tough d. biodegradable

Description : Newer plastic materials for packaging contain cornstarch, which makes them more ____. a. sanitary c. expensive b. tough d. biodegradable

Last Answer : d. biodegradable

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.

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.

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.

How does relational-centred planning differ from traditional models of case planning please help im working as a cyc worker for child and youth care and need help?

Description : How does relational-centred planning differ from traditional models of case planning please help im working as a cyc worker for child and youth care and need help?

Last Answer : Need answer

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

Effective therapy is an ongoing process of building relational bridges that engender __________ and confidence.?

Description : Effective therapy is an ongoing process of building relational bridges that engender __________ and confidence.?

Last Answer : Cultural sensitivity

The zeroth law of thermodynamics pertains to what relational condition that may exist between two systems?

Description : The zeroth law of thermodynamics pertains to what relational condition that may exist between two systems?

Last Answer : Thermal equilibrium

What is special about the declaration of relational operators?

Description : What is special about the declaration of relational operators?

Last Answer : Relational operators must be declared in pairs. 

____________ are algorithms that learn from their more complex environments (hence eco) to generalize, approximate and simplify solution logic. a) Fuzzy Relational DB b) Ecorithms c) Fuzzy Set d) None of the mentioned

Description : ____________ are algorithms that learn from their more complex environments (hence eco) to generalize, approximate and simplify solution logic. a) Fuzzy Relational DB b) Ecorithms c) Fuzzy Set d) None of the mentioned

Last Answer : c) Fuzzy Set

Like relational databases there does exists fuzzy relational databases. a) True b) False

Description : Like relational databases there does exists fuzzy relational databases. a) True b) False

Last Answer : a) True

Which agent enables the deliberation about the computational entities and actions? a) Hybrid b) Reflective c) Relational d) None of the mentioned

Description : Which agent enables the deliberation about the computational entities and actions? a) Hybrid b) Reflective c) Relational d) None of the mentioned

Last Answer : b) Reflective

Specify the agent architecture name that is used to capture all kinds of actions. a) Complex b) Relational c) Hybrid d) None of the mentioned

Description : Specify the agent architecture name that is used to capture all kinds of actions. a) Complex b) Relational c) Hybrid d) None of the mentioned

Last Answer : c) Hybrid

Which kind of agent architecture should an agent an use? a) Relaxed b) Logic c) Relational d) All of the mentioned

Description : Which kind of agent architecture should an agent an use? a) Relaxed b) Logic c) Relational d) All of the mentioned

Last Answer : d) All of the mentioned

Topological Maps referred as A : Relational maps B : Geomatric Maps C : Perceptul maps D : Sensorial maps

Description : Topological Maps referred as A : Relational maps B : Geomatric Maps C : Perceptul maps D : Sensorial maps

Last Answer : A : Relational 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

A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : C : Perceptul 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

A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : C : Perceptul 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

<Condition>isa__ expression which will have value true or false. a. Relational b. Logical ce. Botha&b d. None of these

Description : isa__ expression which will have value true or false. a. Relational b. Logical ce. Botha&b d. None of these

Last Answer : ce. Botha&b

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)

. A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Description : . A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Last Answer : Client Server

What advantage comes from trust between alliance partners? a) Trust enables partners to enter into detailed formal contracts. b) Trust makes partners more willing to share information. c) Trust increases relational risks. d) Trust causes partners to cheat on each other

Description : What advantage comes from trust between alliance partners? a) Trust enables partners to enter into detailed formal contracts. b) Trust makes partners more willing to share information. c) Trust increases relational risks. d) Trust causes partners to cheat on each other

Last Answer : Trust makes partners more willing to share information.

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

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

Description : 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

Last Answer : 2) It consists of separate tables or related data

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

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

Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud c) Enables support for outbound sockets using the language – specific, built in libraries. d) Lets developers factor large applications into logical components that can be share stateful services and communicate in secure fashion.

Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.

Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud

What are the unary operations in Relational Algebra?

Description : What are the unary operations in Relational Algebra?

Last Answer : PROJECTION and SELECTION.

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Description : How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Last Answer : The tuple-oriented calculus uses a tuple variables i.e., variable whose only permitted values are tuples of that relation. E.g. QUEL The domain-oriented calculus has domain variables i.e., variables that range over the underlying domains instead of over relation. E.g. ILL, DEDUCE.

What is Relational Calculus?

Description : What is Relational Calculus?

Last Answer : It is an applied predicate calculus specifically tailored for relational databases proposed by E.F. Codd. E.g. of languages based on it are DSL ALPHA, QUEL.

What is Relational Algebra?

Description : What is Relational Algebra?

Last Answer : It is procedural query language. It consists of a set of operations that take one or two relations as input and produce a new relation.