DatabaseDesignUsingSQ(A).docVIP

PAGE  PAGE 4 A foreign key MUST reference a unique key. A) True B) False If a user is a member of application role, he can run an application. A) True B) False Which of the following terms is NOT a step in the database development process? A) Planning B) Design C) Implement D) Maintenance How many bytes are required to store int value? A) 2 B) 4 C) 8 D) 16 Which level of RAID doesn’t provide fault tolerance? A) Level 0 B) Level 1 C) Level 5 D) None of the above To be considered minimally relational, the DBMS must support the key relational functions, which of the following functions is NOT a key relational function? A) Select B) Union C) Join D) Project E) None of the above In SQL server, global temporary tables have names that 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 Jack is NOT a member of the sysadmin fixed server role, but is a member only of the db_owner fixed database role. If he creates a table T1, T1 will be qualified as: A) db.T1 B) Jack.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 C) Service Manager D) None of the abov