MCQGeeks
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Database
Quiz 2
Solution
Q.1.
A ternary relationship involves how many entities?
3 or less
3
More than 3
3 or more
Q.2.
The benefits of object-oriented modeling are which of the following?
The ability to tackle more challenging problems
Reusability of analysis, design, and programming results
Improved communication between users, analysts, etc.
All of the above.
Q.3.
The ODBC core API consists of which of the following functions?
Commit or rollback transactions only
Connect to data sources only
Connect to data sources with driver-specific information only
Both 1 and 2 above are in the OBDC core API.
Q.4.
The ODBC core API consists of which of the following functions?
Commit or rollback transactions only
Connect to data sources only
Connect to data sources with driver-specific information only
Both 1 and 2 above are in the OBDC core API.
Q.5.
To drop a column that is used as a foreign key, first:
drop the primary key.
drop the table containing the foreign key..
drop the foreign key constraint.
All of the above must be done.
Q.6.
To drop a column that is used as a foreign key, first:
drop the primary key.
drop the table containing the foreign key..
drop the foreign key constraint.
All of the above must be done.
Q.7.
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Two
Three
Four
Six
Q.8.
A shared database should:
be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
Q.9.
A shared database should:
be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
Q.10.
A collection of interrelated records is called a
Datasheet
Spreadsheet
Database
Utility File
Q.11.
A collection of interrelated records is called a
Datasheet
Spreadsheet
Database
Utility File
Q.12.
In a 1:N relationship, the foreign key is placed in:
the parent table.
the child table.
either table without specifying parent and child tables.
either the parent table or the child table.
Q.13.
SQL Server program code that is executed instead of an SQL command that needs to be processed is called
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.
Q.14.
The capacity to change the conceptual schema without having to change external schemas or application programs is called
Physical Data Independence
Logical Data Independence
Both A and B
None
Q.15.
Legacy data is which of the following?
Data contained in a newly-installed system
Data rejected during the installation of a new system
Data contained in a file system
Data contained by a system used prior to the installation of a new system
Q.16.
In the relational model, relationships between relations or tables are created by using:
composite keys.
determinants.
candidate keys.
foreign keys.
Q.17.
If a table has been normalized so that all determinants are candidate keys, then that table is in:
1NF
2NF
3NF
BCNF
Q.18.
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
DISTINCT
UNIQUE
SINGLE
Q.19.
A proxy server is used for which of the following?
To provide security against unauthorized users
To process client requests for Web pages
To process client requests for database access
To provide TCP/IP
Q.20.
A proxy server is used for which of the following?
To provide security against unauthorized users
To process client requests for Web pages
To process client requests for database access
To provide TCP/IP
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page