Question

In: Computer Science

SQL Questions 1. Select ALL of the TRUE statements. a. You can control the location of...

SQL Questions

1. Select ALL of the TRUE statements.

a. You can control the location of objects within a database onto specific disks/SAN LUNs only if multiple filegroups are created for each disk or SAN LUN

b. Dirty pages are data pages that have been updated in memory, but not yet written to disk
c. DBCC CHECKDB should be executed at all times to ensure data integrity

d. SQL Server data files and log files perform best on network shares as opposed to locally connected drives

e. Filegroups apply only to data files and not to log files

f. SQL Server always writes to the transaction log on disk before any data page is updated in the memory buffers
g. A SQL Server data file can be a part of multiple filegroups

2. SQL Server 2008 SP4 Enterprise Edition can be upgraded to which of the following SQL Server 2017 editions?

a. SQL Server 2017 Developer Edition

b. SQL Server 2017 Standard Edition

c. SQL Server 2017 Enterprise Edition

d. SQL Server 2017 Express Edition

3. SQL Server 2017 supports compatibility mode for which of the following versions of SQL Server?

Select one or more:

a. SQL Server 2008 R2
b. SQL Server 2005

c. SQL Server 2012

d. SQL Server 2014
e. SQL Server 2008

4. Which of the following statements are true in SQL Server?

Select ALL that apply:

a. SQL Server data files can only grow in multiples of 64K

b. You must pay for all editions of SQL Server

c. Server-side networking for SQL Server is configured at the Database level

d. It is best practice to set Auto_Update_Statistics & Auto_Create_Statistics to FALSE

e. A data page in SQL Server can only hold one object (e.g. a specific table, index, etc.)

f. SQL Server pages can be any size between 8K and 64K

g. You can have multiple versions of SQL Server installed on the same virtual server

5. Which of the following SQL Statements that will provide a list of all tables in the 'AdventureWorks2014" database and nothing else?

Group of answer choices

a. use AdventureWorks2014; Select * from sys.objects where type='TABLE'

b. use AdventureWorks2014; SELECT * FROM INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'

c. use AdventureWorks2014; Select * from INFORMATION_SCHEMA.TABLES

d. use AdventureWorks2014; Select * from system.tables

Expert Solution

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 2:

Answer :c. SQL Server 2017 Enterprise Edition

Explanation : SQL Server 2008 SP4 Enterprise Edition can be upgraded to SQL Server 2017 Enterprise Edition.

***************************

Question 3:

Answer :b. SQL Server 2005

Explanation :SQL Server 2017 supports compatibility mode for SQL Server 2005.

***************************

Question 4:

Answer :

c.Server-side networking for SQL Server is configured at the Database level

g. You can have multiple versions of SQL Server installed on the same virtual server

***************************

Question 5:

Answer :b. use AdventureWorks2014; SELECT * FROM INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'

Explanation :use AdventureWorks2014; SELECT * FROM INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE' command will lists all the tables in AdventureWorks2014.

***************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.

venereology answered 1 week ago

Enter the letters corresponding to all the true statements. 1. At a certain location there is...

Enter the letters corresponding to all the true statements. 1. At a certain location there is a constant horizontal magnetic field pointing to the east. A square loop of wire is placed in this field. At time A the bottom of the loop is resting on the floor (which is insulating), and the plane of the square loop is vertical and perpendicular to the magnetic field. The loop tips over and at time B it is flat on the floor....

Select all of the statements that are true. 1. Membranes can contain lipids, proteins, and carbohydrates....

Select all of the statements that are true. 1. Membranes can contain lipids, proteins, and carbohydrates. 2. Fatty acids will form a membrane bilayer in an aqueous solution. 3. Membranes are static. 4. Membrane composition is symmetrical.

Please answer all questions Select from among the statements below any or all that are true....

Please answer all questions Select from among the statements below any or all that are true. A. An employee handbook can never serve as the basis for a claim by an employee against an employer. B. If an employee handbook states that it is not a contract, the employer is free to pick which provisions are enforceable. C. An employee handbook can never serve as the basis for a claim by an employer against an employee. D. If an employee...

Select all of the following statements that are true A.Carbohydrates can never be used as secondary...

Select all of the following statements that are true A.Carbohydrates can never be used as secondary messengers because they would inevitably be drawn into the cell's fuel metabolism pathways B. Eukaryotic cells contain proteins that can detect misfolded proteins by virtue of their contacts with carbohydrates that are attached to those proteins C. Carbohydrates are used by some bacterial pathogens to survive after phagocytosis by the host organism's white blood cells D. Viruses employ lectins during both entry and exit...

1. Which of the following statements are true? Select all that apply. Select one or more:...

1. Which of the following statements are true? Select all that apply. Select one or more: a. Earnings per share is calculated by dividing retained earnings by the number of shares of common stock outstanding. b. The creditors of a firm must be satisfied before any earnings can be distributed to the common shareholders. c. When referring to ratio comparisons, time-series analysis compares a firm to that of an industry leader. d. The operating profit margin must take into account...

1. a)Which of the following statements are TRUE for a buffer solution. Select all that are...

1. a)Which of the following statements are TRUE for a buffer solution. Select all that are True. _ A buffer can be prepared by combining a weak acid and its conjugate base." _ A buffer resists changes in pH. _ When a strong acid is added to a buffer, it reacts with the conjugate base which slightly increases the pH of the solution. 3. Given the following data set: Indicate where the buffere capacity has been exceeded. Solution pH Change...

Which of the following statements are/is true? Select all that apply. A. Stateful inspection firewalls can...

Which of the following statements are/is true? Select all that apply. A. Stateful inspection firewalls can detect SYN attacks. B. Both application-level and circuit-level gateways do not allow a direct end-to-end connection between the connecting parties. C. Stateful inspection firewalls, circuit-level gateways and application-level gateways provide reactive network defense, whereas packet filtering firewalls provide proactive network defense.

Which of the following are true statements about ketones? Select all that apply: Acetone can be...

Which of the following are true statements about ketones? Select all that apply: Acetone can be used as a solvent for lacquer (including fingernail polish). They each contain a functional group in the middle of a carbon chain with the structure −CO. They are named using the suffix -al. They are named using the suffix -one.

Which 3 statements are true about purchase orders in QuickBooks Online?(Select all that apply) You can...

Which 3 statements are true about purchase orders in QuickBooks Online?(Select all that apply) You can only create purchase orders for inventory You can close individual lines on a purchase order You can add purchase orders to any type of purchase transaction QuickBooks Online closes purchase orders, even when not fully received You can add multiple purchase orders to one purchase transaction

Can you explain the means of “where, from, select”? Of SQL

Question

SQL Questions 1. Select ALL of the TRUE statements. a. You can control the location of...

Solutions

Expert Solution

Related Solutions

Enter the letters corresponding to all the true statements. 1. At a certain location there is...

Select all of the statements that are true. 1. Membranes can contain lipids, proteins, and carbohydrates....

Please answer all questions Select from among the statements below any or all that are true....

Select all of the following statements that are true A.Carbohydrates can never be used as secondary...

1. Which of the following statements are true? Select all that apply. Select one or more:...

1. a)Which of the following statements are TRUE for a buffer solution. Select all that are...

Which of the following statements are/is true? Select all that apply. A. Stateful inspection firewalls can...

Which of the following are true statements about ketones? Select all that apply: Acetone can be...

Which 3 statements are true about purchase orders in QuickBooks Online?(Select all that apply) You can...

Can you explain the means of “where, from, select”? Of SQL