Database Online Test

1.	The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
	A. True B. False

2.	Which of the following is true concerning triggers?
	A. You do not create them with SQL. B. They execute against only some applications that access a database. C. They have an event, condition, and action. D. They cannot cascade (cause another trigger to fire).

3.	SQL Server program code that is executed after an SQL command has been processed is called a(n):
	A. INSTEAD OF trigger. B. BEFORE trigger. C. AFTER trigger. D. BEGIN trigger.

4.	How can you find rows that do not match some specified condition?
	A. EXISTS B. Double use of NOT EXISTS C. NOT EXISTS D. None of the above is correct.

5.	A tool that can help designers understand the dependencies of database structures is a:
	A. dependency graph. B. data model. C. graphical display. D. None of the above is correct.

6.	A transaction for which all committed changes are permanent is called:
	A. atomic. B. consistent. C. isolated. D. durable.

7.	The degree of a relationship refers to the number of entity classes in the relationship.
	A. True B. False

8.	A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
	A. True B. False

9.	Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
	A. True B. False

10.	To run a compiled Java program, the machine must have what loaded and running?
	A. Java virtual machine B. Java compiler C. Java bytecode D. A Web browser

11.	In a database, data is stored in spreadsheets which have rows and columns.
	A. True B. False

12.	The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
	A. True B. False

13.	Views can be used to show the results of computed columns.
	A. True B. False

14.	The size of the lock is referred to as the lock granularity.
	A. True B. False

15.	Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
	A. True B. False

16.	The DTD begins with the word:
	A. #PCDATA. B. XML. C. DOCTYPE. D. HTTPS.

17.	An attribute is a(n):
	A. column of a table. B. two dimensional table. C. row of a table. D. key of a table.

18.	JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
	A. True B. False

19.	MySQL is just as powerful as Oracle and is half the price.
	A. True B. False

20.	A workgroup typically comprises between 25 and 100 persons.
	A. True B. False

1.	The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
	A. True B. False Answer: Option A Learn more problems on : Introduction to SQL Discuss about this problem : Discuss in Forum

2.	Which of the following is true concerning triggers?
	A. You do not create them with SQL. B. They execute against only some applications that access a database. C. They have an event, condition, and action. D. They cannot cascade (cause another trigger to fire). Answer: Option C Learn more problems on : Advanced SQL Discuss about this problem : Discuss in Forum

3.	SQL Server program code that is executed after an SQL command has been processed is called a(n):
	A. INSTEAD OF trigger. B. BEFORE trigger. C. AFTER trigger. D. BEGIN trigger. Answer: Option C Learn more problems on : SQL Server 2000 Discuss about this problem : Discuss in Forum

4.	How can you find rows that do not match some specified condition?
	A. EXISTS B. Double use of NOT EXISTS C. NOT EXISTS D. None of the above is correct. Answer: Option B Learn more problems on : Database Redesign Discuss about this problem : Discuss in Forum

5.	A tool that can help designers understand the dependencies of database structures is a:
	A. dependency graph. B. data model. C. graphical display. D. None of the above is correct. Answer: Option A Learn more problems on : Database Redesign Discuss about this problem : Discuss in Forum

6.	A transaction for which all committed changes are permanent is called:
	A. atomic. B. consistent. C. isolated. D. durable. Answer: Option D Learn more problems on : Managing Multiuser Databases Discuss about this problem : Discuss in Forum

7.	The degree of a relationship refers to the number of entity classes in the relationship.
	A. True B. False Answer: Option A Learn more problems on : Data Modeling with ER Model Discuss about this problem : Discuss in Forum

8.	A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
	A. True B. False Answer: Option A Learn more problems on : Data Modeling with ER Model Discuss about this problem : Discuss in Forum

9.	Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
	A. True B. False Answer: Option B Learn more problems on : Physical Database Design Discuss about this problem : Discuss in Forum

10.	To run a compiled Java program, the machine must have what loaded and running?
	A. Java virtual machine B. Java compiler C. Java bytecode D. A Web browser Answer: Option A Learn more problems on : JDBC, Java Server Pages, and MySQL Discuss about this problem : Discuss in Forum

11.	In a database, data is stored in spreadsheets which have rows and columns.
	A. True B. False Answer: Option B Learn more problems on : Introduction to Database Discuss about this problem : Discuss in Forum

12.	The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
	A. True B. False Answer: Option A Learn more problems on : Advanced SQL Discuss about this problem : Discuss in Forum

13.	Views can be used to show the results of computed columns.
	A. True B. False Answer: Option A Learn more problems on : SQL for Database Construction Discuss about this problem : Discuss in Forum

14.	The size of the lock is referred to as the lock granularity.
	A. True B. False Answer: Option A Learn more problems on : Managing Multiuser Databases Discuss about this problem : Discuss in Forum

15.	Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
	A. True B. False Answer: Option A Learn more problems on : Distributed Databases Discuss about this problem : Discuss in Forum

16.	The DTD begins with the word:
	A. #PCDATA. B. XML. C. DOCTYPE. D. HTTPS. Answer: Option C Learn more problems on : XML and ADO.NET Discuss about this problem : Discuss in Forum

17.	An attribute is a(n):
	A. column of a table. B. two dimensional table. C. row of a table. D. key of a table. Answer: Option A Learn more problems on : The Relational Model and Normalization Discuss about this problem : Discuss in Forum

18.	JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
	A. True B. False Answer: Option A Learn more problems on : JDBC, Java Server Pages, and MySQL Discuss about this problem : Discuss in Forum

19.	MySQL is just as powerful as Oracle and is half the price.
	A. True B. False Answer: Option B Learn more problems on : JDBC, Java Server Pages, and MySQL Discuss about this problem : Discuss in Forum

20.	A workgroup typically comprises between 25 and 100 persons.
	A. True B. False Answer: Option B Learn more problems on : The Database Environment Discuss about this problem : Discuss in Forum