新建题库06241051

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

随机练习 自定义设置练习量

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

You successfully executed a PDO-based query in a PHP application. You must add a condition to accurately identify only NULLs. Which two conditions will do this?

A MySQL server has been provided self signed certificates by your corporate Certificate Authority. The server is only accessible from your private network and all name resolution is provided by a private DNS service. Which two statements are true?

Which three evaluate to a temporal value?

Examine this statement which executes successfully: DELIMITER // CREATE PROCEDURE test_cursor(OUT city_name VARCHAR(100)) BEGIN DECLARE count INT DEFAULT 0; DECLARE cur CURSOR FOR SELECT name FROM city; DECLARE EXIT HANDLER FOR NOT FOUND SELECT count; OPEN cur; LOOP FETCH cur INTO city_name; SET count = count+1; END LOOP; END // DELIMITER ; You execute this statement: CALL test_cursor(@city); Which two are true about the execution?

Which two of these benefit from having a connection pool?

Which two commands display information to troubleshoot a SQL statement that does not execute as expected?

Which two statements are true about aggregate functions?

Which two are true about PREPARE statements?

A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application. The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host. Examine the PDO connection string used in the existing application: Mysql:host=localhost;dbname=sales;unix_socket=/var/run/mysql.sock Which two prevent Java from using the Unix socket?

Examine these statements which execute successfully: CREATE TABLE `band` ( `song` varchar(50) NOT NULL, `year` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; SELECT ∗ FROM band; +-----------------------------+------+ | song | year | +-----------------------------+------+ | Come Together | 1969 | | The Long and Winding Road | 1970 | | The Fool on the Hill | 1967 | | Hey Jude | 1968 | | Here Comes the Sun | 1969 | | Love Me Do | 1963 | +-----------------------------+------+ Now, examine this desired output: +-----------------------------+------+ | song | year | +-----------------------------+------+ | The Fool on the Hill | 1967 | +-----------------------------+------+ Which two queries will produce the output?

What are three general advantages to prepared statements?

Examine this CRUD operation:

JS> col.find()

{

"_id": "00005e8585eb000000000000000009",

"name": "fred"

}

One document in set (0.003 sec)

Which two SQL statements are valid?

You must write a statement that can insert the last name O'Hara into a column of the customers table. Which two INSERT statements meet your requirement?

Which two are true about MySQL Document Store?

Examine this statement: DECLARE not_found CONDITION FOR SQLSTATE '02000'; In which two statements can not_found be used?

You must reclaim memory used by a prepared statement named prep. Which two achieve this?

Which two are true about MySQL connectors?

Examine these statements issued from Session 1 which execute successfully: Session 1> SET autocommit=1; SELECT ∗ FROM band FOR UPDATE; Now, examine these statements issued from Session 2 which execute successfully: Session 2> BEGIN; UPDATE band SET song=CONCAT("Here Comes the ", song) WHERE song LIKE '%Sun'; Which two are true?

Your session has sql_mode set to default. Examine this statement which executes successfully: CREATE TABLE students ( std_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, firstname varchar(255) NOT NULL, lastname varchar(255) NOT NULL, birthdate date NOT NULL, reg_date datetime NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=10300; Now examine this statement: INSERT INTO students (std_id, firstname, lastname, birthdate, reg_date) VALUES ("NULL", "Mary", "O'Hagen", '1997-11-26', DATE ()); Which two changes are required to the insert statement so that it inserts the correct data?

Examine this bar graph based on columns from the players table: +--------+--------+---------+------------------+ | Name | Gender | Sport | GPA_Graph | +--------+--------+---------+------------------+ | Elaine | F | Netball | #################| | Frank | M | Polo | ############### | | Charles| M | Polo | ############## | | Isabel | F | Netball | ############ | | Julie | F | Netball | ########## | | Harriet| F | Hockey | ######## | | Larry | M | Hockey | #### | | David | M | NULL | # | +--------+--------+---------+------------------+ Which two statements would generate this bar graph?