Sawaal
  • Home/
  • Searching for and

 Searching for "and"

Q:

 When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A) LIKE only. B) IN only.
C) NOT IN only. D) Both IN and NOT IN.
 
Answer & Explanation Answer: D) Both IN and NOT IN.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The load and index is which of the following?

A) A process to reject data from the data warehouse and to create the necessary indexes B) A process to load the data in the data warehouse and to create the necessary indexes
C) A process to upgrade the quality of data after it is moved into a data warehouse D) A process to upgrade the quality of data before it is moved into a data warehouse
 
Answer & Explanation Answer: B) A process to load the data in the data warehouse and to create the necessary indexes

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

SQL Server program code that is executed instead of an SQL command that needs to be processed is called

A) INSTEAD OF trigger. B) BEFORE trigger.
C) AFTER trigger. D) BEGIN trigger.
 
Answer & Explanation Answer: A) INSTEAD OF trigger.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

A) Nonrepeatable read B) Phantom read
C) Dirty read D) Consistent read
 
Answer & Explanation Answer: A) Nonrepeatable read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

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

Q:

You are setting up a computer for students to use to practice exercises for their certification exams. You want to configure the computer so that users can boot into both Windows 98 and Windows 2000 Professional. You want to ensure that students can access all drive resources from either operating system. What should you do?

A) Create a single FAT32 partition. B) Create a single NTFS volume.
C) Configure one NTFS volume, and one extended FAT32 partition. D) Configure a dynamic volume.
 
Answer & Explanation Answer: A) Create a single FAT32 partition.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

Sachin works for a computer training institute in North America.After discussing the steps of installing Windows XP professional in the class room, sachin divided the students in a group of two and asked them to complete the installation on their respective machines.But none of the students were able to complete the installation process.Identify the solution that is the cause to the above problem.

A) Needs to run XP Upgrade Adviser to avoid compatibility problem B) Needs to run XP Upgrade Professional to avoid compatibility problem
C) Needs to run XP Upgrade Home Edition to avoid compatibility problem D) Needs to run XP Service Pack to avoid compatibility problem
 
Answer & Explanation Answer: A) Needs to run XP Upgrade Adviser to avoid compatibility problem

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

Q:

You recently been promoted to Network Administrator for DLM Shipping. When you took over this position the first thing you notice is this Windows 2000 environment using DNS naming convention, root domain is DIM.COM, with numerous child domains. User accounts are stored in the child domains. However your supervisor informs you that root domain is misspelled and should be DLM.COM. He explains this is causing tremendous problems with the users and customers. He wants you to rename the domain. What will happen if you rename this root domain server?

A) When you rename the root domain server you will only have to rebuild the user accounts since the root domain holds the authentication (SAM) database. B) When you rename the root domain server you will simply rename the child domain also.
C) When you rename the root domain server you will lose the entire network orphaning the child domains. D) When you rename the root domain server you will not need to do anything else since domain names are inherited the child domains will acquire the new domain name.
 
Answer & Explanation Answer: C) When you rename the root domain server you will lose the entire network orphaning the child domains.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert