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.
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
Description : Consider the following statements regarding relational database model: (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. (b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is ... true. (C) (b) and (c) are true. (D) (a), (b) and (c) are true.
Last Answer : (D) (a), (b) and (c) are true.
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
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)
Description : The PC productivity tool that manipulates data organized in rows and coloumn is called a a) spreadhsheet b) word processing document c) presentation mechanism d) database record manager e) None of these
Last Answer : a) spreadhsheet
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
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.
Description : Drawing of number of copies of the same image in rows and columns acrossthe interface window so that they cover the entire window is called a.Roaming b.Panning c.Zooming d.Tiling
Last Answer : d.Tiling
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
Description : What is the minimum number of rows and columns that a word table can have a) 1 row & 1 column b) 2 rows & 2 columns c) Zero d)1 row & 2 columns e) None of The Above
Last Answer : a) 1 row & 1 column
Description : The minimum number of rows and columns that a word table can have, is: a) Zero b) 1 Row and 1 Column c) 1 Row and 2 Columns d) None of The Above
Last Answer : b) 1 Row and 1 Column
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
Description : Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?
Last Answer : Statistical table is the systematic arrangement of numerical data presented in rows and columns. ... be followed while constructing such a table?
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.
Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology
Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.
Description : How are data organised in a spreadsheet? 1) Lines and spaces 2) Layers and planes 3) Height and width 4) Rows and columns 5) None of these
Last Answer : Answer :3
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
Description : Which of the following statement(s) is/are FALSE in the context of Relational DBMS ? I. Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data ... (B) III and IV only (C) I, II and III only (D) II, III and IV only
Last Answer : (D) II, III and IV only
Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology
Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information
Description : In a table, columns are called ………. and rows are called ………… . -Technology
Last Answer : In a table, columns are called fields and rows are called records.
Description : How many horizontal rows and vertical columns are present in the modern periodic table?
Last Answer : How many horizontal rows and vertical columns are present in the modern periodic table?
Description : What is the default alignment for a table with 3 rows and 4 columns?
Last Answer : What is the answer ?
Description : How many rows and columns are in the modern Periodic Table? A. 18 columns and 7 rows (Answer) B. 12 columns and 9 rows C. 7 columns and 18 rows D. 25 columns and 15 rows
Last Answer : A. 18 columns and 7 rows (Answer)
Description : Which of the following is not a logical database structure? A) Chain B) Network C) Tree D) Relational
Last Answer : A) Chain
Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology
Last Answer : The update command can be used to makes changes in the rows of a table in SQL.
Description : What is A grid comprised of horizontal rows an vertical columns into which you can enter data?
Last Answer : Generically it is called a table.
Description : A tuple is 1) - 1) Column of a Table 2) Two dimensional Table 3) Row of a Table 4) key of a Table
Last Answer : 3) Row of a Table
Description : The CRT display is made up of small picture element called: a) Columns b) Pixels c) Rows d) None of These
Last Answer : b) Pixels
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
Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.
Last Answer : (C) Tables
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
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
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.
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.
Description : What command is used to remove a table or index from a SQL database ?
Last Answer : DROP TABLE is used to remove a table or index from a SQL database .
Description : What is the use of sections in a word document: a) To divide the document into parts so that each part may be independently printed when the print command is given. b) To divide the document into ... document into parts and then allow formatting of each part the way you want. d) None of The Above
Last Answer : To vary the layout of a document within a page or between pages by dividing the document into parts and then allow formatting of each part the way you want.
Description : Which of the following is the largest unit? A) data B) field C) record D) database file
Last Answer : Answer : D
Description : Group of attributes/field in a database is known as a: a) Data Entry b) Record c) File d) None of These
Last Answer : b) Record
Description : The ascending order of a data hierarchy is: a) Bit - Bytes - Field - Record - File - Database b) Bit - Bytes - Record - Field - File - Database c) Bytes - Bit - Record - Field - File - Database d) None of The Above
Last Answer : a) Bit - Bytes - Field - Record - File - Database
Description : Which of the following places the common data elements in order from smallest to largest? a) Character, file, record, field, database b) Character, record, field, file, database c) Character, field, record, file, database d) Bit, byte, character, record, field, file, database
Last Answer : d) Bit, byte, character, record, field, file, database
Description : Which of the following places the common data elements in order from smallest to largest? 1) Character, file, record, field, database 2) Character, record, field, file, database 3) Character, field, record, file, database 4) Bit, byte, character, record, field, file, database
Last Answer : 3) Character, field, record, file, database
Description : Which of the following is in the ascending order of Data hierarchy? (1) Byte–Bit–File–Record–Database–Field (2) Field–Byte–Bit–Record–File– Database (3) Bit–Byte–Record–Field–Database–File (4) Bit–Byte–Field–Record–File– Database
Last Answer : Bit–Byte–Field–Record–File– Database
Description : How is the data structure of System R different from the relational structure? Unlike Relational systems in System R
Last Answer : ∙ Domains are not supported ∙ Enforcement of candidate key uniqueness is optional ∙ Enforcement of entity integrity is optional ∙ Referential integrity is not enforced
Description : How many color patterns can you create by reversing the colors of combinations of rows and columns from a checkerboard?
Last Answer : answer:OK @LostInParadise – I understand each word individually, but I don’t have a friggin clue what you are asking. Can you perhaps explain the question better for simpletons like me?
Description : Is there a free feature for removing duplicate columns/rows in Microsoft Excel?
Last Answer : answer:you can do this without adding software. http://support.microsoft.com/kb/262277 I think this should work with all versions of Excel. if you're using a mac, the menus might be a little different, but ... tricky if you need to get rid of duplicate data in a specific column, but it can be done.
Description : ...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology
Last Answer : Correct option(ii)reindex
Description : Python : Remove all columns from a compressed sparse matrix where value is 0 for all rows -Web-Development
Last Answer : answer:
Description : Which of the following is a combination of columns and rows ?
Last Answer : Database consists of columns and rows.
Description : What are the rows and columns of the matrix ?
Last Answer : The rectangular arrangement of numbers in the matrix is analyzed in two ways. Namely: along the horizontal line and along the vertical line. The horizontal lines of numbers are called rows and the vertical lines are called columns.