DatabaseDesignUsingSQ(D).docVIP

PAGE  PAGE 5 If a foreign key exists in a relation, foreign key value must match a candidate key value of some tuple in its home relation or the foreign key value must be wholly null. A) True B) False Which of the following terms is NOT a step in database development process? A) Planning B) Design C) Implement D) Maintenance Which level of RAID is also know as mirroring with striping? A) Level 1 B) Level 2 C) Level 5 D) Level 10 Partial dependencies will be removed when we reach ______. A) 1NF B) 2NF C) 3NF D) BCNF To be considered minimally relational, the DBMS must support the key relational functions, which of the following functions is NOT the key relational function? A) Select B) Union C) Join D) Project E) None of the above Temporary tables have names start with a ______. A) % B) $ C) # D) ~ E) None of the above Which of the following data types is NOT a Special data type? A) Unicode B) Timestamp C) Table D) Bit E) None of the above Which of the following technologies is responsible for analysing trends in corporate data in an organisation? A) OLTP B) OLAP C) OLLP D) ISW E) None of the above If Tony is NOT a member of the sysadmin fixed server role but is a member only of the db_owner fixed database role and creates a table T1, then T1 will be qualified as: A) db.T1 B) Tony.T1 C) sysadmin.T1 D) dbo.T1 E) None of the above Which of the following SQL components provides facilities for storing, viewing, and retrieving descriptions of the objects in your applications and system? A) Microsoft SQL Server 2000 Analysis Services B) SQL Server 2000 English Query C) SQL Server 2000 Data Transformation Services (DTS) D) Metadata Services Which of the following statements is NOT a Data Manipulation Language command? A) Update statement B) Delete statement C) Select statement D) Set statement E) Insert statement Which of the following tools is used to register individual servers in a group A) Client Network utility B) SQL Server Enterprise Manager