Practice MCQ Database Systems

Page 1 of 50, Total 706 results. | Shuffle Order | Flagged | Next Page
2284 Which of the following is not a level of data abstraction?
Options:Physical Level B. Critical Level       C. Logical Level D. View Level

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2285 Disadvantages of File systems to store data is:
Options:Data redundancy and inconsistency B. Difficulty in accessing data C. Data isolation D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2286 In an Entity-Relationship Diagram Rectangles represents
Options:Entity sets B. Attributes C. Database D. Tables

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2287 Which of the following is not a Storage Manager Component?
Options:Transaction Manager B. Logical Manager C. Buffer Manager D. File Manager

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2288 Data Manipulation Language enables users to
Options:Retrieval of information stored in database B. Insertion of new information into the database C. Deletion of information from the database D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2289 Which of the following is not an Schema?
Options:Database Schema B. Physical Schema C. Critical Schema D. Logical Schema

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2290 Which of the following is Database Language?
Options:Data Definition Language B. Data Manipulation Language C. Query Language D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2291 Which of the following in not a function of DBA?
Options:Network Maintenance B. Routine Maintenance C. Schema Definition D. Authorization for data access

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2292 . Which of the following is a Data Model?
Options:Entity-Relationship model B. Relational data model C. Object-Based data model D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2293 Which of the following represents a relationship among a set of values.
Options:A Row B. A Table C. A Field D. A Column

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2294 Column header is refer as
Options:Table B. Relation C. Attributes D. Domain

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2295 A Relation is a
Options:Subset of a Cartesian product of a list of attributes B. Subset of a Cartesian product of a list of domains C. Subset of a Cartesian product of a list of tuple D. Subset of a Cartesian product of a list of relations

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2296 In mathematical term Table is referred as
Options:Relation B. Attribute C. Tuple D. Domain

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2297 In mathematical term Row is referred as
Options:Relation B. Attribute C. Tuple D. Domain

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2298 _______ allow us to identify uniquely a tuple in the relation.
Options:Superkey B. Domain C. Attribute D. Schema

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2299 Minimal Superkeys are called
Options:Schema keys B. Candidate keys C. Domain keys D. Attribute keys

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2300 Which of the following is not Modification of the Database
Options:Deletion B. Insertion C. Sorting D. Updating

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2301 Which of the following is Relation-algebra Operation
Options:Select B. Union C. Rename D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2302 . Which of the following in not Outer join?
Options:Left outer join B. Right outer join C. Full outer join D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2303 Who proposed the relational model?
Options:Bill Gates B. E.F. Codd C. Herman Hollerith D. Charles Babbage

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2304 Set of premitted values of each attribute is called
Options:Domain B. Tuple C. Relation D. Schema

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2305 Which of the following in true regarding Null Value?
Options:Null = 0 B. Null < 0 C. Null > 0 D. Null <> 0

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2306 Logical design of database is called
Options:Database Instance B. Database Snapshot C. Database Schema D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2307 Snapshot of the data in the database at a given instant of time is called
Options:Database Schema B. Database Instance C. Database Snapshot D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2308 Which of the following is not Unary operation?
Options:Select B. Project C. Rename D. Union

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2309 Which of the following is not binary operation?
Options:Union B. Project C. Set Difference D. Cartesian Product

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2310 Which of the following is correct regarding Aggregate functions?
Options:it takes a list of values and return a single values as result B. it takes a list of values and return a list of values as result C. it takes a single value and returns a list of values as result D. it takes a single value and returns a single value as result

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2311 The Primary key must be
Options:Non Null B. Unique C. Option A or B D. Option A and B

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2312 . A command to remove a relation from an SQL database
Options:Delete table <table name> B. Drop table <table name> C. Erase table <table name> D. Alter table <table name>

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2313 which of the following is not an Aggregate function?
Options:Min B. Max C. Select D. Avg

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2314 The attribute that can be divided into other attributes is called
Options:Simple Attribute B. Composite Attribute       C. Multi-valued Attribute D. Derived Attribute

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2315 In an Entity-Relationship Diagram “Ellipses” represents
Options:Attributes B. Weak entity set C. Relationship sets D. Multi-valued attributes

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2316 In an Entity-Relationship Diagram “Diamonds” represents
Options:Attributes B. Multi-valued attributes C. Weak entity set D. Relationship sets

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2317 What is ACID properties of Transactions?
Options:Atomicity, Consistency, Isolation, Database B. Atomicity, Consistency, Isolation, Durability C. Atomicity, Consistency, Inconsistent, Durability D. Automatically, Concurrency, Isolation, Durability

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2318 If every non-key attribute is functionally dependent on the primary key, the relation will be in
Options:First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2319 Database locking concept is used to solve the problem of
Options:Lost Update B. Uncommitted Dependency C. Inconsistent Data D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2320 UML is stands for
Options:Universal Modeling Language B. Unified Modeling Language C. United Modeling Language D. Uni Modeling Language

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2321 Data Manipulation Language (DML) is not to
Options:Create information table in the Database B. Insertion of new information into the Database C. Deletion of information in the Database D. Modification of information in the Database

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2322 . Which of the following is true regarding Referential Integrity?
Options:Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2323 Which of the following option is use to retrieval of data? a. Stack b. Data Structure c. Linked list d. Query
Options:Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2324 ODBC stands for ______
Options:a. Offline database connection b. Oriented database connection c. Open database connection d. None of above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2325 Which algebra is widely used in DBMS?
Options:a. Relational algebra b. Arithmetic algebra c. Both d. None

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2326 Which of the following is an unary operation?
Options:a. Selection operation b. Generalized selection c. Primitive operation d. Projection operation

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2327 Which SQL Query is use to remove a table and all its data from the database? a. Create Table b. Alter Table c. Drop Table d. None of these
Options:Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2328 In precedence of set operators the expression is evaluated from
Options:a. Left to Left b. Left to Right c. Right to Right d. Right to Left

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2329 In DBMS FD stands for _______
Options: a. Facilitate data b. Functional data c. Facilitate dependency d. Functional dependency

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2330 How many types of keys in Database Design?
Options: a. Candidate key b. Primary key c. Foreign key d. All of these

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2331 Which of the following is based on Multi Valued Dependency?
Options:a. First b. Second c. Third d. Fourth

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2332 . Which of the following is the structure of the Database?
Options: a. Table b. Schema c. Relation d. None of these

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
2333 The minimal set of super key is called
Options:Primary key B. Secondary key C. Candidate key D. Foreign key

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
www.000webhost.com