D427 PA Exam 25 Questions with Verified Answers,100% CORRECT, Exams of Nursing

Download D427 PA Exam 25 Questions with Verified Answers,100% CORRECT and more Exams Nursing in PDF only on Docsity! D427 PA Exam 25 Questions with Verified Answers San Francisco, CA 94110 USA How many attributes are present in the address fragment? - CORRECT ANSWER 4 The Package table has the following columns: Weight—decimal Description—optional variable length string LastChangedDate—date TrackingNumber—integer Which column should be designated the primary key for the Package table? - CORRECT ANSWER TrackingNumber Which data type will store "2022-01-10 14:22:12" as a temporal value without loss of information? - CORRECT ANSWER DATETIME Which SQL command is an example of data definition language (DDL)? - CORRECT ANSWER ALTER How would a database engine process an update that violates a RESTRICT referential integrity constraint? - CORRECT ANSWER The update would be rejected by the database The Member table will have the following columns: ID—positive integer FirstName—variable-length string with up to 100 characters MiddleInitial—fixed-length string with 1 character LastName—variable-length string with up to 100 characters DateOfBirth—date AnnualPledge—positive decimal value representing a cost of up to $999,999, with 2 digits for cents Write a SQL statement to create the Member table. - CORRECT ANSWER CREATE TABLE Member( ID INT UNSIGNED, FirstName VARCHAR(100), MiddleInitial VARCHAR(1), LastName VARCHAR(100), DateOfBirth DATE, AnnualPledge DECIMAL(8,2) UNSIGNED ); The Rating table has the following columns: RatingCode—variable-length string, primary key RatingDescription—variable-length string The Movie table should have the following columns: Title—variable-length string, maximum 30 characters RatingCode—variable-length string, maximum 5 characters Write a SQL statement to create the Movie table. Designate the RatingCode column in the Movie table as a foreign key to the RatingCode column in the Rating table. - CORRECT ANSWER CREATE TABLE Movie( Title VARCHAR(30), RatingCode VARCHAR(5), FOREIGN KEY(RatingCode) REFERENCES Rating(RatingCode) ); Which restriction applies when using a materialized view? - CORRECT ANSWER The underlying data must be periodically refreshed. The Movie table has the following columns: ID—integer, primary key The Movie table has the following columns: ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer Write a SQL query to retrieve the Title and Genre values for all records in the Movie table with a Year value of 2020. Ensure your result set returns the columns in the order indicated. - CORRECT ANSWER SELECT Title, Genre FROM Movie WHERE Year=2020; The Movie table has the following columns: ID—integer, primary key, auto-increment Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer The following data needs to be added to the Movie table: Title: Pride and Prejudice Genre: Romance RatingCode: G Year: 2005 Write a SQL statement to insert the indicated data into the Movie table. - CORRECT ANSWER INSERT INTO Movie(Title, Genre, RatingCode, Year) VALUES ('Pride and Prejudice','Romance','G',2005); The Movie table has the following columns:\ ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer Write a SQL statement to delete the row with the ID value of 3 from the Movie table. - CORRECT ANSWER DELETE FROM Movie WHERE ID=3; The Movie table has the following columns: ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer Write a SQL statement to update the Year value to be 2022 for all movies with a Year value of 2020. - CORRECT ANSWER UPDATE Movie SET Year=2022 WHERE Year=2020; The database contains a table named Movie. Write a SQL query to return all data from the Movie table without directly referencing any column names. - CORRECT ANSWER SELECT * FROM Movie; The Movie table has the following columns: ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer Write a SQL query to display all Title values in alphabetical order A-Z. - CORRECT ANSWER SELECT Title FROM Movie ORDER BY Title ASC; The Movie table has the following columns: ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer Write a SQL query to output the unique RatingCode values and the number of movies with each rating value from the Movie table as RatingCodeCount. Sort the results by the RatingCode in alphabetical order A-Z. Ensure your result set returns the columns in the order indicated. - CORRECT ANSWER SELECT RatingCode, COUNT(*) AS RatingCodeCount FROM Movie GROUP BY RatingCode ORDER BY RatingCode ASC; Which query illustrates performing an outer join of the Movie table with a different table? - CORRECT ANSWER SELECT M.Title, A.Actor FROM Movie M RIGHT JOIN Actor A ON M.ACTORID =A.ID; Assume there are two tables, A and B. Which rows will always be included in the result set if Table A is inner joined with Table B? - CORRECT ANSWER Only rows in Tables A and B that share the join condition The Movie table has the following columns: ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer