Q2.
You are developing an SQL statement to create a data table. Which two SQL keywords can be used in the CREATE TABLE statement?
(Please select 2 answers.) a. INSERT INTO b. ORDER BY C. PRIMARY KEY D. CONSTRAINT ANS: CD
Q4 You created a table called Games that contains review scores for recently released video games.
You need to create a view that returns an alphabetical list of game titles. Name represents the game name. Which query should you use? a. CREATE VIEW MyGames AS SELECT Name FROM Games b. CREATE VIEW MyGames AS SELECT FROM Games c. CREATE VIEW MyGames AS SELECT Name FROM Games ORDER BY Name d. CREATE VIEW MyGames AS SELECT from Games WHERE Name BETWEEN 'A' AND 'Z' ANS:C
Q5 For each of the following statements, please select [Correct] or [False]. PLEASE NOTE: Partial points are awarded for each item answered correctly.
A full database backup is a copy of all data in the entire database. Transaction log backup backs up all data in the database. A differential backup will only copy data that has changed before the last full backup. A file or filegroup restore specifies the portion of the database to restore. ANS:OXXO
Q2 您正在開發一個 SQL 陳述式以建立資料表。 請問哪兩個 SQL 關鍵字可用於 CREATE TABLE 陳述式?(請選擇2個答案。) A.INSERT INTO B.ORDER BY C. PRIMARY KEY D. CONSTRAINT ANS: CD
Q5 對於下列每一項敘述,請選取[正確]或[錯誤】。 請注意:每一個答對的項目都能獲得部分分數。
完整資料庫備份就是整個資料庫中所有資料的複本。 交易記錄備份會備份資料庫中的所有資料。 差異備份只會複製上次完整備份之前變更的資料。 檔案或檔案群組還原會指定要復原的資料庫部分。 ANS:OXXO