Which of the following statements is a valid reason for using a view? Mark for Review 1 Points Views allow access to the data because the view displays all of the columns from the table. Views are not valid unless you have more than one user. Views provide data independence for infrequent users and application programs. One view can be used to retrieve data from several tables.
Views can be used to provide data security. Luke, a database user, must create a report that includes the names and addresses of all employees. Which of the following actions should you perform first? Mark for Review 1 Points Create an index. Create a subquery. Create a view. In a special database column of a users table.
How do you remove a view? You cannot modify data in a view if the view contains a group function. Unlike tables, views contain no data of their own. Any select statement can be stored in the database as a view. Views must be used to select data from a table. As soon as a view is created on a table, you can no longer select directly from the table. You plan to grant access to this view to members of the Sales department.
An inline view is an unnamed select statement found: Mark for Review 1 Points In a special database column of a users table. Correct Correct 4. Mark for Review 1 Points The statement failed to execute because an inline view was used. Correct Correct 5. In order to query a database using a view, which of the following statements applies? Mark for Review 1 Points You can retrieve data from a view as you would from any table.
The tables you are selecting from can be empty, yet the view still returns the original data from those tables. You can never see all the rows in the table through the view. When both statements are executed all of the desired results are achieved. You want to create a view that will simplify the creation of this report.
Which option would you use when creating a view to ensure that no DML operations occur on the view? Correct Correct 2. Correct Correct 3. Which option would you use to modify a view rather than dropping it and recreating it? None of the above Correct Correct Which of the following describes a top-N query? Lanjut ke konten Section 10 Quiz Answer all questions in this section 1.
Mark for Review 1 Points Subqueries generally execute last, after the main or outer query executes. Mark for Review 1 Points The results of the inner query are returned to the outer query.
Mark for Review 1 Points No rows would be returned by the outer query. Refer to Section 10 Lesson 3. Bagikan ini: Twitter Facebook. Menyukai ini: Suka Memuat Previous post Quiz 9. Next post Quiz 10 Database Programming. Tinggalkan Balasan Batalkan balasan Ketikkan komentar di sini Isikan data di bawah atau klik salah satu ikon untuk log in:.
Email wajib Alamat takkan pernah dipublikasikan. Nama wajib. Situs web. Ikuti Mengikuti. Selembar kertas kehidupan. Daftarkan saya. Sudah punya akun WordPress. Login sekarang. You need to add a row to an existing table.
Which DML statement should you use? Assume all the column names are correct. The following SQL statement will execute which of the following? Correct Correct 3. No rows, as you cannot use subqueries in an insert statement. Correct Correct 5. Mark for Review 1 Points The row was created with the correct data in two of three columns. The row was created completely wrong. A column in a table can be given a default value.
This option prevents NULL values from automatically being assigned to the column if a row is inserted without a specified value for the column. Multi-table inserts can be conditional or unconditional. True or false? You need to update the expiration date of products manufactured before June 30th. If the subquery returns one row, how many rows will be deleted from the employees table?
One row will be deleted, as the subquery only returns one row. All rows in the employees table of employees who work in the given department will be deleted.
One of the sales representatives, Janet Roper, has informed you that she was recently married, and she has requested that you update her name in the employee database. Her new last name is Cooper. Janet is the only person with the last name of Roper that is employed by the company. Mark for Review 1 Points The table is removed from the database. All rows are deleted from the table. The statement will not execute. When inserting a new row, the null keyword can be included in the values list for any column that allows nulls.
Yes, you can just list as many rows as you want; just remember to separate the rows with commas. Use the ON clause Omit the column in the column list. An error message is displayed indicating incorrect syntax. Correct Correct 2. The row was created with the correct data in one of the three columns.
0コメント