Users Also Read
Read MCQ's/Objective questions
MCQ's Search Engine
Important Question
ASP.NET
Basic Computer Knowledge
Basic of Linux/Unix
C Language
C# Programming
C++ Programming
Computer Graphics
Computer Hardware
Computer Networking
Computer Security - Cyber crime & Laws
Data Structures & Algorithms
Digital Computer Electronics
HTML
Important File Extensions
Imp. Shortcut Keys used in Computer
Internet, Web & Email
Java - Concepts and Its Programming
Language Processors
Management Information System (MIS)
MS Access
MS Excel
MS Word
Operating System
Oracle, SQL & PL/SQL
PHP Basic
Power Point
Programming Languages
Software Engineering
System Analysis and Design (SAD)
System software & compiler design
Tally
VB.NET
Visual Basic
Home⇒ Computer Engineering⇒ Database management system
1-Dont try to cram or spend more time here just read it fast and cover syllabus then practice MCQ's cheptor of same topic to check your progress. . |
2-Wrong options are also given but dont concentrate there, Right answer is in bold format. |
Q21 ⇒ An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without s Index [other wrong options] [Discuss in forum] Assertion Reference Timestamp |
Q22 ⇒ The “PROJECT” operator of a relational algebra creates a new table that has always Same number of rows as the original table [other wrong options] [Discuss in forum] More rows than original table Same number of columns as the original table More columns than columns in original table |
Q23 ⇒ The database environment has all of the following components except : Separate files [other wrong options] [Discuss in forum] Database Users DBA |
Q24 ⇒ What are the ways of dealing with deadlock ? All of the above [other wrong options] [Discuss in forum] Deadlock recovery Deadlock prevention Deadlock detection |
Q25 ⇒ The normalization of 1NF relations to 2NF involves: Removal of partial dependencies [other wrong options] [Discuss in forum] Removal of transitive dependencies Removal of multi-valued dependencies Removal of full dependencies |
Q26 ⇒ A schema describes all of the above [other wrong options] [Discuss in forum] data elements record & files record relationships |
Q27 ⇒ Literals in java must be preceded by which of these? Both (a) and (b) [other wrong options] [Discuss in forum] L I D |
Q28 ⇒ Which of the following is record based logical model(s)? Both (a) and (b) [other wrong options] [Discuss in forum] Relational Model Network Model Entity Relationship Model and Object-oriented model |
Q29 ⇒ A Boolean data type that can take values true, false, and________ . Unknown [other wrong options] [Discuss in forum] 0 1 Null |
Q30 ⇒ A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation . Primary [other wrong options] [Discuss in forum] Candidate Sub Super |
Q31 ⇒ The way a particular application views the data from the database that the application uses is a Sub Schema [other wrong options] [Discuss in forum] Schema Relational Model Module |
Q32 ⇒ Which of the following closely resembles Create view ? Create table . . . as [other wrong options] [Discuss in forum] Create view as Create table . . .like With data |
Q33 ⇒ What is true about indexes? It makes harder for sql server engines to work to work on index which have large keys [other wrong options] [Discuss in forum] Indexes enhance the performance even if the table is updated frequently It doesn’t make harder for sql server engines to work to work on index which have large keys None of the mentioned |
Q34 ⇒ The set of permitted values for each attribute is called its : Attribute range [other wrong options] [Discuss in forum] Attribute set Group Domain |
Q35 ⇒ A deadlock exists in the system if and only if the wait-for graph contains a ___________. Cycle [other wrong options] [Discuss in forum] Rotation Direction Bi-direction |
Q36 ⇒ Domain constraints, functional dependency and referential integrity are special forms of _________. Assertion [other wrong options] [Discuss in forum] Referential constraint Foreign key Primary key |
Q37 ⇒ The modify operation is likely to be done after : Look-up [other wrong options] [Discuss in forum] Insert Delete None of above |
Q38 ⇒ Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ? ID [other wrong options] [Discuss in forum] CITY , ID NAME CITY |
Q39 ⇒ Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of: Data integrity constraints [other wrong options] [Discuss in forum] Attributes Method constraints Referential integrity constraints |
Q40 ⇒ Data item characteristics that are important in data management include Width [other wrong options] [Discuss in forum] spelling language all of above |
Or |