Database Management Objectives Set 2
15/08/2020- A top to bottom relationship among the items in a database is established by a ______
(A) Network Schema
(B) Relational Schema
(C) Hierarchical Schema
(D) None of the above
Answer
(C) Hierarchical Schema
- Aggregation is a special form of _______
(A) Specialization
(B) Association
(C) Generalization
(D) None of the above
Answer
(B) Association
- In E-R Diagram, _________ represents Key Attribute.
(A) Ellipse with underlying line
(B) Rectangle with underlying line
(C) Double rectangle
(D) None of the above
Answer
(A) Ellipse with underlying line
- Which TCL command is used to permanently save any transaction into database?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above
Answer
(C) commit
- Which TCL command restores the database to last committed state?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above
Answer
(A) rollback
- _______ is used to control privilege in Database.
(A) Data Manipulation Language
(B) Data Definition Language
(C) Data Query Language
(D) Data Control Language
Answer
(D) Data Control Language
- Which model remains operative until the software is required?
(A) Waterfall model
(B) Incremental model
(C) Prototyping model
(D) Spiral model
Answer
(D) Spiral model
- In oracle, which tablespace is the minimum required when creating a database?
(A) System tablespace
(B) Undo tablespace
(C) temporary tablespace
(D) None of the above
Answer
(A) System tablespace
- Which of the following is another name for weak entity?
(A) Dominant
(B) Child
(C) Owner
(D) None of the above
Answer
(B) Child
- ODBC is based on ________
(A) C++ language
(B) RDBMS
(C) Structured Query Language
(D) C language
Answer
(C) Structured Query Language
- OLAP stands for_____
(A) Online Arithmetic Processing
(B) Online Analysis Processing
(C) Online Analytical Processing
(D) None of the above
Answer
(C) Online Analytical Processing
- The _____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
(A) Join
(B) Intersection
(C) Union
(D) None of the above
Answer
(A) Join
- ________is the multiplication of all the values in the attributes.
(A) Set difference
(B) Cartesian product
(C) Intersection
(D) None of the above
Answer
(B) Cartesian product
- Which command is used to remove a relation from an SQL database?
(A) Delete
(B) Remove
(C) Drop
(D) None of the above
Answer
(C) Drop
- In SQL, the spaces at the end of the string are removed by _______ function.
(A) Lower
(B) String
(C) Trim
(D) None of the above
Answer
(C) Trim
- ________ is used to save permanently any transaction into database.
(A) commit
(B) rollback
(C) savepoint
(D) None of the above
Answer
(A) commit
- A unit of storage that can store one or more records in a hash file organization is denoted as_______
(A) Bucket
(B) Disk pages
(C) Blocks
(D) Nodes
Answer
(A) Bucket
- Which of the following operator used for appending two strings?
(A) %
(B) &
(C) +
(D) ||
Answer
(D) ||
- The management information system (MIS) structure with one main computer system is called a________
(A) Decentralized MIS structure
(B) Distributed MIS structure
(C) Centralized MIS structure
(D) None of the above
Answer
(C) Centralized MIS structure
- The highest level in the hierarchy of data organization is called________
(A) data base
(B) data file
(C) data record
(D) None of the above
Answer
(A) Data base
- ________ allows a unique number to be generated when a new record is inserted into a table.
(A) Insert into Select
(B) Insert Into
(C) Select Into
(D) Auto Increment
Answer
(D) Auto Increment
- Which of the following constraint is used to limit the value range that can be placed in a column?
(A) Check
(B) Default
(C) Unique
(D) None of the above
Answer
(A) Check
- A Foreign key in one table points to a ________ key in another table.
(A) Alternate
(B) Default
(C) Primary
(D) None of the above
Answer
(C) Primary
- Domain constraints, functional dependency and referential integrity are special forms of_________.
(A) Foreign key
(B) Primary key
(C) Referential constraint
(D) Assertion
Answer
(D) Assertion
- 4NF stands for ______
(A) Fourth Normal File
(B) Fourth Normal Form
(C) Fourth Normal Fraction
(D) Fourth Negative File
Answer
(B) Fourth Normal Form
- Which of the following field type is used to store photograph of employees?
(A) Memo
(B) Picture
(C) OLE
(D) Photo
Answer
(C) OLE
- _______ statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.
(A) Select
(B) Group By
(C) Distinct
(D) None of the above
Answer
(B) Group By
- Which of the following method can be used to add more tables in a database?
(A) Design View
(B) Table Wizard
(C) Both (A) & (B)
(D) None of the above
Answer
(C) Both (A) & (B)
- Which of the following field type is the best to store serial numbers?
(A) Number
(B) Auto Number
(C) Text
(D) Memo
Answer
(B) Auto Number
- The feature that database allows to access only certain records in database is______
(A) Queries
(B) Reports
(C) Forms
(D) Tables
Answer
(A) Queries
[…] VIEW […]