|
CS403
|
Browser Based Forms Are Developed In The Following Tools Except
|
Html
|
Scripting Language
|
Front Page
|
Web-Based Forms
|
D
|
|
CS403
|
Which Of The Following Serves As A Milestone Or Reference Point In The Log File?
|
Constraints
|
Relations
|
Check Points
|
Transactions Identities
|
C
|
|
CS403
|
Which Of The Following Is Not One Of The Properties Of Transaction?
|
Atomicity
|
Consistency
|
Redundancy
|
Durability
|
C
|
|
CS403
|
The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement
The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement
|
In
|
From
|
Like
|
None Of The Above
|
C
|
|
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
|
The Er Model Is Meant To
|
Replace Relational Design
|
Be Close To A Users Perception Of The Data
|
Enable Low Level Descriptions Of Data
|
Enable Detailed Descriptions Of Data Query Processing
|
D
|
|
CS403
|
A Relational Database System Is Based On The Concept(S) Of:
|
A Network Of Data Records
|
Nested Tables
|
Tables Rows And Columns
|
A Tree-Like Structure Of Data
|
A
|
|
CS403
|
Which Of The Following Is Not A Feature Of Context Dfd?
|
One Process (Which Represents The Entire System)
|
All Sources/Sinks (External Entities)
|
Data Flows Linking The Process To The Sources And Sinks (External Entities)
|
Sub-Processes (Which Explain And Decomposed The Major Process Into Small Processes)
|
D
|
|
CS403
|
Which Levels Are Mostly Used For Detailed Dfd?
|
Level-0 Level-1
|
Level-1 Level-2
|
Level-2 Level-3
|
Level-3 Level-4
|
A
|
|
CS403
|
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
|
Superkey
|
Candidate Key
|
Primary Key
|
Secondary Key
|
C
|
|
CS403
|
Which Of The Following Is One Of The Purposes Of Using Dml Commands?
|
Creating Databases
|
Destroying Databases
|
Inserting Data In Tables
|
Non Of The Above
|
C
|
|
CS403
|
Which Of The Following Gives All The Fields From Employee Table Named As Emp?
|
Select * From Emp;
|
Select Emp* From Emp
|
Select Emp_Id Where Emp;
|
Select * Where Emp;
|
A
|
|
CS403
|
Which Of The Following Is Not A Ddl Command?
|
Create Db
|
Create Table
|
Delete
|
Drop
|
C
|
|
CS403
|
The Room Id + Building Id Determines The Room Schedule. This Is Written
|
Room_Id Build_Id ? Room_Sch
|
Room_Id + Build_Id ? Room_Sch
|
Room_Id Room_Sch ? Build_Id
|
Room_Id Build_Id ? Room_Sch
|
A
|
|
CS403
|
Which Of The Following Will Be Deleted Relating To A Table If You Use Truncate Command?
|
All Rows In A Table
|
Indexes
|
Table Structure And Its Columns
|
Constraints
|
A
|
|
CS403
|
Which Of The Following Is A String Function In Sql
|
Count
|
Len
|
Sqrt
|
Sin
|
B
|
|
CS403
|
Which Of The Following Accurately Describes A Crosstab Query?
|
Crosstab Queries Have Very Limited Summary Capabilities
|
Crosstab Queries Are Seldom Used To Generate Reports
|
If You Select Row Totals In The Crosstab Query You Cannot Also Select Column Totals
|
You Can Select Row Totals And Also Column Totals
|
C
|
|
CS403
|
Which Of The Following Is Not True About De-Normalization?
|
It Is The Process Of Attempting To Optimize The Performance Of A Database
|
De-Normalization Is A Technique To Move From Lower To Higher Normal Forms Of Database Modeling
|
In De-Normalization It Is Required To Add Redundant Data.
|
It Enhances The Performance Of Db
|
B
|
|
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
|
A Record Set Is Exactly The Same As
|
A Query
|
A Data Access Page
|
A Table
|
A Macro
|
C
|