Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 1 (2.5 points) A combination of column names and operators that evaluate to a single value is called a query an expression a predicate
Question 1 (2.5 points) A combination of column names and operators that evaluate to a single value is called a query an expression a predicate a view Question 2 (2.5 points) Which of the following is not a SQL DML statement? Insert Update Select Create Table Question 3 (2.5 points) Which of the following is not a valid column alias name? Total Total Sales TotalSales "Total Sales" Question 4 (2.5 points) When you code an ORDER BY clause, you can specify a column name or alias column name or expression column name, alias, or expression column name, alias, expression, or column number Question 5 (2.5 points) You can create a database diagram for up to 3 tables in a database just the tables in a one-to-many relationship just the related tables in a database any combination of the tables in a database Question 6 (2.5 points) If you try to move a database file that's attached to a server, you'll get an error message that indicates the file is in use. To get around this, you need to the database from the server. delete disconnect remove detach Which of the following expressions will not compute 10% of the balance due if balance due is the invoice total minus the credit total minus the payment total? InvoiceTotal CreditTotal Payment Total / 10 (InvoiceTotal Payment Total CreditTotal) / 10 (Invoice Total (PaymentTotal + Credittotal)) * 0.10 ((Invoice Total Payment Total) CreditTotal) / 10 Question 8 (2.5 points) When you set the compatibility level of SQL Server 2016, you make sure it is compatible with a specific version of standard SQL SQL Server DDL statements DML statements Question 9 (2.5 points) The order of precedence for the logical operators in a WHERE clause is Not, And, Or And, Or, Not Or, And, Not Not, Or, And
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started