Database Management System MCQ
Correct Answer:
Hop
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Restoring the database from the save and reprocessing all the transactions since the save
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Records managementsystem
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DASHBOARD
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Microsoft Access
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Capture raw transaction data
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Atomicity, consistency, isolation, and durability
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Authorized
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Tablespace.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Character
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
One
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Access control
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
ORDER BY
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Screen reader software
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Distinct
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
XML/Hybrid data model
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Unnormalized relation
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Relationship
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Insert
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
A double horizontal line under a circle
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Enhanced entity relationship model
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Query
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Many
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Rounded box
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data warehouse.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Make-table
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Domain
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Print Preview
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Maximum and minimum
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
data repository
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Composite
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data isolation
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Introducing changes
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Redundant
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database administrator.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Range
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
XML
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Planning
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Binary
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Relationship
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Auto-number.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
UNION
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Primary
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Attributes.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DBMS
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
1:1
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
SQL Server
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Mental Models
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
CREATE VIEW
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Duplicate records are not stored in the database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Operational databases
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
HOME
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Caption
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Collection of files
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Constructor, created
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
INSERT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
4GL
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Cloud
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Dimension tables
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data flows
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
INT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Long Text
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
The analyst must develop explanations for patterns after observing the pattern
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Semistructured
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
High normalization
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
High query activity
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Pointer
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Commonly occurs in database redesign
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Both of the above
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
The most instances of one entity class that can be involved in a relationship instance with another entity class
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data propagation.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Asterisk (*)
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DELETE.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
INTO
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Create a new table, move the data and drop the old table
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Design
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
"SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition"
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Create view
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
AVG
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
JOIN
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DECLARE
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
BEGIN
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Not equal to
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
UNION
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
IN
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
SMALLINT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
SET columnname = expression
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
COUNT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
SUM
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Constraint dependent subqueries
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
4GL
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
XML/Hybrid data model
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DESC
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
TO_CHAR()
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Type
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Table.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Camel case
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Bitmapped
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Make sure that the table entities are normalized before table structures are created
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Natural
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Domain
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Processing
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Trigger.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Entity.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Cube.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
IIF
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Client, name
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Composite
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
IN
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
USE
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Mysqli_free_result
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Query UNION query
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DROP TABLE Smaller ;
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Transmission delay when users are geo-dispersed
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
SELECT-FROM-WHERE
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DEFAULT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
LIKE
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
IN
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Orphan
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DBMSs
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
INTERSECT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Administering the database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
2nd
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Legal-values
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database does not need to be changed if a change is made to an application
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
FROM
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Allocate storage space
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
In-memory
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
ADD
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Metadata
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Select
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Inaccurate, incomplete data
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
You wish to use a visual approach to query building
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Create a detailed narrative of the organization's description of operations
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Query result set
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DBMS
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
PROJECT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Pull-based model
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Frequency distribiution
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Improving the couple's patterns of communication so they can find better ways of solving their problems
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Marla, who was punished for not telling the teacher who threw a paper airplane
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Dimension
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
An encoding error
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Derived
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DBA
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
primary key
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Inserting or deleting information
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Parses
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Fetches
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data definition
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Manipulation
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Multivalued
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
PROJECT
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
IS NULL
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Optimizer
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Metadata
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Query by Example (QBE)
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Simple
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Normalized
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Foreign keys
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database management system
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Accuracy
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Archive
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Update anomalies
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Output
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Required
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Attribute
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Windows
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
3NF
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Operational databases
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data that are encrypted
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Forms
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Granularity
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DML
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Flat Files
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Third normal form
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Record *
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Create table
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Candidate key
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Null
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
File
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Storage space is reduced
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Student ID#.
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Attribute
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Software
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Is a temporary file created by an information system for a single task
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Is created and saved for backup and recovery purposes
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data integrity problem
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Field
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Relation
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
File
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Clients
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Composite key
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
The level of detail represented by the values stored in a table's row
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
3NF and BCNF
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Maintenance
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Short text
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Index
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Column
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Attribute
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Column
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Create or modify the structure of
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Minimum
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Two
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Binary
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Foreign keys
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Support querying using graphics
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data warehouse
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data dictionary
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Record
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Bridge
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Composite entity
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Field
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
DBMS
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Object
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
PUBLIC
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Transaction
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Developing recovery procedures in case data is lost or corrupted
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Definition
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
One in which all data integrity constraints are satisfied
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Table
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database management system
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Distributed
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Browsers
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Normalization
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Data mining
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Relational
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Relational
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Information
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Every foreign-key value must match a primary-key value in an associated table
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Critical Level
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Third Normal Form
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
CREATE SCHEMA
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Client server
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Null < > 0
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Composite Attribute
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Functional dependency
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Drop table < table name >
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Atomicity, Consistency, Isolation, Durability
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Modify
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database Instance
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
UPDATE
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Database Administrator
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Option Non Null and Unique
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Both retrieve information from files and answer queries
Note: This Question is unanswered, help us to find answer for this one
Correct Answer:
Create information table in the Database
Note: This Question is unanswered, help us to find answer for this one
Database MCQs | Topic-wise