Database Management Systems

 

1	The files used for speedy disk search by providing the specialized structures of data are classified as
	a.       indexes	b.      glossaries
	c.       content specification	d.      listing documents
2	The master list of an indexed file
	a.       is sorted in ascending order	b.      contains only a list of keys and record numbers
	c.       has a number assigned to each record	d.      None of these
3	DBMS manages the interaction between __________ and database
	a.       Users	b.      Clients
	c.       End Users	d.      Stakeholders
4	Which of the following is not involved in DBMS?
	a)      End Users	b)      Data
	c)      Application Request	d)     HTML
5	What is the full form of DBA
	a)      Database Access	b)      Database Administrator
	c)      Database Authority	d)     None of the these
6	The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
	a.       a tree file	b.      a binary file
	c.       a hashed file	d.      a object file
7	Which term used to refer to a row in a table?
	a)      attribute	b)      tuple
	c)      field	d)     instance
8	Which database level is closest to the users?
	a)      External	b)      Internal
	c)      Physical	d)     Conceptual
9	The physical location of a record is determined by a mathematical formula that transforms a file key into a record location is :
	a)      B tree File	b)      Hashed File
	c)      Sequential File	d)     None of these
10	In an ER model, which one is described in the database for storing its data?
	a)      entity	b)      attribute
	c)      relationship	d)     notation
11	If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
	a)      delete	b)      update
	c)      Sort Key	d)     index
12	What is the degree of a table of 50 rows and 5 columns
	a)      50	b)      5
	c)      250	d)     None of these
13	In the relational modes, cardinality is termed as:
	a)      Number of tuples	b)      Number of attributes
	c)      Number of tables	d)     Number of constraints
14	Which one of the following is not an indexing technique ?
	a)      Primary index	b)      Secondary index
	c)      Multilevel index	d)     Sequential index.
15	The full form of ER Diagram is
	a)      Entity -Relationship Diagram	b)      Entity Relation Diagram
	c)      Entity Rotation Diagram	d)     None of these
16	An indexing operation
	a)      sorts a file using a single key	b)      sorts file using two keys
	c)      establishes an index for a file	d)     both (b) and (c)
17	…………… clause is an additional filter that is applied to the result.
	a)      Select	b)      Group-by
	c)      Having	d)     Order by
18	_____ command is used for modifying an existing table
	a)      CREATE	b)      ALTER
	c)      DROP	d)     None of these
19	Which index is specified on the non-ordering fields of a file ?
	a)       Primary	b)      Clustering
	c)      Secondary	d)     None of these
20	……. command can be used to modify a column in a table
	a)      alter	b)      update
	c)      set	d)     create
21	DCL stands for ___________
	a) Data Count Language	b) Data Control Language
	c) Data Connection Language	d) None of these
22	____ command is used to give permission.
	a) GRANT	b) ALTER
	c) CREATE	d) None of these
23	Select operator (ϭ) works row wise where as project operator(Π) works
	a) Row wise only	b) Column wise only
	c) both Row wise only & Column wise only	d) None of these
24	A clustering index is defined on the fields which are of type
	Non-key and ordering	Non-key and non-ordering
	Key and ordering	Key and non-ordering
25	Which of the following is not a built in aggregate function in SQL?
	a) avg	b) max
	c) total	d) count
26	What values does the count(*) function ignore?
	a) Repetitive values	b) Null values
	c) Characters	d) Integers
27	The ________ clause is used to list the attributes desired in the result of a query
	a) select	b) from
	c) where	d) create
28	The ______ operator is used to compare a value to a list of literals values that have been specified
	a) BETWEEN	b) ANY
	c) IN	d) ALL
29	An organized logical sequence of records is called
	a)      file	b)      organization
	c)      scrubbing	d)      sequencing
30	A primary key cannot be ______
	a) void	b) null
	c) both void & null	d) None of these
31	Files are logically partitioned into storage units of fixed-length known as
	a)      sector	b)      tracks
	c)      segment	d)      blocks
32	Technique used in DBMS to store all related objects in mixed file is classified as
	a)      ternary clustering	b)      secondary clustering
	c)      physical clustering	d)      primary clustering
33	The term _______ is used to refer to a row
	a)      Attribute	b)      Tuple
	c)      Field	d)      Instance
34	Fields which are used to retrieve related records from other files are called
	a)      secondary fields	b)      key fields
	c)      primary fields	d)      connecting fields
35	A relational database consists of a collection of
	a)      Tables	b)      Fields
	c)      Records	d)      Keys
36	A top-to-bottom relationship among the items in a database is established by a
	a)      Hierarchical schema	b)      Network schema
	c)      Relational schema	d)      All of the mentioned
37	The file organization which allows us to read records that would satisfy the join condition by using one block read is
	a)      Heap file organization	b)      Sequential file organization
	c)      Clustering file organization	d)      Hash file organization
38	The restrictions placed on the data.
	a)      Relation	b)      Attribute
	c)      Parameter	d)      Constraint
39	A unit of storage that can store one or more records in a hash file organization is denoted as
	a)      Buckets	b)      Disk pages
	c)      Blocks	d)      Nodes
40	VDL stands for
	a) Very small data language	b) View data language
	c) View Definition Language	d) None of these
41	Every BCNF form is in
	a)      1NF	b)      2NF
	c)      3NF	d)      All of these
42	DDL stands for _______
	a)      Data Definition Language	b)      Data Define Language
	c)      Data Dictionary Language	d)      None of these
43	If every non-key attribute is functionally dependent on the primary key, then the relation will be in
	a)      1NF	b)      2NF
	c)      3NF	d)      4NF
44	Cartesian product in relational algebra is
	a)      Unary operator	b)      Binary operator
	c)      Ternary operator	d)      not defined
45	The database schema is written in
	a) HLL	b) DML
	c) DDL	d) DCL
46	A BCNF is:
	a)      Lossless join and dependency preserving	b)      Lossless join   but not dependency preserving
	c)      Not Lossless join but dependency preserving	d)      None of these
47	A property which ensures that each functional dependency is represented in some individual relation resulting after decomposition
	a)      Lossless join	b)      Dependency preservation
	c)      Both a and b	d)      None of these
48	In an E-R diagram attributes are represented by
	a)      rectangle	b)      square
	c)      ellipse	d)      triangle
49	Functional dependencies are a generalization of
	a)      Key dependencies	b)      Relation dependencies
	c)      Database dependencies	d)      None of these
50	The number of tuples of a relation is its
	a)      Degree	b)      Intention
	c)      Cardinality	d)      None of these