Online Exam Preparation
MCQs Library
Browse subject-wise multiple choice questions, review answers quickly, and start a test from the same section.
Questions
| Code | Question | Option A | Option B | Option C | Option D | Answer |
|---|---|---|---|---|---|---|
| CS403 |
What Does The Abbreviation Dbms Stand For?
|
Database Manipulation Software
|
Data Borrowing And Movement Software
|
Digital Base Mapping System
|
Database Management System
|
D |
| CS403 |
What Does The Wildcard ? Match?
|
Zero Or More Of The Preceding Character
|
Any One Character In The Position Held By The ?
|
Multiple Characters In The Position Held By The ?
|
Any Letter In The Position Held By The ?
|
B |
| CS403 |
What File Does Access Use To Lock A Database In A Shared Environment?
|
The Ldb File
|
The Pid File
|
The Mde File
|
The Mdb File
|
A |
| CS403 |
What Functions Would You Use To Put The Current Time And Data Output In A Report Header?
|
Time() And Now()
|
Time() And Currentdate()
|
Currenttime() And Now()
|
Currenttime() And Currentdate ()
|
A |
| CS403 |
What Happens If The Where Clause Is Omitted From A Delete Statement?
|
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
|
A |
| CS403 |
What Is Required To Establish A 1:1 Relationship Between Two Tables That Do Not Contain A Supertype And Subtype?
|
:1 Relationships Are Only Possible If The Tables Contain A Supertype And Subtype
|
Make Sure That The Pk In The Related Table Has Unique Values
|
Make Sure That The Fk In The Related Table Has An Index Property That Specifies Unique Values
|
Nothing Special Is Required
|
C |
| CS403 |
What Is The Difference Between A Dbms And An Rdbms?
|
A Rdbms Uses Metadata While A Dbms Does Not
|
A Dbms Is Used For Data Warehousing
|
Because A Relational Database Is More Complicated Than A Conventional Database The Rdbms Requires Much More Computing Power Than The Conventional Dbms Requires
|
Because A Conventional Database Is Less Complicated Than A Relational Database The Dbms Is Used More Often For Transactional Databases
|
C |
| CS403 |
What Is The Impact Of Setting Multiple Indexes For The Same Key In Index Sequential Files?
|
Multiple Indexes For The Same Key Can Not Be Set
|
It Will Increase Complexity As The Access Time Will Be Increased
|
It Increases Efficiency
|
It Decreases Efficiency
|
C |
| CS403 |
What Is The Most Common Form Type?
|
A Single-Source Form Based On A Tabular Format
|
A Single-Source Form Based On A Columnar Format
|
A Multi-Source Form Based On A Tabular Format
|
A Multi-Source Form Based On A Columnar Format
|
A |
| CS403 |
What Kind Of Query Works Best With The Chart Wizard?
|
Append
|
Update
|
Action
|
Select
|
D |
| CS403 |
What Macro Will Be Executed Automatically When You Open The Database?
|
Autoexec
|
Autostart
|
Startup
|
Autorun
|
A |
| CS403 |
What Permission Allows The User To Open A Database Form Or Report Or Run A Macro?
|
Open
|
Open/Run
|
Administer
|
Run
|
B |
| CS403 |
What Standard Must A Basic Html-Based Web Page Conform To?
|
Tcp/Ip
|
Ascii
|
Xml
|
Sql
|
B |
| CS403 |
What Will The Following Questions Help You Define? What Types Of Transactions Take Place? How Many Different Types Of Transactions Are There?
|
Available Resources
|
Data Environment
|
Current Operations
|
Business Objectives
|
C |
| CS403 |
Whats The Maximum Number Of Different Fields That Can You Sort In The Page Wizard?
|
1
|
2
|
3
|
4
|
D |
| CS403 |
When Inserting A Field In The Footer What Is The Default Prefix Is
|
Totalof <Fieldname>
|
Sumof <Fieldname>
|
Maximumof <Fieldname>
|
Minimumof <Fieldname>
|
B |
| CS403 |
Which Cannot Be Dragged To A Data Access Page Using The Controls Wizard?
|
Tables
|
Controls
|
Macros
|
Queries
|
C |
| CS403 |
Which Feature Of Database Provides Conversion From Inconsistent State Of Db To A Consistent State Ensuring Minimum Data Loss?
|
User Accessible Catalog
|
Data Processing
|
Authorization Service
|
Recovery Service
|
D |
| CS403 |
Which Key Word Is Available In Sql To Enforce Referential Integrity?
|
Check
|
Primary Key
|
Set Default
|
Unique
|
B |
| CS403 |
Which Language Is Used To Permit Or Prohibit Access To A Table?
|
Dcl
|
Ddl
|
Dml
|
All Of The Above
|
A |