Sawaal

 Database Questions

Popular Latest Rated
Q:

Which of the following is not a database object in MS Access?

A) Reports B) Relationships
C) Tables D) Queries
 
Answer & Explanation Answer: B) Relationships

Explanation:

Queries, reports and tables are all related to database and relationships are not the database object and it is related to functions in mathyematics.

 Which_of_the_following_is_not_a_database_object_in_MS_Access1558073404.png image

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Project Manager , IT Trainer , Database Administration , Bank Clerk , Analyst

16 28424
Q:

 ON UPDATE CASCADE ensures which of the following?

A) Normalization B) Data Integrity
C) Materialized Views D) All of the above.
 
Answer & Explanation Answer: B) Data Integrity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

62 28204
Q:

 A DBMS that combines a DBMS and an application generator is ________ .

A) Microsoft's SQL Server B) Microsoft's Access
C) IBM's DB2 D) Oracle Corporation's Oracle
 
Answer & Explanation Answer: B) Microsoft's Access

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

32 22859
Q:

 Which of the following is the original purpose of SQL?

A) To specify the syntax and semantics of SQL data definition language B) To specify the syntax and semantics of SQL manipulation language
C) To define the data structures D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

 

Purpose of SQL are ::

* To define the data structures

* To specify the syntax and semantics of SQL manipulation language

* To specify the syntax and semantics of SQL data definition language

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer

19 22056
Q:

 A goal of data mining includes which of the following?

A) To explain some observed event or condition B) To analyze data for expected relationships
C) To confirm that data exists D) To create a new data warehouse
 
Answer & Explanation Answer: A) To explain some observed event or condition

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

27 20095
Q:

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

A) First normal form B) Second normal form
C) Third normal form D) Fourth normal form
 
Answer & Explanation Answer: B) Second normal form

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

16 18275
Q:

 For what purposes are views used?

A) To hide rows only B) To hide columns only
C) To hide complicated SQL statements only D) All of the above are uses for SQL views.
 
Answer & Explanation Answer: D) All of the above are uses for SQL views.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

13 17725
Q:

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

A) MySQL B) JSP/SQL
C) JDBC/SQL D) Sun ACCESS
 
Answer & Explanation Answer: A) MySQL

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

25 17523