Database Questions Answers

Q1. Which database is shared by all users of all databases on the servers for conserving storage space
(a) Sybdiag database
(b) Sybsecurity database
(c) Tempdb database
(d) dbccdb database

Q2. Data items grouped together for storage purposes are called
(a) Record
(b) Title
(c) List
(d) String

Q3. ______ have an ability to change the internal schema without having to change the external schema
(a) Logical data dependence
(b) Logical data independence
(c) Physical data dependence
(d) Physical data independence

Q4. Which one provide a single inter face that enables users to search many different search engine, indexes and database simultaneously
(a) Web Index
(b) Search Engine
(c) Meta-Search Engine
(d) Internet Relay Chat

Q5. Which connective is used to test the absence of set membership in SQL
(a) minus
(b) not in
(c) or
(d) intersection

Q6. Suppose you own a student table, the correct syntax for giving delete privileges to all users of the database with one SQL statement is
(a) Grant delete to all on student;
(b) Grant delete on student to public;
(c) Grant delete to public on student;
(d) Grant delete on student to all;

Q7. The language component of DBMS which can be embedded in a program is
(a) the database administrator (DBA)
(b) the data definition language (DDL)
(c) the data manipulation language (DML)
(d) a query language

Q8. A command to remove a relation from an SQL database
(a) Delete table
(b) Drop table
(c) Erase table
(d) Alter table

Q9. The key chosen by database designer as principal means of identifying entities within an entity set is
(a) Candidate key
(b) Super key
(c) Foreign key
(d) Primary key

Q10. The database must not contain any unmatched foreign key values. This property is known as
(a) Atomicity
(b) Consistency
(c) Referential integrity
(d) Entity integrity

Q11. Which is not a database anomaly
(a) Update anomaly
(b) Create anaomaly
(c) Deletion anomaly
(d) Insertion anomaly

Q12. User's view in a database is also called
(a) External view
(b) Conceptual view
(c) Internal view
(d) Contextual view

Q13. A relational database environment has all of the following components except
(a) Users
(b) Database
(c) Separate files
(d) Query language

Q14. Which clause represents a Cartesian-product operation in a basic structure of an SQL expression
(a) Select
(b) From
(c) Where
(d) as

Q15. The content of the database cannot be modified using the operation
(a) Deletion
(b) Insertion
(c) Updating
(d) Selection

1 2