In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
Revoke is a __________ Statement
Data Definition
Control Access
Data Manipulation
Data Description
Which of the following is not true regarding clustering ?
It increases the efficiency since related records are placed close to each other.
Clustering makes records, difficult to access
Suitable to relatively static situations
It is a process, which means to place record from different tables to places in adjacent physical locations.
DML does not used to :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition
The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:
IN
FROM
LIKE
None of the above.
Identify the basic part(s) of a SELECT statement?
SELECT
FROM
Both SELECT and FROM
DISTINCT
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
All records from the table are deleted
No record from the table will be deleted
First record of the table will be deleted
The statement will not be executed and will give a syntax error
Truncate is an alternative of Delete command.
Select correct option:
True
False
SQL data types do not have support for storing multi-media objects directly. Select correct option:
True False
Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server. Select correct option:
True False
Identify the language which is used to specify database schema.
DCL DML DDL None of the above
Value of a function in SQL is always determined by the input parameters
True False
Which of the following clauses allows to sort the records in result set?
Where
Order by
From
Having
Which of the following cannot be included into CREATE TABLE statement?
Select correct option:
Data types
Constraints
Attributes
Cardinalities
Which of the following describes the job of a database administrator?
Select correct option:
Development, implementation operation of the physical database
Creation of the system catalog
Monitoring and controlling database security and authorization: Setting up controls to ensure the quality and integrity of data
All of the above
What does the abbreviation DBMS stand for?
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.
The ____________ keyword is used in SELECT statement to return different values. Select correct option:
LIKE IN DISTINCT WHERE
DML stands for _____________. Select correct option:
Dynamic Modeling Language Data Manipulation Language Data Management Language Domain Modeling Language
Functions in SQL return a single value Select correct option:
True False
A table can be logically connected to another table by defining a __.
hyperlinkcommon attribute
primary key
superkey
Which of the following is INCORRECT statement concerning the database design process?
During requirements collection and analysis phase, one can gather the data requirements of database users.By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.
Which of the following is correct regarding Dataflow diagram?
Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectionalUsed to represent the relationships among the external entities
A collection of concepts that can be used to describe the structure of a database
Database
DBMSData model
Data
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option:
Database DesignerDatabase Administrator
End User
Application Programmer
A software package designed to store and manage databases
Select correct option:
Database
DBMSData model
Data
The main software package that supports a database management approach is called
Select correct option:
Data Dictionary
Report GeneratorDatabase Management System
Distributed database
A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
Select correct option:
True
False
Partially True
None of the given
Question # 6 of 10 ( Start time: 11:30:35 AM ) Total M a r k s: 1
Which of the following is NOT a component of a DFD?
Select correct option:
Dataflow
Datastore
External entitiesRelationship between external entities
A________is used to maintain a connection between the users of the database system.
Select correct option:
mail serverfile server
client-server
none of the given
An instance is
Select correct option:
a particular occurance of an entity
a special type of relation
an attribute of an entity
any particular entity
A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
True
False
Partially True
None of the given
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleastOne process only
Any number of processes
An entity type is
defined when the database is actually constructed
a specific type such as an integer, text, date, logical etc
a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
defined by the database designer
Data about data is database
True
False
Partially True
None of the Above
The ER model is meant to
Select correct option:
replace relational design
be close to a users perception of the data
enable low level descriptions of dataenable detailed descriptions of data query processing
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
Select correct option:
User accessible catalog
Data processingRecovery service
Authorization service
A relational database system is based on the concept(s) of:
Select correct option:
A network of data records
Nested tablesTables, rows and columnsA tree-like structure of datas
Question # 1 of 10 ( Start time: 05:35:55 PM ) Total M a r k s: 1
Controlling redundancy in a database management system DOES NOT help to
Select correct option:
avoid duplication
avoid unnecessary wastage of storage spaceavoid unauthorised access to data
avoid inconsistency among data
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
Select correct option:
Physical data independenceLogical data independence
Functional dependency
Concurrency control
A description on a particular collection of data using the given data model
Select correct option:
Database
RelationSchema
None
Which of the following functions are NOT performed by a database administrator?
Select correct option:Planning, designing and implementing database systems
Establishing standards and procedures for database systems
Communicating with database users
Allocation of storage locations and data structures
A collection of concepts that can be used to describe the structure of a database
Select correct option:
Database
DBMSData modelData
A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a __.
Select correct option:
superkey
candidate keyprimary key
secondary key
ncase of Context-level Diagram, the system is represented by
Select correct option:
One process atleast
Two processes atleastOne process only
Any number of processes
