Database Questions Answers

Q16. 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

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

Q18. ______ 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

Q19. 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

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

Q21. 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;

Q22. 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

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

Q24. 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

Q25. 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

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

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

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

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

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

___________________________________________________________________________