Database design and implementation questions.

Find Database design and implementation university examination questions in acaproso.com

#	Question
1	SQL select Distinct statement is used to return only diverse values True OR False
2	The AND operator displays a record if the first condition or the second condition are true. True OR False
3	Alternate key is the set of minimal set of attributes that uniquely identifies each occurrence of an entity type. True OR False
4	The top down design approach begins at the fundamental level of attributes . It starts with identifying attributes and use that attributes to identify properties of entities and relationships.. True OR False
5	Attribute is a name column of a relation True OR False
6	Database systems are widely used to support state-of-art technolgy in the information era. Mention and briefly explain 4 representative applications Short answers
7	Give the meaning of the following terminologies as used in database: view relation one to many relationship SQL DBMS Short answers
8	Briefly explain components that are needed for any DBMS environment / system Short answers
9	Briefly describe the phases of any database system developmet Short answers
10	Write down the syntax for the following SQL commands TRUNCATE a TABLE SELECT two columns of your choice from a table INSERT data into a table DROP a table CREATE a table Short answers

1. Information We Collect