Which of the following LINQ expressions sorts the data by LastName field in ascending order, with records with the same last name sorted by FirstName field in descending order? Dim records = In NamesDataSet.tblNames Order By Name From name name, LastName Ascending Descending FirstName Choose a name Dim records = From name Order By name In NamesDataSet.tblNames LastName, firstname Descending FirstName Choose a name Dim records = Order By NamesDataSet.tblNames Select name From NamesDataSet.tblNames Name, FirstName Descending Both a and b are correct for LastName d.

Which of the following LINQ expressions sorts the data by LastName field in ascending order, with records with the same last name sorted by FirstName field in descending order? Dim records = In NamesDataSet.tblNames Order By Name From name name, LastName Ascending Descending FirstName Choose a name Dim records = From name Order By name In NamesDataSet.tblNames LastName, firstname Descending FirstName Choose a name Dim records = Order By NamesDataSet.tblNames Select name From NamesDataSet.tblNames Name, FirstName Descending Both a and b are correct for LastName d.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter8: Restricting Rows And Sorting Data

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.
Which of the following LINQ statements arranges the records in ascending order by the LastName field, with records having the same last name arranged in descending order by the FirstName field?a. Dim records = From name In NamesDataSet.tblNames Order By name.LastName Ascending, name.FirstName Descending Select nameb. Dim records = From name In NamesDataSet.tblNames Order By name.LastName, name.FirstName Descending Select namec. Dim records = Select name From NamesDataSet.tblNames Order By name.FirstName Descending, name.LastNamed. both a and b
Which of the following will select only records whose CityName field begins with an uppercase letter S?a. Dim records = From name In CitiesDataSet.tblCities Where name.CityName Like "S*" Select nameb. Dim records = From CitiesDataSet.tblCities Select CityName Like "S*"c. Dim records = From tblCities Where tblCities.CityName Like "S*" Select named. Dim records = From name In CitiesDataSet.tblCities Where tblCities.CityName Like "S*" Select name
Which of the following displays the order date for order 1000 as 03/31? (refer to the tables in the JustLee Books database.)a. SELECT TO_CHAR(orderdate, 'MM/DD')FROM ordersWHERE order# ¼ 1000;b. SELECT TO_CHAR(orderdate, 'Mth/DD')FROM ordersWHERE order# ¼ 1000;c. SELECT TO_CHAR(orderdate, 'MONTH/YY')FROM ordersWHERE order# ¼ 1000;d. both a and be. none of the above
Which of the following operators is used to find all values greater than the highest value returned by a subquery? (refer to the tables in the JustLee Books database.) a. >ALL b. < ALL c. >ANY d.< ANY e. IN
Which of the following SQL statements displays a customer’s name in all uppercase characters? (refer to the tables in the JustLee Books database.)a. SELECT UPPER('firstname', 'lastname')FROM customers;b. SELECT UPPER(firstname, lastname)FROM customers;c. SELECT UPPER(lastname, ',' firstname)FROM customers;d. none of the above
Which of the following statements retrieves data from the Friends database and stores it in the FriendsDataSet?a. Me.FriendsDataSet.Fill(Friends.accdb)b. Me.TblNamesBindingSource.Fill(Me.FriendsDataSet)c. Me.TblNamesBindingNavigator.Fill(Me.FriendsDataSet.tblNames)d. Me.TblNamesTableAdapter.Fill(Me.FriendsDataSet.tblNames)
Which of the following SQL statements changes the size of the Title column in the BOOKS table from the current length of 30 characters to the length of 35 characters? (refer to the tables in the JustLee Books database)a. ALTER TABLE books CHANGE title VARCHAR(35);b. ALTER TABLE books MODIFY (title VARCHAR2(35));c. ALTER TABLE books MODIFY title (VARCHAR2(35));d. ALTER TABLE books MODIFY (title VARCHAR2(+5))
Database Q1: Which one of the following INSERT statements will successfully insert a single row? The following table has been created: CREATE TABLE student_table ( stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ; a) INSERT VALUES INTO student_table (143354, ‘Roberts’, ‘Cameron’, 6543); b) INSERT INTO student_table COLMUNS (stud_id, last_name, lunch_num) VALUES (143352, ‘Roberts’, 5543, ‘Cameron’); c) INSERT TO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, ‘Cameron’, ‘Roberts’); d) INSERT INTO student_table VALUES (143354, ‘Roberts’, ‘Cameron’, 6543); Q2: What does the following SQL statement display: SELECT EMP_ID, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY > (SELECT MIN (E. SALARY) FROM EMPLOYEES E) ORDER BY SALARY DESC; a) Employees information who earn less money than the maximum salary b) Employees information who earn more money than the highest employee salary c) Employees information who earn…
Which of the following functions can be used to substitute a value for a NULL value? (refer to the tables in the JustLee Books database.)a. NVLb. TRUNCc. NVL2d. SUBSTRe. both a and df. both a and c
Which of the following functions can be used to display the character string FLORIDA in the query results whenever FL is entered in the State field? (refer to the tables in the JustLee Books database.)a. SUBSTRb. NVL2c. REPLACEd. TRUNCe. none of the above
Which of the following statements is correct about the MD5 value used with evidence file verification? EnCase calculates an MD5 value on the header and metadata only because that is the most important hidden information EnCase calculates the MD5 value on every aspect of the evidence file to ensure that all data is taken into consideration EnCase does not use the MD5 has in evidence file verification EnCase only calculates an MD5 value for data only. No other data such as header, CRC, or metadata is included