CS101 532 CS201 225 CS301 232 CS302 174 CS304 192 CS401 224 CS402 258 CS403 228 CS408 113 CS411 121 CS502 249 CS504 268 CS601 679 CS604 381 CS605 261 CS607 184 CS609 230 CS610 300 CS614 100 CS703 65
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