Description : What are the unary operations in Relational Algebra?
Last Answer : PROJECTION and SELECTION.
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 : 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.
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.
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.
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 : 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
Description : Amino acids excepting histidine are not good buffering agents in cell because (A) They exist as zwitter ions (B) Their pk and not in the physiological pH of a cell (C) Only Histidine has pk of its R group at 6.0 unlike the others which have at a different pH (D) None of these
Last Answer : Answer : C
Description : What is the basic data structure that is required for creating an LOV?
Last Answer : Record Group.
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 : Pick out the wrong statement. (A) The X-rays cannot be deflected by electric field unlike cathode rays (B) The intensity of X-rays can be measured by ionisation current produced due to the ... the anode-cathode voltage (D) Crystal structure of a material can be studied by an electron microscope
Last Answer : (C) The quality of X-rays can be controlled by varying the anode-cathode voltage
Description : The zeroth law of thermodynamics pertains to what relational condition that may exist between two systems?
Last Answer : Thermal equilibrium
Description : What are the stages in Relational based systems?
Last Answer : i. tokenization ii. Complex word handling iii. Basic groups iv. Complex phrases v. Merges structures
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 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 : 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
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.
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
Description : Name the sub-systems of a RDBMS
Last Answer : I/O, Security, Language Processing, Process Control, Storage Management, Logging and Recovery, Distribution Control, Transaction Control, Memory Management, Lock Management
Description : What are the primitive operations common to all record management systems?s?
Last Answer : Addition, deletion and modification.
Description : What is System R?
Last Answer : System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is possible to build a ... life environment to solve real life problems, with performance at least comparable to that of existing system.
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 : 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
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 : What is the basic structure of PL/SQL ?
Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.
Description : Where in the Oracle directory tree structure are audit traces placed?
Last Answer : In unix $ORACLE_HOME/rdbms/audit, in Windows the event viewer
Description : Give two examples of how you might determine the structure of the table DEPT.
Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.
Description : What is IAPXTB structure ?
Last Answer : The entries of Pro * C and user exits and the form which simulate the proc or user_exit are stored in IAPXTB table in d/b.
Description : Give the structure of the function ?
Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;
Description : Give the structure of the procedure ?
Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;
Description : What are the built -ins used for Modifying a groups structure?
Last Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)
Description : What are the components of logical database structure of Oracle database?
Last Answer : There are tablespaces and database's schema objects.
Description : What are the components of physical database structure of Oracle database?
Last Answer : Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.
Description : What is Enterprise Structure Configurator (ESC) and what are the benefits of using it?
Last Answer : The ESC is an interview-based tool that guides you through the configuration of your enterprise structures. Use the ESC as part of your set up to define the organization structures and job and position structures of the enterprise.
Description : Physical Structure of Database
Last Answer : Usually a database has the below files: a) Data Files (*.dbf) ------------------- b) Redo Logs (*.log) ------------------- c) Undo (*.dbf) ------------------------- d) Spfile or init file ---------- ... - g) Control Files (*.ctl) ------------------- h) Backup Files ----------------------------
Description : Explain Oracle memory structure
Last Answer : The Oracle RDBMS creates and uses storage on the computer hard disk and in random access memory (RAM). The portion in the computer s RAM is called memory structure. Oracle has two memory structures ... the user has retrieved from the database or data that the user wants to place into the database.
Description : How can you check the structure of a table from sqlplus?
Last Answer : DESCRIBE or DESC
Description : What r the types of windows (Window style)?
Last Answer : Specifies whether the window is a Document window or a Dialog window.
Description : What is E-R model?
Last Answer : This data model is based on real world that consists of basic objects called entities and of relationship among these objects. Entities are described in a database by a set of attributes.
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
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 : 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
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 : 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 : 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 : It is possible to use raw devices as data files and what is the advantages over file. system files ?
Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.
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