|
CS403
|
You Can’T Modify More Than One Table At A Time Through A View
|
True
|
False
|
|
|
A
|
|
CS403
|
Which Syntax Will Concatenate Employee First And Last Names With A Space In Between The Names?
|
([Emp_Fname] & [Emp_Fname])
|
([Emp_Fname] & & [Emp_Fname])
|
([Emp_Fname] & [Emp_Fname])
|
([Emp_Fname] [Emp_Fname])
|
B
|
|
CS403
|
Database Management Systems Operating Systems Applications And Utilities Are All Examples Of __________
|
Hardware
|
Software
|
Computer Infrastructure
|
Input And Output
|
B
|
|
CS403
|
Which Of The Following Is The Correct Syntax For Adding A New Column Into An Existing Table?
|
Alter Table Table_Name { Alter [Column] Column Type [(Size)] [Default Default] }
|
Alter Table Table_Name { Add [Column] Column Type [(Size)] [Default Default] }
|
Both I And Ii
|
None Of The Above
|
B
|
|
CS403
|
Alter Table Exams Rename Column Q_Description To Question_Descp Std_Id To Student_Id. Syntax Of Alter Table Is Not Correct.
|
True
|
False
|
|
|
B
|
|
CS403
|
Which Of The Following Is Not A Form Of Optical Disk?
|
Cd Rom
|
Worm
|
Erasable Optical
|
Eeprom
|
D
|
|
CS403
|
Which Of The Following Statements Creates A Database Named Imdb
|
Create Database Imdb;
|
Create Db Imdb;
|
Add Database Named Imdb;
|
Create Imdb Database;
|
A
|
|
CS403
|
Grant Belong To Which Types Of Sql Command Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
C
|
|
CS403
|
Each Table Must Have A Key
|
Primary
|
Secondary
|
Logical
|
Foreign
|
A
|
|
CS403
|
In A Three-Level Dbms Architecture The Level Interacts Directly With The Users
|
External
|
Conceptual
|
Internal
|
Physical
|
A
|
|
CS403
|
Which Of The Following Is The Correct Way To Find Out The Size Of Cartesian Product Incase Of Cross Join?
|
The Number Of Columns In The First Table Multiplied By The Number Of Columns In The Second Table
|
The Number Of Columns In The First Table Multiplied By The Number Of Rows In The Second Table
|
The Number Of Rows In The First Table Multiplied By The Number Of Columns In The First Table
|
The Number Of Rows In The First Table Multiplied By The Number Of Rows In The Second Table
|
D
|
|
CS403
|
Given Are The Relations Of Student And Instructor Which Relational Algebra Operation Could Have Been Applied On The Pair Of Relations Student And Instructor To Obtain The Above Data?
|
Instructor – Student
|
Student n Instructor
|
Instructor ÷ Student
|
Student – Instructor
|
B
|
|
CS403
|
A Description On A Particular Collection Of Data Using The Given Data Model
|
Database
|
Relation
|
Schema
|
None
|
C
|
|
CS403
|
Which Of The Following Statements Best Describes A Data Warehouse?
|
A Data Storage Facility Dedicated To Using The Existing Data To Generate Information
|
Frequent And Complex Transactions Characterize Its Use
|
The Most Common Type Of Database In Use Today
|
Generally Used In Environments With Large Inventories Thus The Term Warehouse
|
A
|
|
CS403
|
Structural Constraints Of A Relationship Type Refer To
|
Identifying The Owner Entity Type Relevant To A Given Entity Type
|
Whether The Existence Of An Entity Depends On It Being Related To Another Entity Via The Relationship Type
|
The Role That A Participating Entity From The Entity Type Plays In Each Relationship Instance
|
The Constraints Applicable In Granting Access To Tables Columns And Views In A Database Schema
|
B
|
|
CS403
|
What Does Access Use To Manage Database Locking In A Multiuser Database Environment?
|
Jet Database Engine
|
Pid Files
|
Mdw Files
|
Access Lockout Protocol (Alp)
|
A
|
|
CS403
|
In Sql Queries While Creating Tables Or Relations In Database Key Columns May Be Specified By
|
Bull
|
Not Null
|
Data Type
|
None Of The Above
|
B
|
|
CS403
|
Data About Data Is Database
|
True
|
False
|
|
|
F
|
|
CS403
|
Which Of The Following Might Be Represented With A Multivalued Attribute?
|
Persons Name
|
Class Location
|
Bank Account Balance
|
Book Title
|
B
|
|
CS403
|
Value Of A Function In Sql Is Always Determined By The Input Parameters
|
True
|
False
|
|
|
A
|